use Table Variables in transaction

when using table variable, please note table variable doesn't support transaction rollback. here is the words from BOL

Because table variables...

TRY, CATCH, and Transactions

The T-SQL TRY/CATCH structure (“new” in SQL 2005!) is, as the professionals say, da bomb. It’s also underused and under-understood,...

Exploring Excel 2013 for BI Tip #8: Adding Calculated Measures

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...

TechEd North America 2013 videos online

Microsoft has posted ALL the session videos for TechEd North America 2013 and they are available for free!  What a...

Disaster Recovery’s big brother Operational Recovery

I’m going to get slammed for the title by someone but I stand by it. First some definitions.
Disaster Recovery...

SQL Server Running Slow

A user calls to say the app or server is slow today.  Here’s a quick summary of how I get...

Creating Real World PowerPivot Models Recording and Q&A

Thanks everyone for attending my free webinar on Creating Real World PowerPivot Models on June, 18, 2013.  If you were...

Natural Born Killers (The series) – Day 4 Indices

To those that don’t know me “Natural Born Killers (The Series)” sounds like a very strange choice for a SQL...

The Changing World of BI, A New White Paper for Magenic

In the ever changing landscape that is Business Intelligence (or is that Business Analytics?), a fellow business analyst from Magenic,...

New Page - "How to Get Involved With the SQL Server Community"

I recently composed an email (on the side) for a client DBA looking for info on getting involved with the...