Or ...

DECLARE @Docs TABLE (DocId Int)

INSERT INTO @Docs(docId)

SELECT d.docId

from [document] as d

where d.containerID = '12345'

DELETE d

FROM [document] as d

INNER JOIN @Docs del

ON d.docId =...

You could approach it from slightly different angle, instead of having two UPDATEs, you could have 1xSELECT and 1xUPDATE

DECLARE @temp XML

SET @temp = (SELECT Column_name FORM Table_name WHERE AuthId =...

Hi,

Review list of possible scenarios you should check that maybe causing this error, with executing sqlcmd command.

http://msdn.microsoft.com/en-us/library/ms190181.aspx

Just to name few:

* Server name was typed incorrectly.

* The SQL Server service on...

There is no simple way of doing it in SQL2k, except passing ntext field from external application as parameter to stored procedure and then parsing it using OPENXML.

If that is...

When troubleshooting connectivity issues with SQL2k5, SQL2k8 I would recommend checking following MSDN article:

SQL2k5 - Troubleshooting: Timeout expired

http://msdn.microsoft.com/en-us/library/ms190181(SQL.90).aspx

SQL2k8 - Troubleshooting: Timeout expired

http://msdn.microsoft.com/en-us/library/ms190181.aspx

Increasing FILLFACTOR may degrade performance of Inserts/Updates on these tables. It's better to test it before it will go to PROD enviroment.

In official white paper from Microsoft commited by...

Does 'SQL Server Browser' service is running on your remote server?

Hi Art,

I would recommend to check James Luetkehoelter post on 'Filegroups Part II: Separating objects' and see other benefits than performance that you could gain from creating few file...

For moving objects between filegroups you can check following article: http://www.mssqltips.com/tip.asp?tip=1112.

Large database could benefit from splitting into filegroups between number of physical devices. Optimizing IO with file groups you...

If you would go with the Linked Servers scenario, what if one of the 50 servers is currently down or some maintenance is being performed on it?

You've got large tables...

You can go even further with splitting the data files between physical drives according to their usage patterns (Read, Read\Write, LOB), but it has better explained in the webcast 'A...

You can also check out sp_who2

From MSDN on ALTER PARTITION ...MERGE , http://msdn.microsoft.com/en-us/library/ms186307(SQL.90).aspx

The filegroup that originally held boundary_value is removed from the partition scheme unless it is used by a remaining partition, or is marked...

I understand that you are running the query with the same parameters, as I remeber having performance problems with different values being passed for the query, and having different execution...

What about using temp table to store criteria IDs, of course you can replace UNION ALL statement with function that will transform coma delimited string with criteria IDs to rowset:

DECLARE...