Tag Archives: microsoft sql server
-
15 years of experience with Identity columns
51June 4, 2014 by Kenneth Fisher
An identity column is an auto incrementing column An identity column is typically used as a primary key A primary …
Continue reading -
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 -
Who has the DAC open?
2May 28, 2014 by Kenneth Fisher
The other day I started seeing the following error in my SQL log. Error: 17810, Severity: 20, State: 2. Could …
Continue reading -
Microsoft’s free virtual labs
1May 26, 2014 by Kenneth Fisher
If you have spent any time looking around my site, you will notice that I love study materials and in …
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 -
Does SQL Server do a CHECKDB during an instance restart?
11May 7, 2014 by Kenneth Fisher
When you start up an instance do you rely on the CHECKDB entry in the error log of SQL Server …
Continue reading -
Why is there a sysobjects when we already have sys.objects?
2May 5, 2014 by Kenneth Fisher
Once upon a time in a version of SQL far far away we had system tables that were easy to …
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
SQL Studies 