-->
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 2016

A Sub-Query Does Not Hurt Performance

The things you read on the internet, for example, “don’t use a sub-query because that hurts performance.”

Truly?

Where do people get these things?

Let’s Test It

I’ve written before about the concept of cargo cult data professionals. They see one issue, one time, and consequently extrapolate that to… Read more

10 comments, 1,220 reads

Posted in The Scary DBA on 24 October 2016

SQL Cruise as a Speaker and Sponsor

SQL Cruise offers a number of unique opportunities for everyone involved, including speakers and sponsors. I’ve written before, several times, about the benefits of SQL Cruise. As an attendee of the cruise, you will get to sit in classes by amazing people (and me) talking about all aspects… Read more

3 comments, 956 reads

Posted in The Scary DBA on 18 October 2016

SELECT * Does Not Hurt Performance

I read all the time how SELECT * hurts performance. I even see where people have said that you just have to supply a column list instead of SELECT * to get a performance improvement. Let’s test it, because I think this is bunkum.

The Test

I have here two… Read more

10 comments, 4,149 reads

Posted in The Scary DBA on 17 October 2016

Pre-Summit PASS Board Update

Busy, busy, busy.

A lot of the work around PASS currently is getting ready for Summit. I’m prepping my part in the keynotes. I’m involved in lots of community discussions including SQLSaturday, Chapters and Regional Mentors. We’re setting up the Community Zone for all sorts of activities throughout the week.… Read more

0 comments, 293 reads

Posted in The Scary DBA on 11 October 2016

Statistics Are Vital For Query Performance

This is post #10 supporting  Tim Ford’s (b|t) initiative on #iwanttohelp, #entrylevel. Read about it here.

When you send a query to your SQL Server database (and this applies to Azure SQL Database, APS, and Azure SQL Data Warehouse), that query is going to go through… Read more

1 comments, 1,885 reads

Posted in The Scary DBA on 10 October 2016

Where Do We Go To Share?

No one reads blogs any more.

Twitter is dying.

Facebook is broken.

LinkedIn? Please.

G+. Is that even on any more?

Where do we go to share?

I’m seeing it here on this blog. Traffic is down. Not just day-to-day traffic, but the search hits. That could just be that… Read more

10 comments, 367 reads

Posted in The Scary DBA on 5 October 2016

Correlated Datetime Columns

SQL Server is a deep and complex product. There’s always more to learn. For example, I had never heard of Correlated Datetime Columns. They were evidently introduced as a database option in SQL Server 2005 to help support data warehousing style queries (frequently using dates and times as join criteria… Read more

1 comments, 1,500 reads

Posted in The Scary DBA on 3 October 2016