Viewing 15 posts - 10,051 through 10,065 (of 22,224 total)
GilaMonster (2/8/2013)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 8, 2013 at 6:27 am
I'm surprised you were getting dedup through the encrypted databases. Really surprised. I figured that would work more like trying to compress them (where the size sometimes goes UP). Any...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 8, 2013 at 5:38 am
But state and status are not the most selective, they are the least selective.
Selectivity is how unique the data is. The most selective column would be the column with the...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 8, 2013 at 5:31 am
If you've had a consistently good experience with the Tuning Advisor, I'd say you're the exception that proves the rule. Mostly, I've seen the DTA giving questionable suggestions or useless...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 7, 2013 at 11:30 am
jcrawf02 (2/7/2013)
Grant Fritchey (2/7/2013)
Brandie Tarvin (2/7/2013)
Oh, heavens. A non-tech webcomic commenting on data consistency.I am amused: http://www.sandraandwoo.com/%5B/url%5D
Excellent!
Huh, I wonder how many situations like that would actually have been helpful....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 7, 2013 at 9:07 am
PiMané (2/7/2013)
Grant Fritchey (2/7/2013)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 7, 2013 at 5:45 am
That calculation is for a minimum healthy value but even that is to be measured against your server over time. But the biggest key word there is: minimum. A higher...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 7, 2013 at 5:38 am
Brandie Tarvin (2/7/2013)
Oh, heavens. A non-tech webcomic commenting on data consistency.I am amused: http://www.sandraandwoo.com/%5B/url%5D
Excellent!
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 7, 2013 at 5:04 am
Gail also covers setting up server-side trace in her articles on query tuning[/url].
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 6, 2013 at 9:05 am
Just be sure you're using no data types in the newer server that can't exist in the older (or other code constructs). You should be able to export the scripts...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 6, 2013 at 9:03 am
I won't say bad things about the competition, but be sure you do a VERY thorough evaluation of the Quest/Dell offerings. Just saying.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 6, 2013 at 6:53 am
If you're talking data changes there's no automatic auditing within SQL Server by default. You can look to extended events as a mechanism to see all data changes by capturing...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 6, 2013 at 5:12 am
DISCLOSURE: I work for Red Gate Software.
I've used all the major tools and most of them against a production environment. Each of them does different things for you in varying...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 6, 2013 at 5:10 am
Shadab Shah (2/6/2013)
GilaMonster (2/6/2013)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 6, 2013 at 4:24 am
k.srikalyan (2/6/2013)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 6, 2013 at 4:05 am
Viewing 15 posts - 10,051 through 10,065 (of 22,224 total)