Category: sqlserverpedia-syndication

24 Hours of PASS Starts TOMORROW!

Have you registered yet for 24 (+4) Hours of PASS? It’s free online training, presented by the people – like me – who will be teaching at the coveted PASS Summit in November. Why on Earth would you miss it? Register now! Especially for my T-SQL Brush-up session on 9/16 (1pm CST)  🙂 You can […]

Brief Intro to Indexes and INCLUDE – TSQL Tuesday #10!

Content rating: Beginner     This blog was originally posted on December 17, 2009. I’ve pulled it out of the closet for T-SQL Tuesday #10, with apologies for being too gosh-darn busy to write something new.  This is a companion blog to “Get Index Included Column Info“.  What are indexes for? We need to talk indexes […]

Tip: Use System Views to Compare Column Datatypes

Let’s say that you have a staging table, that then loads to a destination table in the same database.  If you have more than one person working on the process, data types can quickly get out of whack. So: what’s the easiest way to compare datatypes bewteen two “matching” tables? System views, my friends! Let’s create […]