Tag Archives: sql statements

  1. Clean out all bad characters from a string.

    9

    March 25, 2015 by Kenneth Fisher

    I have a customer who is having a problem with a load. He is getting a fair number of bad …
    Continue reading

  2. Why not NOLOCK?

    4

    March 18, 2015 by Kenneth Fisher

    Most senior DBAs I’ve met shudder when they hear NOLOCK. Ever wonder why? For the same reason they shudder at …
    Continue reading

  3. There are #temp tables and then there are ##temp tables.

    Leave a comment

    March 16, 2015 by Kenneth Fisher

    Temporary tables are a common enough thing in T-SQL that most of us have probably used them on a fairly …
    Continue reading

  4. Who’s using that database?

    Leave a comment

    March 9, 2015 by Kenneth Fisher

    A common problem when trying to alter a database (take it offline, add a filegroup, whatever) is that someone else …
    Continue reading

  5. Test your UPDATEs and DELETEs before you run them

    14

    February 18, 2015 by Kenneth Fisher

    This isn’t so much of a best practice, it comes more under the heading of being careful. Let’s say you …
    Continue reading

  6. Except and Intersect

    5

    January 19, 2015 by Kenneth Fisher

    EXCEPT and INTERSECT are two uncommon commands. Not that they do anything odd but they aren’t exactly well known in …
    Continue reading

  7. Pagination in SQL Server

    5

    January 15, 2015 by Kenneth Fisher

    It amazes me how much easier certain tasks have gotten in SQL Server. I was watching the Nov 2014 SQL …
    Continue reading

  8. Finding a common AD group for a set of users.

    7

    December 29, 2014 by Kenneth Fisher

    I work for a large organization that over the last few years has been doing a LOT of reorgs. And …
    Continue reading

  9. Do you want to build an Audit?

    Leave a comment

    December 29, 2014 by Kenneth Fisher

    So I’ve written my second article for SQL Shack. This time instead of an overview of auditing options in sql …
    Continue reading

  10. INSERT INTO SELECT vs SELECT INTO

    2

    December 3, 2014 by Kenneth Fisher

    INSERT INTO SELECT and SELECT INTO may be very similar commands but they have some important differences. Every now and …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 694 other followers