Viewing 10 posts - 31 through 41 (of 41 total)
Weird indeed. It has a PK in both SQL Server 2000 and SQL Server 2005 here.
August 2, 2006 at 4:51 am
Hi,
When your DB is selected in SSMS click on Report in the Summary Window and look for the 'Schema Changes History' report. You can profile if you would like to...
August 1, 2006 at 12:52 pm
Very relevant imho 🙂
You need at least build 2040.
July 31, 2006 at 7:35 am
Hi,
SELECT
TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
WHERE OBJECTPROPERTY(OBJECT_ID(TABLE_NAME),
July 28, 2006 at 1:07 pm
Try to CAST it to a CHAR.
SELECT Col_1, COUNT(COL_1) FROM TAB_X
July 28, 2006 at 1:03 pm
Hi,
PAE should not be necessary since you are running Windows x64.
If your SQL Server 2000 is still 32-bit (I haven't tested this) I think you will still need to enable...
July 28, 2006 at 12:59 pm
Executing a sp_updatestats after a reindex might not be a good idea. When you rebuild an index SQL Server updates the statistics for that index with a full scan (since...
July 28, 2006 at 12:48 pm
Varchar(max) is the replacement for text (text will probably be removed in the next version of SQL Server). I would not recommend it as a replacement for large varchar fields.
So...
July 27, 2006 at 12:33 am
Hi,
If you are using SQL Server 2005 the procedure of rebuilding your master and thus resetting the tempdb location. You now have to rebuild it from the command prompt.
FROM BOL:
start...
July 27, 2006 at 12:20 am
TRUNCATE TABLE is logged but in a different way than a normal DELETE.
From BOL: "The DELETE statement removes rows one at a time and records an entry in...
May 4, 2005 at 1:06 am
Viewing 10 posts - 31 through 41 (of 41 total)