Browse by Tags

• DELETE
• NULLIF
• Nulls
• Productivity
• Shortcut
• SQL Myth
• SQL Server 2005
• Tip
• Tips and Tricks
• trick
• TRUNCATE
• Upgrading

• If you are upgrading from SQL Server 2000 to 2008 and you never touched SQL Server 2005, then I feel sorry for you

  “I sense you skipped SQL Server 2005 in you... Skipping SQL Server 2005 leads to a bigger learning curve... A bigger learning curve leads to not knowing the product as well...Not knowing the product as well leads to suffering..Running in compatibility Read More... Posted Wednesday, July 09, 2008 2:33 PM by Denis Gobo | 10 Comments Filed under: SQL Server 2008, sqL Server 2000, SQL Server 2005, Upgrading

• A year in review, The 21 + 1 best blog posts on SQLBlog

  A year in review, The 21 + 1 best blog posts on SQLBlog Best posts according to me, it might have been the content or it might have been the comments. Either way here are the 21 + 1 posts I enjoyed the most. But wait the year is not over yet. Doesn't Read More... Posted Thursday, December 27, 2007 5:00 PM by Denis Gobo | 0 Comments Filed under: SQL Server 2008, sqL Server 2000, SQL Server 2005

• Return Null If A Value Is A Certain Value

  You need to return NULL only if the value of your data is a certain value. How do you do this? There are three different ways. NULLIF DECLARE @1 char (1) SELECT @1 = 'D' SELECT NULLIF (@1 ,'D' ) REPLACE This should not really be used, I just added it Read More... Posted Tuesday, November 06, 2007 2:28 PM by Denis Gobo | 7 Comments Filed under: Tip, SQL Server 2008, sqL Server 2000, SQL Server 2005, trick, NULLIF, Nulls

• Increase Your Productivity With Query Analyzer/SQL Server Management Studio

  Drag And Drop Column Names In Query Analyzer you can save a lot of time by using this trick instead of typing all the column names of a table Hit F8, this will open Object Browser Navigate to DatabaseName/TableName/Columns Click on the column folder and Read More... Posted Monday, September 24, 2007 12:52 PM by Denis Gobo | 5 Comments Filed under: Tip, SQL Server 2008, sqL Server 2000, SQL Server 2005, Shortcut, Tips and Tricks, Productivity

• SQL Myth: Truncate Cannot Be Rolled Back Because It Is Not Logged

  I am still amazed at how many people still think that TRUNCATE TABLE is not logged. There is some logging going on but it is minimal, here is what Books On Line says: TRUNCATE TABLE removes the data by deallocating the data pages used to store the table's Read More... Posted Wednesday, June 13, 2007 12:07 PM by Denis Gobo | 7 Comments Filed under: SQL Server 2008, sqL Server 2000, TRUNCATE, SQL Server 2005, SQL Myth, DELETE