Set-Based String Splitting table function
Describe and provide a set-based method that takes a multiple character split term and returns as a table
2018-03-19
2,613 reads
bevan ward
Solve Sudoku with T-SQL - Part 1
A Sudoku solution can be resolved using a single select statement. The first article shows this method and next how this can be optimised to resolve complex puzzles in seconds.
2018-02-20
2,572 reads
Formatted ASCII Results from a SELECT
Generate aligned output from SELECT statement for code comments using a simple stored procedure.
2018-01-18
1,864 reads
Blogs
What goes around comes around : T-SQL Tuesday #129
I almost died. I’m sure a lot of you already know this but just...
My T-SQL Tuesday #129 Time Capsule
By Steve Jones
This month the T-SQL Tuesday invitation comes from Tamara Clark. I strong-armed Tamara last...
Azure Database Administrator
By Arun Sirpal
Recently I found out that I passed the BETA exam for Azure Database Administrator...
Forums
Send me an email if this job run longer than 30 minutes
Hi I have a job that I need to be notified/emailed if it runs...
Time out expired on the application side
Hi I have an application that is timing out i run the query...
Ask SSC