BULK INSERT is faster but not considerably. if you want to insert from TSQL the use BULK insert if from DOS then use bcp. There is no benefit in trying...

Wellnot to blow my own trumpet I did the OPENXML chapter for the book below. And I believe it is the only bokk that covers the issues of actually using...

using query analyser will cut of text according to the setting in query Analyser| options (SET TEXTSIZE as well)

Have a look at my stored procedure to script a stored procedure

http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=585

a...

The problem is that is likely to cause a recompile after the populate of the temp table

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

You can use xp_cmdshell to run an exe or use the sp_oa.. stored procedures to interact with a com dll.

However doing this in a trigger is not advised. It will...

All I can say is CURSOR. What does findUPIDMatch2 do.

Firstly I hate cursors so don't use them much. I might be wrong in these statements but you I would...

Why can't you install OS to a RAID 5. The RAID is controlled by the card and so irrelevant to the OS. I thought!

I would go for RAID10 rather than...

If the column is not part of an index then the indexes may still need updating if the data you are updating with causes rows to be moved off pages,...

I have thought of the simple things you can do and the one thing I keep coming back to is that you probably don't need that many SPs. you can...

How are you doing the remote query?

linkedserver.dbname.dbo.spName

or

openquery(linkedServer,'dbname.dbo.spName')

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

I can't give you a definite answer but I would be 90% sure to day it would break. You will need to apply a backup after the new filegroup is...

Not critising your code, but in my experience, anything that takes 3 hours to run can be improved upon, and if there are improvements then this generally means that the...

It is even worse if you use OPENROWSET. Any rowset function returns the same cost irrespective of what is being returned. This is very dangerous when you join to such...

Try

DECLARE @MyNTextValue varchar(214)

SET @MyNTextValue = (SELECT SUBSTRING(MyNTextField ,1,214)

FROM MyTable WHERE id = 1)

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

I don't believe functions are supported on linked servers either change it to an SP or use some really bad dynamic SQL (string building).

I am not 100% so I...