Large tables is relative. How do you define "large table"?

Like Allen, I would be interested in knowing what blocking issues have been observed. And I would also be interested in the...

How many rows are in that table?

How many shall remain after your job is done?

If you're about to delete more than there will remain, it might be an option to...

sysperfinfo is a fake table. That is an in-memory structure that only materializes in tabular form when queried. As Steve already said, I don't think you can do this.

You might also find this article interesting: http://www.sommarskog.se/dyn-search.html

http://www.sommarskog.se/error-handling-II.html

http://www.sommarskog.se/error-handling-I.html

Ouch! Sorry to hear that.

The "best" answer here is, to do this at the client. For some ideas on how to do this on the server have a look here: http://support.microsoft.com/default.aspx?scid=kb;en-us;186133

You are aware that the next version might turn the system tables upside down? I would see if you can't utilize the INFORMATION_SCHEMA views for most of this stuff.

I'm not...

Allen, I'm fine. And you?

Yes, you're right. 0x80 identifies an IDENTITY column.

Maybe I've overshoot the mark here.

FWIW, here are some links:

http://www.microsoft.com/india/msdn/articles/116.aspx

http://www.codeproject.com/database/dmetaphone4.asp

sysindexes and sysindexkeys for the keys. and for IDENTITIES you might have luck with IDENT_CURRENT, IDENT_INCR and IDENT_SEED. Along with maybe OBJECTPROPERTY, COLUMNPROPERTY and INDEXKEY_PROPERTY

Maybe this will get you going:

SELECT

 CAST(SO.[name] AS...

Also not sure why, but what about scripting all code into one file and use an ordinary text editor?

The '19000101' is just an adjustment to SQL Server's base date. This is possibly best explained with an example:

DECLARE @dt DATETIME

SET @dt = GETDATE()

SELECT

 DATEDIFF(minute,0,@dt) Min_Between_BaseDate_And_Now

 , DATEDIFF(minute,'19000101',@dt) Same_As_1

 , DATEDIFF(minute,'19000101',@dt) / 5...

Not entirely sure if I understand, but this should give you some ideas to go on:

CREATE TABLE #time

(

 ID INT IDENTITY

 , dt DATETIME

 , ReasonID INT

)

INSERT INTO #time

SELECT '20050427 10:50:00', NULL

UNION ALL

SELECT '20050427 10:51:00',...