Browse by Tags

• Book
• Bug
• dates
• Datetime
• DELETE
• Feature
• Functions
• Interview
• NULL
• NULLIF
• Nulls
• Performance
• Performance Tuning
• Productivity
• review
• Shortcut
• SQL Myth
• sqL Server 2000
• SQL Server 2008
• Teaser
• Tip
• Tips and Tricks
• Tools
• trick
• TRUNCATE
• Tuning
• uniqueidentifier
• 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 | 17 Comments Filed under: SQL Server 2008, sqL Server 2000, SQL Server 2005, Upgrading

• Review of Inside Microsoft SQL Server 2005 Query Tuning and Optimization

  SQL performance tuning is probably one of those things you can do to really make a HUGE difference in performance. Let’s put this in perspective: take a typical application, if you can improve the performance by 100% then you really made a huge improvement. Read More... Posted Thursday, February 07, 2008 4:20 PM by Denis Gobo | 4 Comments Filed under: SQL Server 2005, Book, review

• SQL Server 2005 Best Practices Analyzer (January 2008) Available For Download

  This download is the January 2008 release of SQL Server 2005 Best Practices Analyzer. Get it here: http://www.microsoft.com/downloads/details.aspx?FamilyId=DA0531E4-E94C-4991-82FA-F0E3FBD05E63&displaylang=en Read More... Posted Monday, January 21, 2008 9:47 AM by Denis Gobo | 1 Comments Filed under: SQL Server 2005, Tools

• Has Anyone Succeeded In Creating A Collision Between NEWID and NEWSEQUENTIALID

  SQL Server 2005 introduced a new type of function to create a uniqueidentifier; the NEWSEQUENTIALID(). This new function has been created for performance reasons, each new value is greater than the previous value. In theory this means that the value will Read More... Posted Monday, January 07, 2008 3:47 PM by Denis Gobo | 14 Comments Filed under: SQL Server 2005, uniqueidentifier

• 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 | 1 Comments Filed under: SQL Server 2008, sqL Server 2000, SQL Server 2005

• Retrace : A SQL Profiler Trace Swiss Army Knife

  Have you ever needed to find your most expensive queries and quickly grew weary of writing T-SQL against trace tables to try to ferret them out? Have you ever had to wade through gigabytes of trace data just to find one ill-behaving query? Have you ever Read More... Posted Wednesday, December 12, 2007 7:57 AM by Denis Gobo | 0 Comments Filed under: SQL Server 2005, Tools

• INTERCEPT In SQL 2005

  I was writing a query and managed to mistype INTERSECT, I typed INTERCEPT and to my surprise the query ran, it returned 2 result set just as if INTERCEPT wasn't there at all Try it yourself CREATE TABLE testnulls (ID INT ) INSERT INTO testnulls VALUES Read More... Posted Tuesday, November 13, 2007 4:09 PM by Denis Gobo | 21 Comments Filed under: SQL Server 2005, Feature, Bug

• 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

• Christmas Is Coming Early This Year

  Note from my manager: "All, It looks like we have some book money left for this year that we can spend. Please select 2 books each that you have wanted and send the titles to me and I’ll get them on the list." Very nice, I picked the following two books Read More... Posted Tuesday, November 06, 2007 1:14 PM by Denis Gobo | 5 Comments Filed under: SQL Server 2005, Book

• 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

• 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 Teaser PASS Special: Table Size

  What will be the outcome of this script? First we create a table with a total of 6000 bytes Next we increase col2 from 1000 to 2000 bytes, this will give us a total of 7000 bytes Finally we add col3 which has 1000 bytes, this will give us a total of 8000 Read More... Posted Friday, September 21, 2007 9:58 AM by Denis Gobo | 4 Comments Filed under: Teaser, sqL Server 2000, SQL Server 2005

• SQL Server 2005 Best Practices Analyzer Released, End Of Support For SQL Server 2000 SP3a In 6 Days

  End of Support for SQL Server 2000 Service Pack 3a Support for SQL Server 2000 Service Pack 3a (SP3a) will end on July 10, 2007. Microsoft will end technical support on this date, which also includes security updates for this Service Pack. Microsoft is Read More... Posted Wednesday, July 04, 2007 5:40 AM by Denis Gobo | 0 Comments Filed under: sqL Server 2000, SQL Server 2005

• Summer SQL Teaser #4 Nulls and Counts

  First create this table CREATE TABLE Teaser (ID int) INSERT Teaser VALUES (1) INSERT Teaser VALUES (2) INSERT Teaser VALUES (1) INSERT Teaser VALUES (2) INSERT Teaser VALUES (NULL) Without running this try to figure out what the result will be SELECT Read More... Posted Friday, June 22, 2007 10:45 AM by Denis Gobo | 7 Comments Filed under: Teaser, sqL Server 2000, NULL, SQL Server 2005