October 2007 - Posts

• Do you want to laugh or cry?

  I don't know if I should laugh or cry after looking at this code. This could not have been written by a human right? Anyway here it is, consider it a teaser. If you want to torture yourself and look at the whole query then go here: http://www.tek-tips.com/viewthread.cfm?qid=1421304&page=1 Read More... Posted Friday, October 26, 2007 11:21 AM by Denis Gobo | 9 Comments Filed under: programming, SQL

• SQL Teaser: Select

  Without running this code try to guess what the values of @var1 and @var2 will be CREATE TABLE #TeasMeNot ( id int ) DECLARE @var1 int , @var2 int SELECT @var1 = 0 , @var2 = 0 SELECT @var1 = id FROM #TeasMeNot SELECT @var2 = ( SELECT id FROM #TeasMeNot Read More... Posted Wednesday, October 24, 2007 3:24 PM by Denis Gobo | 2 Comments Filed under: Teaser

• Sort Values Ascending But NULLS Last

  This is a frequent request in newsgroups and fora. People want to sort the column in ascending order but don't want the NULLS at the beginning. Oracle has this syntax: ORDER BY ColumnName NULLS LAST; SQL Server does not have this. But there are 2 ways Read More... Posted Friday, October 19, 2007 10:23 AM by Denis Gobo | 17 Comments Filed under: NULL, trick

• Dot Doesn't Make Sense?

  What will happen when you run this? Create Table #Dots ( Data VarChar ( 50 )) Insert Into ... #Dots Values ( 'Huh?' ) --3 dots Insert Into .. #Dots Values ( 'Huh, say what?' ) --2 dots Select * From . #Dots -- 1 dot Drop Table #Dots --look no dots! Read More... Posted Thursday, October 18, 2007 2:11 PM by Denis Gobo | 3 Comments Filed under: Teaser

• Interview With Kalen Delaney About Inside Microsoft SQL Server 2005 Query Tuning and Optimization

  I am a big fan of Inside Microsoft SQL Server 2005 The Storage Engine so when I saw that yet another book got published in this series I just had to check it out. Inside Microsoft SQL Server 2005: Query Tuning and Optimization is very well written gets Read More... Posted Monday, October 15, 2007 10:58 AM by Denis Gobo | 4 Comments Filed under: Performance, SQL Server 2005, Book, Interview, Performance Tuning, Tuning

• SQL Teaser: Guess the output

  What do you think will be the output? DECLARE @d datetime SET @d = '20071010' SELECT DATEADD (yy, DATEDIFF (yy, 0, @d)+1, -1) Read More... Posted Wednesday, October 10, 2007 11:46 AM by Denis Gobo | 6 Comments Filed under: Teaser, sqL Server 2000, SQL Server 2005, dates, Datetime

• SQL Teaser: Guess the output

  Here is a small teaser, can you guess the output? SELECT d.c-d.b/d.a FROM ( SELECT 1 c,2 b,5 a)d(a,b,c) Read More... Posted Monday, October 01, 2007 3:55 PM by Denis Gobo | 3 Comments Filed under: Teaser