Category Archives: T-SQL

  1. Using OUTPUT with a field list.

    2

    November 30, 2016 by Kenneth Fisher

    I recently wrote an article for SQL Server Central about using OUTPUT. In case you aren’t aware OUTPUT is a …
    Continue reading

  2. Easy to read CHECKDB

    9

    November 28, 2016 by Kenneth Fisher

    If you ask a senior DBA what are the top 5 most important commands in T-SQL you’ll probably see DBCC …
    Continue reading

  3. It greatly pleases me to announce, HAL0003!

    24

    November 23, 2016 by Kenneth Fisher

    I while back as part of a T-SQL Tuesday post I created HAL0001, then later HAL0002 with a long-term goal …
    Continue reading

  4. Reload a table quickly.

    4

    November 21, 2016 by Kenneth Fisher

    Sometimes loading new data or even changes into a table just isn’t going to work. You need a complete reload. …
    Continue reading

  5. When was my index created or at least last updated?

    Leave a comment

    November 14, 2016 by Kenneth Fisher

    SQL Server stores a create date and a change date for each object in the sys.objects system view. Unfortunately while …
    Continue reading

  6. New indexes, hypothetically

    1

    November 2, 2016 by Kenneth Fisher

    I saw something like this the other day. My first thought was “Hu, never seen that before.” My second thought …
    Continue reading

  7. Installing SQLCMD

    Leave a comment

    October 19, 2016 by Kenneth Fisher

    For anyone who wasn’t aware SQLCMD is a command line tool for running T-SQL statements and scripts. Before anyone says …
    Continue reading

  8. Using Snippets

    Leave a comment

    October 17, 2016 by Kenneth Fisher

    A while ago I talked about Templates. This is an easy way to get a, well, template of a piece …
    Continue reading

  9. Too many indexes!

    Leave a comment

    October 13, 2016 by Kenneth Fisher

    Indexes are great. They speed up our queries. In fact, without them relational database systems wouldn’t work. Different indexes work …
    Continue reading

  10. Floor, Round, and Ceiling

    2

    October 5, 2016 by Kenneth Fisher

    I saw an interesting question today about rounding. Specifically they always wanted to round down. Now as it happens that …
    Continue reading

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

Join 1,598 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013