Tag Archives: sql statements

  1. Except and Intersect

    4

    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

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

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

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

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

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

    9

    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

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

    6

    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

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

    2

    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

  9. A script to list the DTS connection information for every package on the instance.

    Leave a comment

    October 27, 2014 by Kenneth Fisher

    For those of you who have moved completely to SQL 2012 & 2014, Lucky you and don’t judge! For the …
    Continue reading

  10. You can’t use aggregate/windowing functions with CROSS APPLY

    7

    October 6, 2014 by Kenneth Fisher

    One of my favorite features of CROSS APPLY is the ability to use it instead of a calculated variable. Well …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 578 other followers