November 2010 - Posts

In an earlier post , I highlighted that linked server security configuration can have a huge performance impact, and complained that this was not properly documented in SQL Server Books Online and filed a Connectitem for this. Good news is that in Books Read More...

I have written a lot of throw-away scripts, some of which were written to control the execution of a large number of SQL scripts. The logic of these control scripts is often simple, but their execution can last for a long time (e.g. hours). When writing Read More...

I'm not a SQL Server historian, so I don't know exactly when the global temporary table was first introduced into SQL Server. The feature may have been around since the very genesis of SQL Server. But I know for sure that it has been there since I started Read More...

As a practicing database professional, I'm sure you have done a lot of logging, I mean, output and/or error logging from your scripts, your scheduled jobs, and any other programs you might have written. The primary purpose of logging, of course, is to Read More...

If you use SQL Server Management Studio to generate a script on an existing native log shipping setup, you need to be careful when using that generated script. Other than the fact that it lumps the SQL statements for different servers into the same script Read More...

More specifically, can you create a table in openquery() over a linked server on another SQL Server instance using the SQL Server Native Client OLE DB provider? I don’t know what the official story is on this because I can’t seem to find any explicit Read More...