THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » TSQL   (RSS)
Showing page 2 of 2 (15 total posts)
  • When a Function is indeed a Constant

    In my last blog post:  http://sqlblog.com/blogs/andrew_kelly/archive/2008/02/27/when-getdate-is-not-a-constant.aspx I mentioned that I ran across a situation in which GETDATE() used in a SELECT statement occasionally returned more than 1 value for the result set. That sparked quite a debate amongst SQL Server programmers who belonged to ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on March 1, 2008
  • When GETDATE() is not a constant

    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 ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on February 27, 2008
  • Non-trusted constraints

    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 ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on January 12, 2008
  • Sorted views...

    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 ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on November 28, 2007
  • Is 'YYYY-MM-DD' always treated as year, month, date?

    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 ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on August 4, 2007
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement