A short while ago I was collecting wait stat information at a client and ran across a very peculiar situation that I would like to share. Let me start by saying that for years I have coded with the understanding that when you include a system function in the SELECT list of a TSQL statement the function was evaluated once at the beginning and that ...

A discussion in the newsgroups before the holidays lead to trusted constraints and performance. This inspired me to blog about it, but I decided to have some vacation first :-). Instead of having one long article, I'll do a two-part. This one is about non-trusted constraints in general, and another one will follow about non-trusted constraints and ...

Here's one that pops up regurarly. Something like: ''My views are no longer ordered in SQL Server 2005. I have ORDER BY in the view, but when I select from it, the rows are not returned according to the ORDER BY.'' Since I tend to post a reply often enough to above type of posts, I decided to put it in writing once and for all, so I can point to ...

Most of you already know the answer to this question: no. I won't recap the rules for interpretation of the current datetime literals, as I have an article on the subject: http://www.karaszi.com/SQLServer/info_datetime.asp However, SQL Server 2008 introduces a number of new date, datetime and time datatypes. One interesting aspect of these is ...