14Jan 2011 by Grant Fritchey 11 Comments

Failed Blog Posts

Misc
Over the last week I've started and trashed two blog posts. Let me tell you, that's painful. You get some great idea and then it all goes south. For example, I was going to explain the difference between a table/heap scan and a clustered index scan. The problem was, I ran into gaps in my knowledge, some outright errors in my beliefs on how data was stored, and really faulty conclusions drawn from those facts and a less than thorough set of tests. I'm not even going to tell you what went wrong with the other notion. Luckily, all this was behind the scenes so I didn't post my ignorance for all to see.  Since I'm not offering you a chance to point & laugh (in this instance), you might…
Read More
11Jan 2011 by Grant Fritchey 5 Comments

TSQL Tuesday: Resolutions

Misc
Sounds like a good action adventure movie. The theme this month on TSQL Tuesday, thanks to our host, Jen McCown (blog|twitter) of SQLawesomesauce, is Resolutions. In particular, Techie Resolutions. I have to do this because Jen just received her MVP award, in case you’ve been under a rock since last week. I’m not a resolutions kind of guy. I tend to make plans. The plans might start on January 1st, or they might start as soon as they lawyers are done making up the contract. I’m not hung up on schedules except as they relate to due dates. For example, when submissions are due for the PASS Summit or something along those lines, then I’m date driven. In other words, I don’t sit down New Year’s Day or New Year’s…
Read More
05Jan 2011 by Grant Fritchey 4 Comments

Encryption and the Performance DMOs

T-SQL
Ever wonder what you can see in the performance oriented DMOs when stored procedures were encrypted? Me neither. But, I did get that question during my DMO presentation at the PASS Summit. I did not have an answer. I did get an answer from Johan Bijnens (twitter) from the audience, which I repeated without entirely knowing what I was saying. I decided that I ought to actually know the answer to that question, so here’s a little experiment. I'm going to create a simple stored procedure: CREATE PROCEDURE dbo.GetSalesDetails (@SalesOrderId INT) AS SELECT soh.AccountNumber, sod.LineTotal FROM Sales.SalesOrderHeader AS soh JOIN Sales.SalesOrderDetail AS sod ON soh.SalesOrderID = sod.SalesOrderID WHERE soh.SalesOrderID = @SalesOrderID When I create this procedure and run it, you can see the general performance of the query being run…
Read More