Tag Archives: T-SQL

  1. 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

  2. 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

  3. Updated query to view data in the error log

    1

    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

  4. 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

  5. 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

  6. Windowing without a partition by or an order by

    2

    February 21, 2018 by Kenneth Fisher

    If you’ve never worked with windowing functions they look something like this: The other day someone mentioned that you could …
    Continue reading

  7. Synonyms, how and why.

    6

    February 15, 2018 by Kenneth Fisher

    Did you know SQL Server has a thing called a synonym? It’s not something you see used very often even …
    Continue reading

  8. What’s dbo?

    3

    January 22, 2018 by Kenneth Fisher

    Don’t you hate it how certain words (well, acronyms in this case) get reused to mean multiple things? dbo seems …
    Continue reading

  9. Fun with sp_rename

    Leave a comment

    January 11, 2018 by Kenneth Fisher

    Currently the only way to rename objects in SQL Server is to use sp_rename. Although that may be changing in …
    Continue reading

  10. Variables in Dynamic SQL

    Leave a comment

    November 16, 2017 by Kenneth Fisher

    I had someone ask me about this the other day. Specifically getting variable data out of a dynamic SQL statement. …
    Continue reading

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

Join 2,423 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013