A SQL Server 2005 High Safety DB Mirroring session synchronously transfers transactions from the primary DB to the mirroring DB and then with the help of a witness server supports automatic fail over from the primary to the mirror is the primary becomes unavailable. All the primary, mirror and witness nodes all keep an eye [...]
Tag Archives: sql2005
Statistics IO: Logical, Physical, Read-Ahead
Sunday, February 17, 2008
SET STATISTICS IO ON is an option that shows, at the page level, the physical and logical IO that goes on for each statement in a batch. Its not the most detailed inspection of a the query performance but it gives a nice insight into whats going in when the query is executing. I’m going [...]
Simple performance timing
Thursday, February 7, 2008
There are a myriad of statistics SET options in sql 2005 but it looks like the first one I looked at is the simplest and the possibly the oldest: STATISTICS TIME.
It does little more than show the cpu and total time required to both parse and compile the batch and to execute it. When performance [...]
Where’s my Showplan?
Friday, January 18, 2008
Isn’t that what we’re all asking in our own lives?
I know I am.
Yesterday I had a SQL Server 2005 connection running as SA and tried to get the Actual Execution plan for a stored procedure. The procedure should have returned a million rows, instead all I got was an empty result set. All the columns [...]
How to read encrypted data and the problem of MARS
Thursday, January 17, 2008
Following on from my previous post I’ve created a procedure to read encrypted data using the same principles: Executing the procedure in the context of a least privilege user and elevating the permissions using code signing as follows.
create procedure sales_api.usp_getCCTrans with execute as ‘lpu_code_context’ as begin begin try [...]