SQL Server – quickly delete all tables

October 12, 2018 Matt Thornton 0

With most things in SQL Server it’s tempting to think you can script it. Because most of the time you can. Recently, I had a requirement to quickly drop everything out of a database (but without actually just dropping the whole database.) The best option I found, was: 1) In […]

No Picture

Quick tip: Use OVER to get row numbers in subsets

December 10, 2010 Matt Thornton 0

Consider the following. You have a set of data. Within the data are multiple subsets that share an identifier. WIthin your main set, you need to number the subsets for each item within it, e.g., Data ID SubsetID Name Lots more columns… ———- ———– 1 ABC Dave 2 DEF Trev […]

No Picture

Reporting a product bug to Microsoft

March 12, 2010 Matt Thornton 0

I needed to update our installation of SQL Server 2008 to include Integration Services so that maintenance plans would run. I have local admin privilege on the machine, but as with most Microsoft related installation tasks, you routinely get so far through the process and you’re hit with the SeSecurityPrivilege […]

No Picture

Microsoft software: an example

September 10, 2008 Matt Thornton 0

The “I hate Microsoft brigade” vs the “I love Microsoft brigade” have debated for eons the merits of the company. The argument will rage until you and I are long gone. Personally, I don’t hate Microsoft as a corporation, I’m by no means their biggest fan, but I have no […]