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

The Scary DBA

I have twenty+ years experience in IT. That time was spent in technical support, development and database administration. I work forRed Gate Software as a Product Evangelist. I write articles for publication at SQL Server Central, Simple-Talk, PASS Book Reviews and SQL Server Standard. I have published two books, ”Understanding SQL Server Execution Plans” and “SQL Server 2008 Query Performance Tuning Distilled.” I’m one of the founding officers of the Southern New England SQL Server Users Group and its current president. I also work on part-time, short-term, off-site consulting contracts. In 2009 and 2010 I was awarded as a Microsoft SQL Server MVP. In the past I’ve been called rough, intimidating and scary. To which I usually reply, “Good.” You can contact me through grant -at- scarydba dot kom (unobfuscate as necessary).

Archives: October 2018

Explicitly Drop Temporary Tables Or Wait For Cleanup?

I was recently asked if we are going to see performance differences if we explicitly drop temporary tables. I couldn’t remember the specifics, but I said it actually didn’t matter. However, that answer has bugged me, so I set up a quick test. Explicitly Drop Temporary Tables We could make… Read more

14 comments, 3,953 reads

Posted in The Scary DBA on 29 October 2018

Why Did a Plan Get Removed From Cache?

I was recently asked if we could tell why a plan was removed from cache. If you read this blog, you know what I’m going to say next. I checked the extended events and there are actually two different events that will tell us information about a plan removed from… Read more

1 comments, 1,829 reads

Posted in The Scary DBA on 22 October 2018

Using Extended Events to Capture Implicit Conversions

Using the appropriate data type to avoid conversions or implicit conversions is a fundamental approach to good T-SQL coding practices. Implicit conversions can lead to poor performance. However, other than looking at every execution plan in your system, is there a way to see if you are experiencing implicit conversions?… Read more

4 comments, 1,782 reads

Posted in The Scary DBA on 15 October 2018

Database Fundamentals #19: JOINS

The last Database Fundamentals post introduced the SELECT and FROM commands. We’re going to start using JOIN operations shortly, but first, let’s explore the idea behind joins. The very concept of relational storage that is the foundation of SQL Server requires you to related one table to another.  You do… Read more

3 comments, 2,941 reads

Posted in The Scary DBA on 8 October 2018

Adaptive Joins and Join Hints

At a recent all-day seminar on query performance tuning I was asked a question that I didn’t know the answer to: “How do join hints affect adaptive joins?” I don’t know. Let’s find out together. Adaptive Joins Here’s a query that we can run against AdventureWorks: [crayon-5c05a866e92c8264853614/] Without a columnstore… Read more

3 comments, 2,691 reads

Posted in The Scary DBA on 1 October 2018