|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL Server database programmingmicrosoft.public.sqlserver.programming
Queryplan differs with simple values
Bobstar -
24 Feb 2007 11:00 PM - 1 message
Hello... Im having a hard time finetuning my queries. Im using SQL2000 Enterprise with SP3. I've a table with approximately 500.000.000 rows in and for some strange reason I get different queryplans according to similar where clauses, take a ...
Constraint in SQL 2005
RickSean -
23 Feb 2007 8:41 PM - 1 message
what's the difference between the following two CONSTRAINT created by SQl Server 2005 (Script Table As -> CREATE To) CONSTRAINT [MyColumn1$PrimaryKey] PRIMARY KEY CLUSTERED CONSTRAINT [PK_MyColumn1] PRIMARY KEY CLUSTERED ...
|
|||||||||||||||||||||||