Tag Archives: T-SQL

  1. SQL Judo’s Monthly Challenge – February 2014 – KILL with the DAC

    Leave a comment

    January 26, 2015 by Kenneth Fisher

    Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be …
    Continue reading

  2. Constraint names, Say NO to the default

    10

    January 21, 2015 by Kenneth Fisher

    Have you ever seen a constraint with a name like PK__TableNam__EA185FBF8FF1529D? It’s kind of funny looking right? I mean it …
    Continue reading

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

  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 the reason for the error “Subquery returned more than 1 value”

    1

    January 7, 2015 by Kenneth Fisher

    First this type of error is because a subquery returned more than one row when it wasn’t allowed to. In …
    Continue reading

  6. Does a clustered index sort the rows within a page

    Leave a comment

    December 15, 2014 by Kenneth Fisher

    This is just something I was curious about. I ran my tests and got an answer and now I thought …
    Continue reading

  7. DROP INDEX and CREATE INDEX vs ALTER INDEX REBUILD

    2

    December 11, 2014 by Kenneth Fisher

    I saw someone ask a few weeks ago if it was faster to drop and re-create an index or do …
    Continue reading

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

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

  10. Putting sp_ at the beginning of your stored procedure.

    1

    November 24, 2014 by Kenneth Fisher

    Every now and again you see articles and posts about putting sp_ at the beginning of a stored procedure. So …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 591 other followers