Monthly Archives: June 2014
-
Make BOL your friend
2June 30, 2014 by Kenneth Fisher
One of the most powerful tools we have as users of SQL Server is Books Online (BOL). Whether you work …
Continue reading -
Dealing with a long string
4June 25, 2014 by Kenneth Fisher
Every now and again you have to put a really long string (more than 8000 characters). Dynamic SQL is the …
Continue reading -
Aliasing a SQL Server: When it works, when it doesn’t and when it may be your problem.
16June 18, 2014 by Kenneth Fisher
Creating an alias for a SQL Server is fairly easy and there are several ways to do it. Configuration Manager …
Continue reading -
What is this default trace you speak of?
4June 12, 2014 by Kenneth Fisher
I frequently see the default trace mentioned in answers to forum questions, blog posts, articles, even training sessions. My knowledge …
Continue reading -
MJ Swart offers free technical editing
1June 9, 2014 by Kenneth Fisher
A little while back Michael J Swart(B/T) offered to help you become a better writer. This was exciting for me …
Continue reading -
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
SQL Studies 