Dave does Data

  The internet is swimming with examples of really inefficient TSQL code. Just because everyone does it that way doesn’t make it optimal. I’ve already blogged about the issues you will find with NOLOCK hints , this post show that using system functions...

  Recently I tore my hair out trying to create a great end-user experience for my Excel 2010 users when they access SharePoint. Eventually I found a way to get it to work. This is not a perfect post. I’m far from an expert in SharePoint & I’m...

Continuing on from my previous post PreScan: SQL Database Schema Distribution this Scan looks at the datatypes used in the database you need to tune. Perhaps one of the less useful of the pre-scans it is still handy. It highlights the use of depreciated...

  At the very start of a performance tuning exercise I do a Quick Appraisal to assess what I'm dealing with.   This is one of a number of “information collection” scripts I run. This post shows (a) Code & (b) some ideas on insight you can...