Tag Archives: sql statements

  1. Who’s using that database?

    1

    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

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

  3. Except and Intersect

    7

    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

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

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

    9

    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

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

  7. INSERT INTO SELECT vs SELECT INTO

    5

    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

  8. Using a date or int column as the clustered index.

    13

    December 1, 2014 by Kenneth Fisher

    The other day I was answering a question about clustered indexes and it lead indirectly to a twitter conversation on …
    Continue reading

  9. You don’t really need ORDER BY do you?

    8

    November 19, 2014 by Kenneth Fisher

    You see dozens of blog posts and articles about how the order of a result set is not guaranteed without …
    Continue reading

  10. Using T-SQL to populate a Central Management Server

    6

    November 17, 2014 by Kenneth Fisher

    We have been using a CMS (Central Management Server) at my office for the last few years. Even beyond the …
    Continue reading

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

Join 3,653 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013