Category Archives: T-SQL
-
Permissions required for developing with Temporal Tables
2October 16, 2017 by Kenneth Fisher
Temporal tables are one of those new (2016+) cool features that recently came across my desk. Basically, a temporal table …
Continue reading -
sys.objects VS helper functions (OBJECT_ID, OBJECT_NAME, etc)
2October 11, 2017 by Kenneth Fisher
I’ve you’ve done much work with the system views (DMVs for example) then you’ve had to translate an object_id into …
Continue reading -
Small identity columns
5October 9, 2017 by Kenneth Fisher
We frequently talk about dealing with outgrowing INT identity columns. What we don’t talk about all that often is small …
Continue reading -
The Alpha and the Omega. The BEGIN and the END.
2October 4, 2017 by Kenneth Fisher
The BEGIN/END block is a fairly standard thing if you’ve ever done any coding, but it never hurts to do …
Continue reading -
SQL Puzzle – Prime Numbers
9September 27, 2017 by Kenneth Fisher
My goal here is to have something fun (and hopefully educational/thinky) (and yes, I did just make up the word …
Continue reading -
Saving and restoring session options settings
4September 25, 2017 by Kenneth Fisher
There are a fair number of options settings. ANSI_NULLS, ARITHABORT, QUOTED_IDENTIFIER, etc. Each session has its own set of configurations. …
Continue reading -
Uniquifier is a rather unique word isn’t it?
8September 18, 2017 by Kenneth Fisher
tl;dr; The uniquifier is used to make a non-unique key in a clustered index unique. Uniquifier is a rather funny …
Continue reading -
Help! My query is too fast!
1September 14, 2017 by Kenneth Fisher
Said no one ever. Well, maybe. I have had occasions where I needed a brief pause in the middle of …
Continue reading -
There EXISTS a place where SELECT 1/0 doesn’t return an error.
4September 7, 2017 by Kenneth Fisher
Kendra Little (b/t) reminded me of this fun little trick (with fairly important ramifications) in her latest quiz on logical …
Continue reading -
Create an empty table from a SELECT statement but without the IDENTITY.
3August 28, 2017 by Kenneth Fisher
A while back I did a post about creating an empty table using a SELECT statement. Basically doing something like …
Continue reading
SQL Studies 