I understand TDE does not encrypt FileStream data. In SQL 2012, a new feature is FileTable, which is built upon FileStream technology. This implies that TDE does not...

I just experienced this wait type as well. I was running a stored procedure in SSMS when I noticed an error in the output window. The error was...

I would view the term 'survival job' as a badge of honor were I to find myself in one. I am five years from retirement, but still have the...

Thank you Ninja's_RGR'us for the tip about saving the plan as .sqlplan. Now I can see it.

While there is no filter on the date column I am just wondering...

I tried but could not see your plan for some reason and also therefore cannot determine how many rows you are scanning. However, just wondering if you can improve...

Katrina, these variables were meant to be temporary.

First, let me say I greatly appreciate the content presented on SQLServerCentral.com. As a developer/architect/dba/analyst in a small shop I learn something useful every day from the site.

Great...

We use table-driven custom roles in our budget reporting system and other systems. We store the active directory user login name as a custom field in our primary employee...

I too am just starting with xml in my designs. Thank you for putting this out there!

First of all, I applaud you for sharing your theory (and effort) related to design standardization such that it will permit automated code generation. I am also developing a...

Thank you for taking the time and effort to submit:-) this article. I always appreciate reading about how to optimize queries and actually being able to understand what the...

I actually had a menu choice on my desktop app's help menu that would allow users to send messages directly to the software developers. After two years of no...

Excellent! I have two other procs that do this but not with such elegance. i will be testing performance of the three versions soon and will add findings....

Any computer with a recent version of Windows (XP or later) , IE, and an internet connection.

Any printer within 50 feet of my desk.

Love that way-cool toaster!

Very nice! It is great to have useful little scripts like this. We create procs from scripts like this and add them to our UTIL schema to...