Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Query optimization   (RSS)

Queries May Appear to Run Slow on SQL SERVER COMPACT EDITION v3.1 Database

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...
Posted Sunday, January 18, 2009 2:49 PM by Pariks | 0 Comments

Why Do I see more threads per SPID in sysprocesses than MAXDOP?

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...
Posted Monday, January 05, 2009 11:49 AM by sanjayap | 3 Comments
 
Page view tracker