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,491 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,357 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,663 reads
Blogs
Microsoft Tools That Help Query Tuning
Query tuning is not easy. In fact, for a lot of people, you shouldn’t...
Author of the Year 2019 Nomination at MSSQLTips
This year I’ve been nominated again for the Author of the Year award at...
Extended Events Misperceptions: Profiler is Easier
I know, I know, I’m on #teamexevents so I think that Extended Events can...
Forums
Transcation Log Backup Restoration Time
Hi Is anyone know please advice, how much time will take for restoration 250GB...
Update 22/01/2020 - ICQ678924920 => Sell Credit Card/DeadFullz/Gifts Card
Hi guys! Call me Jack.. Update 22/01/2020 12:04 PM LIST CREDIT CARD AND GIFT...
Ask SSC