What are the type of joins? When do we use Outer and Self joins?

3 Answers  

---

Do you know what is a trace frag? Where do we use it?

0 Answers  

---

What is extent? Types of extents?

0 Answers  

---

Is port 1433 secure?

0 Answers  

---

What is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?

3 Answers   Microsoft, TCS, Techastrum,

---

---

What is nonclustered index on computed columns?

0 Answers  

---

What is a Stored Procedure?

8 Answers  

---

how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration

0 Answers  

---

How do you persist objects, permissions in tempdb

1 Answers  

---

What is set nocount on and what is set nocount off?

0 Answers  

---

Can we install sql server 2016 on windows 7?

0 Answers  

---

When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO

1 Answers   Cognizant,

---