Category Archives: T-SQL

  1. Counting NULLs

    4

    July 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

  2. Code I’d Hate To Live Without: T-SQL Tuesday #104

    1

    July 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

  3. SQL Puzzle – FizzBuzz3d

    18

    June 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

  4. Strings vs Identifiers

    3

    June 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

  5. The identity column, the insert and the linked server.

    1

    June 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

  6. What queries are getting blocked?

    Leave a comment

    June 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

  7. Updated query to view data in the error log

    2

    May 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

  8. Exploring system tables, views, SPs etc

    Leave a comment

    April 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

  9. Deleting a lot of data

    5

    April 12, 2018 by Kenneth Fisher

    I recently had the task of deleting a bit over a billion rows from a table. Now I could have …
    Continue reading

  10. DB_NAME() vs ORIGINAL_DB_NAME()

    1

    March 15, 2018 by Kenneth Fisher

    I’d never seen ORIGINAL_DB_NAME until recently and I thought it would be interesting to highlight it out, and in particular …
    Continue reading

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 2,442 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013