Category Archives: T-SQL
-
How do I change the increment of an identity column?
7April 5, 2017 by Kenneth Fisher
Wellll .. technically there is no native way to do it. I even went through my notes on identity columns. …
Continue reading -
Hiding tables in SSMS Object Explorer
13April 3, 2017 by Kenneth Fisher
Extended Properties Sometimes you find out the strangest things about SQL Server. I’ve written about extended properties before but had …
Continue reading -
Creating a list of random numbers
3March 22, 2017 by Kenneth Fisher
I was working on a blog post this weekend that required a list of random numbers. Now, this isn’t exactly …
Continue reading -
The parts of an object’s name
3March 20, 2017 by Kenneth Fisher
Any object within a database in SQL Server has what is called a four part name. Which rather implies four …
Continue reading -
Using GROUP BY instead of DISTINCT
6March 6, 2017 by Kenneth Fisher
Recently, Aaron Bertrand (b/t) posted Performance Surprises and Assumptions : GROUP BY vs. DISTINCT. In it he says he prefers …
Continue reading -
Queries with optional parameters
20February 27, 2017 by Kenneth Fisher
These are those queries where you are pulling for, let’s say, a first name, a last name, a state, and/or …
Continue reading -
Deadlock on ALTER DATABASE
5February 16, 2017 by Kenneth Fisher
I had an interesting problem recently. A database was stuck in single user mode. How exactly was it stuck you …
Continue reading -
Deadlock priority
5February 8, 2017 by Kenneth Fisher
Everyone deals with deadlocks from time to time. But sometimes we need to control who’s the deadlock victim and who …
Continue reading -
Lead Blocker
16January 18, 2017 by Kenneth Fisher
Blocking is just part of life I’m afraid. Because we have locks (and yes we have to have them, and …
Continue reading
SQL Studies 