-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Confessions of a Microsoft Addict

Daniel Janik has been supporting SQL Server for 18 years as a DBA, developer, architect, and consultant. He spent six years at Microsoft Corporation supporting SQL Server as a Senior Premier Field Engineer (PFE) where he supported over 287 different clients with both reactive and proactive database needs. Daniel has spoken at several SQL Saturday events across the US and Caribbean and regularly speaks at PASS local chapters.

Archives: November 2016

Query Tuning 101: Debugging a procedure

I was recently asked to help tune a stored procedure that has been historically taking between 55 and 60 seconds to complete. Overall the code wasn’t too complex but getting to the root cause did surprise me a bit.

We run a mixture of SQL Server 2008 R2 and SQL… Read more

0 comments, 3,782 reads

Posted in Confessions of a Microsoft Addict on 30 November 2016

Query tuning 101: How to measure Query Plan I/O cost

If you’re a DBA or a developer chances are you’ve looked at a query plan or two. While looking at your plan you may have noticed that each operator has a cost. Did you know that the cost is measurable?

When you’re looking at your plan where do you start?… Read more

0 comments, 2,599 reads

Posted in Confessions of a Microsoft Addict on 18 November 2016

Query tuning 101: Problems with IN ()

If you’re a DBA or database developer, chances are you will have to write or rewrite queries from time to time. Rewriting may be for new features or simply to improve the performance of existing code.

There are tens of thousands of tips and tricks for tuning. Just about every… Read more

10 comments, 5,358 reads

Posted in Confessions of a Microsoft Addict on 10 November 2016