SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: May 2014

Auditing and Event SubClasses

A recent discussion got me to thinking about Auditing.  To be honest, it got started with a complaint about some documentation that seemed overly light about the various fields related to auditing as it stands in SQL Server.

In talking to the person who raised the valid concern about the… Read more

2 comments, 1,761 reads

Posted in SQL RNNR on 28 May 2014

Can you partition a temporary table?

Reading that title, you might sit and wonder why you would ever want to partition a temporary table.  I too would wonder the same thing.  That withstanding, it is an interesting question that I wanted to investigate.

The investigation started with a fairly innocuous venture into showing some features that… Read more

7 comments, 2,404 reads

Posted in SQL RNNR on 23 May 2014

Supported Compatibility Levels in SQL Server

It has been well documented and is well known that SQL Server supports certain older versions of SQL Server in a compatibility mode.  This setting is something that can be configured on the database properties level.  You can quickly change to an older compatibility level or revert the change to… Read more

1 comments, 17,038 reads

Posted in SQL RNNR on 21 May 2014

Missing Indexes Script v2

Frequently we hear the analogy that <insert item here> is like opinions, everybody has one and not all of them are good (some may stink).

Well, this may just be another one of those <items>.  Whether it stinks or not may depend on your mileage.

I had shared a similar… Read more

10 comments, 4,201 reads

Posted in SQL RNNR on 15 May 2014

T-SQL Tuesday #54 – Interviews and Hiring

This month’s T-SQL Tuesday is hosted by Boris Hristov (blog|twitter) and his chosen topic is “Interviews and Hiring” – specifically interviewing and hiring of SQL Server Professionals.


This is a pretty interesting topic from a few different angles.  Boris proposed a few topics such as… Read more

1 comments, 1,749 reads

Posted in SQL RNNR on 14 May 2014

Omaha BI/SQL User Group – What?

I recently received an email from this guy named John Morehouse (blog | twitter) about the Omaha SQL/BI User Group Meeting in May.

Imagine my surprise when reading the email and discovering that I was presenting.

Here are the guts of that email.

Can you believe that it’s…

Read more

1 comments, 758 reads

Posted in SQL RNNR on 7 May 2014