Monthly Archives: April 2014

  1. DBA Myths: TRUNCATE TABLE deletes all the rows of a table instantly.

    7

    April 30, 2014 by Kenneth Fisher

    Most DBAs and developers I’ve talked to over the years have felt that TRUNCATE TABLE is an instant DELETE. However …
    Continue reading

  2. The default autogrowth settings do NOT come from the Model database.

    5

    April 28, 2014 by Kenneth Fisher

    I recently saw a question about How to inherit autogrowth settings. They commented that while the new database GUI seemed …
    Continue reading

  3. Collation: Confusion

    Leave a comment

    April 23, 2014 by Kenneth Fisher

    I started reading about collations after I had a recent run in with them. As I read I started to …
    Continue reading

  4. Collation: Temporary objects and variables: Demonstration

    4

    April 21, 2014 by Kenneth Fisher

    I had a recent run in with collation problems and it got me started reading about them. As I read …
    Continue reading

  5. Who is an expert?

    21

    April 16, 2014 by Kenneth Fisher

    Recently Paul Randal had a brief rant on twitter where he complained about the fact that there are no stupid …
    Continue reading

  6. Collation: Correction -> Instance

    Leave a comment

    April 14, 2014 by Kenneth Fisher

    I had a recent run in with collation problems and it got me started reading about them. As I read …
    Continue reading

  7. Collation: Correction -> Expression, Column, Database

    Leave a comment

    April 10, 2014 by Kenneth Fisher

    I had a recent run in with collation problems and it got me started reading about them. As I read …
    Continue reading

  8. T-SQL Tuesday #53: Why so serious

    6

    April 8, 2014 by Kenneth Fisher

    Why so serious? If you ask anyone who knows me they will tell you I’m not a terribly serious person. …
    Continue reading

  9. Microsoft announces that it will no longer support SQL Server and that SQL 2014 was an April Fools Joke!

    4

    April 1, 2014 by Kenneth Fisher

    Microsoft has announced that SQL 2014 was in fact an elaborate April Fool’s joke and that Microsoft intends to move …
    Continue reading

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

Join 1,655 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013