Monthly Archive: October 2009

Connect Digest : 2009-10-30

Connect Digest : 2009-10-30

Light helping this week.  I am busy closing out a few projects (or at least chapters within projects) in preparation for PASS next week. ======================================== #506453 : Lock escalation no longer kicks in for...

Connect digest : 2009-10-25

Connect digest : 2009-10-25

Here is your weekly helping of Connect goodness.  I added two items from the Connect connection, and an item from the Visual Studio connection. ================================================= #500228 : Default Data Location Not Being Written To...

Run into me at PASS, and you could win a prize!

Run into me at PASS, and you could win a prize!

If you're planning on attending PASS, you should consider playing Twitter Bingo (put on by Quest).  Basically, you will get a randomized card with names and avatars of 25 Twitter users who post about...

New Cumulative Updates for SQL Server 2005 SP2 / SP3

New Cumulative Updates for SQL Server 2005 SP2 / SP3

Some new updates just posted by SQL Server Release Services: For SQL Server 2005 SP2, build 9.0.3355: http://support.microsoft.com/kb/974647 For SQL Server 2005 SP3, build 9.00.4266: http://support.microsoft.com/kb/974648 On first glance, it does not appear that...

Connect digest : 2009-10-17

Connect digest : 2009-10-17

I've been fairly distracted this past week with my "Bad habits to kick" series, so apologies for being so late with the Connect digest.  I stumbled upon a few pretty interesting items from the...

Bad habits to kick : mis-handling date / range queries

Bad habits to kick : mis-handling date / range queries

In my last post in this series, I talked about using user-defined data types (alias types).  Today I wanted to discuss many of the ways in which people subject their date and time columns...

Bad habits to kick : using alias types

Bad habits to kick : using alias types

In my last post in this series, I talked about using the visual designers in SSMS.  This time, I wanted to treat the use of alias types. To clarify what I am talking about...

Bad habits to kick : using the visual designers

Bad habits to kick : using the visual designers

In my last post in this series, I talked about abusing triggers.  This time I thought I would focus a bit on using the visual designers in SSMS.  Table Designer My biggest problem with...

Bad habits to kick : abusing triggers

Bad habits to kick : abusing triggers

In my last post in this series, I talked about choosing inappropriate data types.  This time, I want to touch on a few ways that I see triggers being misused.  Using a trigger at...

Bad habits to kick : choosing the wrong data type

Bad habits to kick : choosing the wrong data type

In my last post in this series, I talked about the assumptions many people make about IDENTITY columns.  In this post, I want to focus on choosing data types.  There are several areas where...

Bad habits to kick : making assumptions about IDENTITY

Bad habits to kick : making assumptions about IDENTITY

In my last post in this series, I talked about inconsistent naming conventions.  This time I want to talk about a few of the assumptions people make when using IDENTITY columns, and what kind...

Bad habits to kick : inconsistent naming conventions

Bad habits to kick : inconsistent naming conventions

In my last post in this series, I talked about using the schema prefix, with particular focus on dbo-only systems.  In this post, I want to treat the use of inconsistent naming conventions. Stored...

Bad habits to kick : using SELECT * / omitting the column list

Bad habits to kick : using SELECT * / omitting the column list

In my last post in this series, I talked about inappropriately using SELECT, OUTPUT and RETURN in stored procedures.  Today I wanted to talk about using SELECT * or omitting the column list entirely....

Bad habits to kick : using SELECT or RETURN instead of OUTPUT

Bad habits to kick : using SELECT or RETURN instead of OUTPUT

In my last post in this series, I covered the use of "bad" characters in entity names, such as spaces or dashes.  In this post I will talk about using RETURN and OUTPUT inappropriately....

Bad habits to kick : using dashes and spaces in entity names

Bad habits to kick : using dashes and spaces in entity names

In my last post in this series, I talked about defining varchar columns, parameters, or variables without length.  Next I want to talk about using "bad" characters, like spaces or dashes, in entity names....

Bad habits to kick : declaring VARCHAR without (length)

Bad habits to kick : declaring VARCHAR without (length)

In my last post in this series, I talked about using meaningless table aliases.  This time I'm going to talk about a pet peeve of mine: declaring varchar / nvarchar variables or parameters without...

Connect Digest : 2009-10-09

Connect Digest : 2009-10-09

This past week I was reviewing a few bugs surrounding the new DATE, TIME, DATETIME2 and DATETIMEOFFSET data types, introduced in SQL Server 2008.  While they are much more like first-class citizens than the...