Monthly Archives: April 2014
-
DBA Myths: TRUNCATE TABLE deletes all the rows of a table instantly.
7April 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 -
The default autogrowth settings do NOT come from the Model database.
5April 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 -
Collation: Confusion
1April 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 -
Collation: Temporary objects and variables: Demonstration
4April 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 -
Who is an expert?
24April 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 -
Collation: Correction -> Instance
Leave a commentApril 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 -
Collation: Correction -> Expression, Column, Database
Leave a commentApril 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 -
T-SQL Tuesday #53: Why so serious
8April 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 -
Microsoft announces that it will no longer support SQL Server and that SQL 2014 was an April Fools Joke!
4April 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
SQL Studies 