2009-03-04
4,031 reads
2009-03-04
4,031 reads
Deleting all the data in a SQL Server database doesn't have to involve complex code. The undocumented stored procedure sp_MSForEachTable safely bypasses built-in limitations to accomplish this common task.
2009-03-03
4,786 reads
2009-03-02
4,285 reads
Sixth in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures
2009-04-15 (first published: 2009-02-26)
1,394 reads
Fifth in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures
2009-04-03 (first published: 2009-02-23)
1,248 reads
In which Phil illustrates an old trick using STUFF to intert a number of substrings from a table into a string, and explains why the technique might speed up your code...
2009-02-18
1,631 reads
Fourth in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures
2013-10-31 (first published: 2009-02-17)
10,199 reads
2013-01-03 (first published: 2009-02-17)
7,379 reads
2009-02-17
4,812 reads
Third in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures
2011-03-30 (first published: 2009-02-16)
2,387 reads
By Steve Jones
I have often made an effort to attend conferences in the past to grow...
Another discussion in Gothenburg (such a great group of people) around Extended Events lead...
Let's be honest – SQL can be a bit of a beast. At first...
Comments posted to this topic are about the item New article
Comments posted to this topic are about the item Monitoring Azure Blob Storage
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers