I often perform code reviews and thought it would be fun to frame this exercise: a completely fictitious stored procedure hits my desk, I’ll reject it of course, and enumerate the reasons why.
2023-05-10
LAG pulls a column from another row without a self-join. In this article, Kathi Kellenberger shows how LAG compares to other techniques
2021-09-24
Wondering which database to tackle first? I’ve got the lowdown on the top free...
By Brian Kelley
The Techno Security & Digital Forensics Conference (East) runs from June 3-5, 2025, this...
You can find the slides for my session Building the €100 data warehouse with...
Comments posted to this topic are about the item Changing the Paradigm of Work
Comments posted to this topic are about the item Removing a File
Comments posted to this topic are about the item SQL Cookbook: Query Solutions and...
I attempted to use ALTER DATABASE to remove a file from my filegroup in SQL Server 2022. There are 4 files in this filegroup, but I don't need them all. However, I received a message that the file was not empty. How do I empty this file so it can be removed?
See possible answers