Scripting INSERTs
A little procedure to quickly product a script for copying data from one database to another.
2008-12-29
11,355 reads
Tony Webster
Blogs
Sorting in Stored Procedures – Food for Thought
We know that sorting can be one of the most expensive things in an...
Trace Query in Extended Events
The ability to quickly and easily trace a query is important to database professionals....
Using Erik Darling’s sp_pressure_detector to resolve CPU issues
By DesertDBA
Last Friday I spent my lunch break going through some links I had marked...
Forums
Replication causing log bloating
Hello, We've had a replication process in place for several years. It seems like...
How to import Excel with XML
Hi, I have an Excel sheet that I have to import into SQL Server....
Recursive CTE - Batches
Hi Folks I'm trying to group rows into batch and adding batch to query...
Ask SSC