SQL Server 2014 In-Memory OLTP (Hekaton) Limitations

One of the biggest new features in SQL Server 2014 is SQL Server In-Memory OLTP, known mostly by its code...

What’s the Best Path to Becoming a DBA?

I received a blog comment from a nice chap recently, concerning a subject that I’m often asked about and I wanted to share my thoughts with you here. I only...

What’s the Best Path to Becoming a DBA?

I received a blog comment from a nice chap recently, concerning a subject that I’m often asked about and I wanted...

Why Transaction Log Auto Growths are degrading your performance

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email...

Answer - Objective Question (Which table is called Heap table in SQL Server)

Question:-

   Which table is called Heap table in SQL Server.

1) Table without any indexes

2) Table without any clustered index (Correct...

Are CHECKSUMs being performed with a Compressed Backup?

Now, why in the world would I be asking a question like this?

Well, in BOL (BACKUP) is this little blurb:
CHECKSUM

Specifies...

Day 12 – High CPU and Bloat in Distribution

This is the final installment in the 12 day series for SQL tidbits during this holiday season. Previous articles in this mini-series on quick tidbits: SQL Sat LV announcement...

Day 12 – High CPU and Bloat in Distribution

This is the final installment in the 12 day series for SQL tidbits during this holiday season.
Previous articles in this...

January 2014 – Monthly SQL Server Checklist

image source
It’s the first Monday of 2014.  Time for a new year and some resolutions to be a better DBA....

Last Weeks Top “Reading” Links #65

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow...