Category Archives: T-SQL
-
Nada to Speaker: Demystifying and Diminishing Dynamic SQL Difficulties
3August 20, 2018 by Kenneth Fisher
Last Thursday I spoke at NTSSUG (North Texas SQL Server User Group). This is my local group (only 1.5 hours …
Continue reading -
What are my permissions?
1August 16, 2018 by Kenneth Fisher
Permissions are a common concern. One of the most frequent requests I get is I need X, Y and Z …
Continue reading -
Counting NULLs
4July 16, 2018 by Kenneth Fisher
Recently I was doing one of Kendra Little’s (b/t) SQL Server quizzes. Specifically the Quiz: COUNT() in SQL Server. As …
Continue reading -
Code I’d Hate To Live Without: T-SQL Tuesday #104
3July 10, 2018 by Kenneth Fisher
It’s TSQL Tuesday again! This time our respected host is Bert Wagner (b/t). Quick aside, if you haven’t seen his …
Continue reading -
SQL Puzzle – FizzBuzz3d
18June 27, 2018 by Kenneth Fisher
I thought for the end of the month it would be fun to do another T-SQL Puzzle. In this case …
Continue reading -
Strings vs Identifiers
3June 20, 2018 by Kenneth Fisher
A common mistake, and one I make frequently myself is to use a string in place of an identifier, or …
Continue reading -
The identity column, the insert and the linked server.
4June 14, 2018 by Kenneth Fisher
tl;dr; When doing an insert across a linked server you have to include the list of fields to be inserted …
Continue reading -
What queries are getting blocked?
Leave a commentJune 6, 2018 by Kenneth Fisher
Monday Grant Fritchey (b/t) put up a great post EXTENDED EVENTS, THE SYSTEM_HEALTH SESSION, AND WAITS that talks about how …
Continue reading -
Updated query to view data in the error log
5May 31, 2018 by Kenneth Fisher
This is one of my favorite scripts. It pulls all of the data from the error log and dumps it …
Continue reading -
Exploring system tables, views, SPs etc
Leave a commentApril 18, 2018 by Kenneth Fisher
I wanted to spend a few minutes highlighting a couple of important tools for figuring out what information you have …
Continue reading
SQL Studies 