My standard course of action is to back the databases up, and restore with the move option to the new location. This gives me an opportunity to test the backup/restore...

Here is an example from one of my procs, where I grab results from a dynamic query:

set @sql = N'SELECT @val = ImportText FROM ' + @DestTableName2 + ' Where...

It was actually pretty common back in the early eighties.......but I haven't seen it myself in many many years....

That's the way I deal with it, Antares. I have another set of statements which re-uses deleted keys as well, by selecting the first out of sequence number (left outer...

Here is a relevant document:

http://www.sqlservercentral.com/columnists/ckirkwood/wait_types.asp

Service Pack 3 addresses a huge amount of security considerations, and changes the architecture of internal securities in several cases. I would suggest you look into the securities related changes...

I do not believe the HOLDLOCK is useful in this case. What usually happens is that developers use the HOLDLOCK command, thinking that they can temporarily prevent other users from...

I agree with Brian, Inside SQL Server is invaluable......

If your happy, then good enough. I have yet to find the query optimizer perform as adequately as I do myself, though. Try not to place too much faith in...

LMAO.....That is quite interesting.

I didn't have the time this last weekend to persue this as I had hoped. I apologize. I VERY much believe that you should re-work those views,...

Don't apologize. I was laughing about the fact that we seem to see these about the same times, and you type quicker than me or something. Besides that, your suggestions...

Christ, what a mother of a query. I am sure that a LOT can be done with it, and I'll look over it in detail this...

It IS a view based on other views. Could we get the view definitions for the ones referenced in this one?

Also, what fields are you actually using from this one?

...

LMAO....gotta love it.....

Based on what I've seen in the forums, you do WAY better than most, in my opinion, and I simply couldn't picture you having any problems anyway.

Had to...

Under normal circumstances, a set based statement (such as the method two) will perform better than a cursor. I believe that the answers provided by all the above give the...