February 2009 - Posts

• SQL Teaser Count That Trancount

  Today's teaser is very simple First create this table CREATE TABLE #Tran ( TranCountDefault int DEFAULT ( @@TranCount ), TranCountPassedIn int ) As you can see that table has two columns, one column has a default of @@TRANCOUNT. Now run this piece of Read More... Posted Thursday, February 26, 2009 5:15 PM by Denis Gobo | 6 Comments Filed under: Teaser

• SQL Server In The Cloud Vaporware Or Inevitable?

  After Paul Nielsen post SQL in the Cloud yesterday I decided to put on my Nostradamus hat and give you my take on this. What needs to happen before we can move to the cloud? There are a couple of things, here is a partial list Performance has to be good Read More... Posted Wednesday, February 25, 2009 11:47 AM by Denis Gobo | 6 Comments Filed under: cloud computing, vaporware

• So You Like To Use ANSI SQL...

  We all know that CURRENT_TIMESTAMP is ANSI and carries the Celko stamp of approval while GETDATE() is proprietary. So now run the following line of code CREATE TABLE duh2 ( id DATETIME CONSTRAINT df_duh DEFAULT CURRENT_TIMESTAMP ) No problem right? Let's Read More... Posted Sunday, February 22, 2009 9:52 PM by Denis Gobo | 13 Comments Filed under: Feature

• Things you know now but wish you knew when you started

  I got tagged by Go Daddy girl Michelle Ufford in her post Things you know now…. I also got tagged by Denny Cherry in his post Things You Know Now... So here is my little post. Before I start I will say that I thought of several things that are the same Read More... Posted Friday, February 13, 2009 2:35 PM by Denis Gobo | 0 Comments Filed under: self help

• SQL Server Proximity Search

  George, a good friend of mine created a blog post showing how you can do a SQL Server Zipcode Latitude/Longitude proximity distance search without using the geography data type. I searched the internet to see if anyone had something similar with the geography Read More... Posted Wednesday, February 11, 2009 10:28 PM by Denis Gobo | 1 Comments Filed under: SQL Server 2008, geospatial, geography

• Some Simple Code To Show The Difference Between Newid And Newsequentialid

  Some Simple Code To Show The Difference Between Newid And Newsequentialid In SQL Server 2000 we got the uniqueidentifier data type and the newid() function Lots of people thought that newid() would be very handy to create some unique values across all Read More... Posted Thursday, February 05, 2009 1:52 PM by Denis Gobo | 17 Comments Filed under: Performance, uniqueidentifier, page splits