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,978 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
9,084 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,069 reads
Blogs
Social: Going Along to Get Along
By Steve Jones
It’s the eve of the Fourth of July, when the Declaration of Independence is...
Daily Coping 3 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Using Docker Volumes for SQL Server in Linux
By John
No, not that kind of volume! Over the past couple of blog posts, I...
Forums
Pintable into cache
Pintable into cache to avoid fragmentation I have a table(OLTP database) which gets fragmented...
stored procedure to delete user and login
I was trying these but it does not work: USE [MyDatabase] GO /****** Object:...
Ask SSC