TSQL Tips: Writing more efficient DDL (Data Definition Language) with system functions

  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 correctly can result in your Data Definition Language (DDL) running 3 times faster….

4

PreScan: SQL Schema Data Types

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 datatypes, new feature usage & uncommon design. So it really doesn’t…

0

How to: See SharePoint 2010 Data Connections from Excel 2010

  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 hoping a sharepoint expert will comment &…

4

PreScan: SQL Database Schema Distribution

  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 get from it.   What are PreScans? When someone…

0