Microsoft SQL Server Tips & Tricks

With Sql server 2000 and 2005 computed columns can be use to improve the performance of queries since without the computed columns, indexes cannot be used as explained in the following blog by one of our Escalation Engineer Jack Li. http://blogs.msdn.com/psssql/archive/2009/03/09/how-to-use-computed-columns-to-improve-query-performance.aspx Read More...

While running your application on SQL CE v3.1 databases you may observe slowness in the performance of some of the queries especially those which involve querying the primary key. In Sql server databases when you create a Primary Key on a column of a Read More...

Most of the Customers using sql server 2000,2005 and 2008 have this doubt in their mind when using parallelism in sql server. Why Do I see more threads per SPID in sysprocesses than MAXDOP? The above question is being addressed in the following blog by Read More...

Sometimes the query performance degrades due to the out of sync stats on the tables in the database. But how do we know it and how we do reach at the conclusion that the stats are the cause of the performance degradation. This is pretty well known but Read More...

We have observed a few cases now where sql server has started performing slow after changing the Cost Threshold Of Parallelism server option of the sql server. Ironically in such cases we observe that sql server is performing slow even when there is no Read More...

The performance issue of the SQL Server can be anything from the connectivity issue of the application to Query running slow or query timeouts. So the first thing that we need to find out during the performance troubleshooting is to find what is the exact Read More...