Mr. .NET

Microsoft SQL Server - Using EXISTS - SQLTeam.com

peed Up SQL Server SELECT DISTINCT Queries

Dynamic SQL or Stored Procedure

The Code Project - SQL Server 2000 - Merge Replication Step by Step Procedure - Database

Replication Overview

The Administrator's Guide to Microsoft SQL Server 6.5

How to stop the transaction log of a SQL Server database from growing unexpectedly

ASPAlliance.com : ASP and ASP.NET Tutorials : Where's My Assembly!?

Give the Visual Studio Snippet Format a Whirl with 10 Pre-packaged Snippets

An Introduction to the New Visual Studio Snippet Format

Provisional Driving Licence

Provisional Driving Licence

Learn French - Self-Study Checklist

Learn French - Self-Study Checklist

De vs Du, De la, Des - French Prepositions and Articles - About the French Language

De vs Du, De la, Des - French Prepositions and Articles - About the French Language

De vs Du, De la, Des - French Prepositions and Articles - About the French Language

De vs Du, De la, Des - French Prepositions and Articles - About the French Language

Il y a - French expression Il y a

Il y a - French expression Il y a

French Grammar Lessons - Grammaire fran�aise - Lessons on French Grammar

French Grammar Lessons - Grammaire fran�aise - Lessons on French Grammar

ExRx Exercise

ExRx Exercise & Muscle Directory

TeenBodybuilding.com - John Lemare - 10 Nutritional Mistakes!

TeenBodybuilding.com - John Lemare - 10 Nutritional Mistakes!

Quickly Moving Databases

Quickly Moving Databases

SQL Server User Defined Function for Business Days Calculation

SQL Server User Defined Function for Business Days Calculation

CREATE INDEX

CREATE INDEX

Understanding Locking in SQL Server

Understanding Locking in SQL Server

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

99 shades of grey � straight to the bar

See George Run: Weight Lifting

The Weightlifting and Powerlifting Chronicles

kbAlertz: (837908) - Describes the different ways to refer to the assemblies that are put in different folders.