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,993 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,357 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,075 reads
Blogs
Goal Progress for July 2021
By Steve Jones
I set goals at the beginning of the year, and I’m tracking my progress...
Data Modeling at your fingertips
By Rayis Imayev
(2021-July-30) A picture is worth a thousand words, the same way a visual database schema...
How to put a SQL Server Database into Recovery Pending
By John
You might be asking why on earth would you want to get a database...
Forums
Migrate SQL Sever 2012 Database To Server 2014 and Subsequent Versions
Hi Guys, I have an SQL Server 2012 Express database that I would like...
Deploying SQL Server Automatically
Comments posted to this topic are about the item Deploying SQL Server Automatically
Setting data compression on a database or even server level possible?
I well realize data compression is a subject to a few variables, such as...
Ask SSC