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 » T-SQL Tuesday   (RSS)
Showing page 4 of 4 (36 total posts)
  • T-SQL Tuesday #4: I/O, You Know

    It's time for the fourth T-SQL Tuesday, managed this time by Mike Walsh. I almost missed this deadline completely, since I didn't see the announcement at all. I wrote to Adam to ask if there even was an event this month, since I wasn't able to get into my own blog site (www.SQLBlog.com) for a week, and he pointed me to Mike's site. I'm wondering ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on March 9, 2010
  • T-SQL Tuesday #3: SQL Server Relationships

    It's time for the third T-SQL Tuesday, managed this time by Rob Farley. I thought I wasn't going to make this deadline, since I have been swamped since the end of last week, and over the entire weekend. However, I've got a break with nothing urgent for the next hour or so, so I thought I could just write something short. My first two T-SQL ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on February 9, 2010
  • T-SQL Tuesday #002: Non-aggregated columns in a GROUP BY query

    It's time for the second T-SQL Tuesday, once again managed by Adam Machanic. Since my first T-SQL Tuesday post dealt with my long years with the SQL Server product, I decided to continue in that vein.  Adam asked for us to write something about a puzzle we had to deal with, involving TSQL. I decided to write about one of the most puzzling ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on January 11, 2010
  • Unambiguous date formats : T-SQL Tuesday #001

    One of the most commonly used data types in SQL Server is [datetime] which unfortunately has some vagaries around how values get casted. A typical method for defining a [datetime] literal is to write it as a character string and then cast it appropriately. The cast syntax looks something like this: DECLARE @dt ...
    Posted to Jamie Thomson (Weblog) by jamiet on December 8, 2009
  • T-SQL Tuesday #001: My Datetime FAQ

    I am rising to Adam's challenge for his very first T-SQL Tuesday, and blogging about datetime issues. Since I just finished a 9-hour teaching day in Stockholm, and I'm incredibly jetlagged, I decided to keep this simple. I'm very much looking forward to what everyone else is going to say! For as long as I've been providing TSQL support, starting ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on December 8, 2009
  • T-SQL Tuesday #001: Yesterday it worked, today it's not working...

    But did it actually work yesterday? If the day is Friday, Noverber 13th, or the 13th day of any other month, and your query blows up for the first time, one place to search for is character strings converted to datetime values. The following script illustrates the ...
    Posted to Alexander Kuznetsov (Weblog) by Alexander Kuznetsov on December 8, 2009
Privacy Statement