Demystifying the use of CASE in an ORDER BY statement
Chuck Hoffman exposes the mysteries of getting CASE statements to work in dynamic ORDER BY statements.
2015-06-05 (first published: 2012-04-26)
25,961 reads
Chuck Hoffman
Selecting from hierarchies like Managers and Employees
Chuck Hoffman shows a technique using sets for selecting records from hierarchies such as Manager / Employee structures.
2012-05-03
8,799 reads
TSQL TestBits function for rapidly testing multiple switch settings
Are multiple binary switches becoming hard to manage? The TestBits function can help with that.
2012-04-09
4,060 reads
Blogs
Do you have rarely used indexes that are hurting performance of writes?
By SQLPals
We know that indexes are necessary for query performance but comes with overhead during...
Working with SQLSaturday SpeedPASSes – revamped!
In the Richmond, VA area, I am the organizer for our SQL Saturdays. Among...
Happy Hour at SQL in the City Austin
By Steve Jones
Tomorrow is SQL in the City 2019 – Austin. If you’ve registered, you’re going...
Forums
The Change Failure Rate
Comments posted to this topic are about the item The Change Failure Rate
How to save collapse sections of the query window and save it like that
Hi, My manager would like it that when he collapses certain parts of the...
Ask SSC