Viewing 15 posts - 10,036 through 10,050 (of 22,219 total)
meridius10 (2/10/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 10, 2013 at 9:20 am
If you say "SQL" and "SQL Server" as part your knowledge set, I'd say you know T-SQL. Do you know the new 2012 paging methods? I'm not up on those,...
"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 10, 2013 at 5:11 am
Yes you can. Each one will run the checksum calculation on the pages before and after they are written to disk to help ensure that what was read from your...
"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 10, 2013 at 5:07 am
Sure, but I wasn't aware that the encryption process would actually make consistent output pages that could be deduped. It implies that reverse engineering of the encryption process is just...
"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 11:22 am
Brandie Tarvin (2/8/2013)
It is morning, and my boss wants "butt in chair" work.
Sigh. Sometimes I hate my life....
"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 8:16 am
Sounds mostly reasonable, yes.
"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 8:09 am
Sean Lange (2/8/2013)
It would be FAR better to remove the cursor from both of your procs. 😀
Ha! Probably a true statement.
"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 8:08 am
Sure, you can pull from sys.dm_exec_text_query_plan. That requires a statement start offset and a statement end offset, both of which are available from sys.dm_exec_query_stats or sys.dm_exec_requests. It does return 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 8:05 am
That's fine. You can name variables the same thing between procedures and other stuff. It's not like creating a permanent table or a global temporary table. The scope of these...
"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 7:58 am
There just aren't very many hard and fast rules for how to put this together. Yes, if a given column isn't used that is in an index key, that might...
"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:46 am
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
Viewing 15 posts - 10,036 through 10,050 (of 22,219 total)