Viewing 15 posts - 1 through 15 (of 25 total)
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...
February 27, 2013 at 8:39 am
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...
August 2, 2012 at 3:20 pm
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...
January 20, 2012 at 8:10 am
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...
December 16, 2011 at 8:23 am
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...
December 16, 2011 at 7:58 am
Katrina, these variables were meant to be temporary.
May 18, 2011 at 9:24 am
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.
May 12, 2011 at 7:52 am
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...
April 26, 2011 at 9:33 am
I too am just starting with xml in my designs. Thank you for putting this out there!
October 26, 2010 at 7:27 am
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...
October 13, 2010 at 8:49 am
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...
September 15, 2010 at 9:24 am
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...
July 29, 2010 at 2:31 pm
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....
June 15, 2010 at 7:52 am
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!
February 5, 2010 at 7:44 am
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...
January 6, 2010 at 8:15 am