Clustered Index Only 1 allowed per table Physically rearranges the data in the table to conform to the index constraints.
SQL SERVER – Raid Configuration – RAID 10
I get question about what configuration of redundant array of inexpensive disks (RAID) I use for my SQL Servers. The answer is short is: RAID 10. Why? Excellent performance with Read and Write. RAID 10 has advantage of both RAID 0 and RAID 1. RAID 10 uses all the drives…
Read MoreSQL SERVER – @@DATEFIRST and SET DATEFIRST Relations and Usage
The master database’s syslanguages table has a DateFirst column that defines the first day of the week for a particular language. SQL Server with US English as default language, SQL Server sets DATEFIRST to 7 (Sunday) by default. We can reset any day as first day of the week using…
Read MoreSQL Server Interview Questions and Answers Complete List Download
This is summary blog post for SQL Server Interview Questions and Answers.
SQL Server Interview Questions and Answers – Part 6
Interview Questions and Answers are now updated with SQL Server 2008 Questions and its answers.
SQL Server Interview Questions and Answers – Part 5
Interview Questions and Answers are now updated with SQL Server 2008 Questions and its answers.
SQL Server Interview Questions and Answers – Part 4
Interview Questions and Answers are now updated with SQL Server 2008 Questions and its answers.
SQL Server Interview Questions and Answers – Part 3
Interview Questions and Answers are now updated with SQL Server 2008 Questions and its answers.
SQL Server Interview Questions and Answers – Part 2
Interview Questions and Answers are now updated with SQL Server 2008 Questions and its answers.