Viewing 15 posts - 10,036 through 10,050 (of 22,224 total)
They all can be. Makes things sloppy in my opinion. However, if you are dealing very large numbers of objects, for example, I saw this with stored procedures when we...
"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 11, 2013 at 5:08 am
You can have a single NULL value there. That's it. More than one, and it's not unique. You could try a filtered index instead.
"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 11, 2013 at 5:01 am
You should be aware that most changes to the optimizer, especially the ones that lead to plan instability, are not actually turned on when you install a service pack. Read...
"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 11, 2013 at 5:00 am
If you are trying to learn T-SQL, you can't go very far wrong picking up Itzik Ben-Gan's book. He has a fundamentals book and the Inside book.
I don't know of...
"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 11, 2013 at 4:49 am
Jeff Moden (2/10/2013)
Steve Jones - SSC Editor (12/3/2010)
No hurry on any of these.
I guess that's a good thing. Grant, did you ever get yours done? I know I'm...
"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 11, 2013 at 4:36 am
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
Viewing 15 posts - 10,036 through 10,050 (of 22,224 total)