10 SQL Snippets For Faster, More Effective Code
How many hours per week do you spend writing the same SQL again and again?
2015-07-16
6,296 reads
Gaurav Vohra
How to Unlock Your Team's Creative Power with SQL Prompt and a VCS
Extend SQL Prompt's functionality by connecting your snippets to version control
2015-07-09
1,474 reads
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
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...
XQuery - Use column value to display correct node
Hi All First time with XQuery and despite trying to read as many guides...
Ask SSC