Tag Archives: code language
-
What is the difference between Money and Decimal(19,4)
8June 2, 2014 by Kenneth Fisher
One of my co-workers and I were discussing the difference between the data type MONEY and the data type DECIMAL(19,4). …
Continue reading -
DBA Myths: A table with a primary key is not a heap
5May 21, 2014 by Kenneth Fisher
Typically when you see a heading like this you know the answer is “No” or “False” but in this case …
Continue reading -
Escaping from a runaway Logon trigger
11May 19, 2014 by Kenneth Fisher
Most people know that logon triggers can be dangerous if you aren’t careful. And if you didn’t know, well, logon …
Continue reading -
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 -
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
SQL Studies 