Browse by Tags

• Internals
• Interview
• Oracle
• Performance
• Sad but true
• Teaser
• Tip
• Trace
• T-SQL

• Interview With Erland Sommarskog About SQL Server and Transact SQL

  I asked for some names of people who you would like to see interviewed here at Sqlblog and Erland Sommarskog's name popped up a couple of times. I contacted Erland and he was kind enough to take time out from his busy schedule to answer these questions. Read More... Posted Tuesday, May 27, 2008 11:09 AM by Denis Gobo | 0 Comments Filed under: T-SQL, SQL Server, Interview

• Perfect way to manage a database project.........not!

  I found this gem yesterday here: http://www.tek-tips.com/viewthread.cfm?qid=1391668&page=1 here is the question I have a situation where a person can have more then one item ordered. I need to layout the information as follows: Person Item Ordered Read More... Posted Thursday, July 26, 2007 9:08 AM by Denis Gobo | 1 Comments Filed under: SQL Server, Oracle, Sad but true

• Did You Know SQL Server Has A Black Box Like An Airplane?

  Paul Randal writes: "Kimberly mentioned that SQL Server has a 'black-box' trace, similar to an aircraft flight-recorder, which I'd never heard of. It's an internal trace that has the last 5MB of various trace events and it's dumped to a file when SQL Read More... Posted Sunday, June 03, 2007 4:33 PM by Denis Gobo | 1 Comments Filed under: SQL Server, Trace, Internals

• Summer SQL Teaser #1 Dateformat

  Just to clarify, summer starts Memorial Day and ends Labor Day. I will post a teaser every Friday until Labor Day. Got this from my friend George, try to guess the output of the code below without running it. SET DATEFORMAT DMY SELECT CONVERT ( DATETIME Read More... Posted Friday, June 01, 2007 5:32 AM by Denis Gobo | 7 Comments Filed under: SQL Server, Teaser

• Speed Up Performance And Slash Your Table Size By 90% By Using Bitwise Logic

  You have all seen websites where you can pick a bunch of categories by selection a bunch of check boxes. usually what you do is store those in a lookup table and then you create another table where you store all the categories for each customer. What Read More... Posted Tuesday, May 29, 2007 8:16 PM by Denis Gobo | 19 Comments Filed under: Tip, Performance, T-SQL, SQL Server