Friday, February 10, 2006
Thursday, February 09, 2006
Wednesday, February 08, 2006
Tuesday, February 07, 2006
Monday, February 06, 2006
How to launch Windows applications (Notepad) / Call Batch files from a C#/.NET console application. - The Code Project - C# Programming
Monday, January 30, 2006
Tuesday, January 24, 2006
Wednesday, January 11, 2006
Tuesday, January 10, 2006
Wednesday, December 21, 2005
Thursday, December 15, 2005
Wednesday, December 14, 2005
Thursday, December 08, 2005
Saturday, November 19, 2005
Saturday, November 12, 2005
Log Shipping VS. Replication
http://www.sqlservercentral.com/columnists/pibison/logshippingvsreplication.asp
Thursday, October 27, 2005
Saturday, September 17, 2005
Thursday, September 15, 2005
Friday, September 02, 2005
Thursday, September 01, 2005
kbAlertz: (837908) - Describes the different ways to refer to the assemblies that are put in different folders.
Monday, August 29, 2005
Friday, August 26, 2005
Thursday, August 25, 2005
Tuesday, August 23, 2005
Monday, August 22, 2005
Sunday, August 21, 2005
Saturday, August 20, 2005
Friday, August 19, 2005
Thursday, August 18, 2005
Tuesday, August 16, 2005
SQL Server Transact-SQL Query Performance Tuning and Optimization Tips
If you find that SQL Server uses a TABLE SCAN instead of an INDEX SEEK when you use an IN or OR clause as part of your WHERE clause, even when those columns are covered by an index, consider using an index hint to force the Query Optimizer to use the index.
For example:
SELECT * FROM tblTaskProcesses WHERE nextprocess = 1 AND processid IN (8,32,45)
takes about 3 seconds, while:
SELECT * FROM tblTaskProcesses (INDEX = IX_ProcessID) WHERE nextprocess = 1 AND processid IN (8,32,45)
returns in under a second. [7.0, 2000] Updated 6-21-2004 Contributed by David Ames
SQL Server Transact-SQL Query Performance Tuning and Optimization Tips
