Thank you to everyone that attended my class “SSMS Tips and Tricks: Shortcuts for Impatient DBAs”.  As promised, please find the scripts and links below. Session Scripts:   Session Links: Apex SQL Refactor – AutoHotKey – SentryOne Plan Explorer – sp_whoisactive – More →

This series is aimed at beginners in the SQL Server world or at those thrust into the role of DBA with little or no training.  As such we’ll be focusing on some common concepts and doing so at a very high level.  This series will not get especially technical nor will it cover topics in extreme detail.  Also, the demo information will be done using mostly UI from SSMS and wizards as applicable rather than scripting.  If being a full time SQL Server DBA is among your career goals you should consider this series of posts as only a starting point and seek further knowledgeRead More →

If you read my last post, you’ll find this to the be exact opposite.  Instead of determining the best way to find rows that exist in one dataset but not another, we’ll be looking for rows that exist in 2 different datasets. The obvious answer is a join statement, but does that always perform the best?  Certainly, if you require other fields from the secondary table then a join will always be best.  For this test we are looking for rows that appear in a table called orderheader that are also in a temporary table called #ords.  The field that we are comparing is anRead More →

It is a pretty common need to find rows that exist in one dataset, but not in another.  The question I will look to answer today is, “which way is best?”.  For this test we are looking for rows that appear in a table called orderheader that aren’t also in a temporary table called #ords.  The field that we are comparing is an INT called ord_hdrnumber and it is the Clustered Primary Key of each table. We’ll compare the pros, cons, and performance of 4 popular methods to complete the task.   –NOT IN SELECT a.ord_hdrnumber FROM orderheader a WHERE a.ord_hdrnumber NOT IN (SELECT b.ord_hdrnumberRead More →

After a recent presentation where I left a few of my audience members unable to see some demos I felt like I needed to make sure I was more prepared for future presentations.  My slide deck was quite visible and I was able to quickly zoom in  on the SQL text in the query editor window, but the results pane was an issue. I see 2 solutions to the issue.  The first is to simply use ZoomIt, a popular tool that every presenter (except me apparently) already has installed.  ZoomIt is a free download from Microsoft and allows you to quickly zoom in on the screen andRead More →

I’m about a day late to post this, but I hope a few of you saw me at the Ohio North SQL Server User Group last night.  I had a great time presenting on Window functions.  I hope to present again soon.  Read More →

And by “everyone” I mean maybe my wife and some of my employees who are looking for an opportunity to suck up. Welcome to my SQL Server blog.  Here I’ll be writing about SQL Server and related (sometimes unrelated) topics. My name is Eric Blinn and I am the Database Services Manager at TMW Systems in Mayfield Heights, Ohio.  I have been working with SQL Server since 2003 in the transportation and insurance industries.  I have presented on SQL Server topics for the last 2 years at the In.Sight transportation conference and Ohio North SQL Server Users’ Group.  Today, I serve a wide ranging customer baseRead More →