April 2009 - Posts

• Match those types!

  This is a recommendation I believe is worth repeating from time to time: Make sure you match data types when you write TSQL code. Else you in most cases end up with an implicit data type conversion. And in worst case, this conversion is performed at the Read More... Posted Tuesday, April 28, 2009 1:30 PM by TiborKaraszi | 19 Comments Filed under: Tools, Performance, indexes, Trace, Troubleshooting

• Is it only me or are "uncomfortable" answers largely ignored?

  I do quite a bit of posting on forums, and I have noticed that in many cases when you take your time to explain how something work, or why you should do something perhaps in a not so obvious way, that answer tend to be ignored and never replied to. Instead Read More... Posted Tuesday, April 21, 2009 12:16 AM by TiborKaraszi | 17 Comments