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 – 64 bit Architecture and White Paper
In supportability, manageability, scalability, performance, interoperability, and business intelligence, SQL Server 2005 provides far richer 64-bit support than its predecessor. This paper describes these enhancements. Read the original paper here. Following abstract is taken from the same paper. Another interesting article on 64-bit Computing with SQL Server 2005 is here.…
Read MoreSQL SERVER – CASE Statement/Expression Examples and Explanation
CASE expressions can be used in SQL anywhere an expression can be used. Example of where CASE expressions can be used include in the SELECT list, WHERE clauses, HAVING clauses, IN lists, DELETE and UPDATE statements, and inside of built-in functions. Two basic formulations for CASE expression 1) Simple CASE…
Read MoreSQL SERVER – Stored Procedures Advantages and Best Advantage
There are many advantages of Stored Procedures. I was once asked what do I think is the most important feature of Stored Procedure? I have to pick only ONE. It is tough question. I answered : Execution Plan Retention and Reuse (SP are compiled and their execution plan is cached…
Read MoreSQL SERVER – 2005 – Explanation of TRY…CATCH and ERROR Handling
SQL Server 2005 offers a more robust set of tools for handling errors than in previous versions of SQL Server. Deadlocks, which are virtually impossible to handle at the database level in SQL Server 2000, can now be handled with ease. By taking advantage of these new features, you can…
Read MoreSQL SERVER – SP Performance Improvement without changing T-SQL
There are two ways, which can be used to improve the performance of Stored Procedure (SP) without making T-SQL changes in SP. Do not prefix your Stored Procedure with sp_. In SQL Server, all system SPs are prefixed with sp_. When any SP is called which begins sp_ it is…
Read More