Viewing 15 posts - 9,346 through 9,360 (of 22,219 total)
I'm going to follow on what the others have said. You first have to demonstrate that you have the core knowledge of SQL Server before I start asking you other...
"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
December 2, 2013 at 3:51 am
Forced Parameterization has a very limited set of cases where it will be applied. It's only slightly more likely to be used by the optimizer than simple parameterization. Check 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
December 2, 2013 at 3:47 am
I got to meet another Threadizen last night. Revenant is doing some seriously wild stuff with the technology we all use. If you get the chance to talk to him...
"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
November 22, 2013 at 7:54 am
Stefan Krzywicki (11/18/2013)
Grant Fritchey (11/18/2013)
No one is aware...
"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
November 18, 2013 at 11:27 am
I'm not aware of any major structural changes for partitioning in 2014, but I'm sitting at the MVP Summit, let me ask people...
No one is aware of anything like that....
"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
November 18, 2013 at 9:30 am
You're also missing some JOIN criteria here:
LEFT OUTER JOIN SALES_TAX RIGHT OUTER JOIN
"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
November 16, 2013 at 7:16 am
You can trace each statement within the procedure by using Extended Events. You can set up to capture each statement start and end. That will give you precise information on...
"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
November 16, 2013 at 7:14 am
mstanl (11/15/2013)
Thank you very much for the reply Tom,And yes Grant this is the same person that talked to you in Dallas SQL Saturday.
Mike
HA!
I'd say I recognized your question, but...
"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
November 15, 2013 at 2:25 pm
RBarryYoung (11/15/2013)
SQLRNNR (11/15/2013)
Barry, where have you been?Mostly just working. I answer questions over at StackOverflow sometimes, but that's about it.
StackOverflow? Traitor!
Ha!
Good to see around, even if only virtually.
"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
November 15, 2013 at 2:21 pm
Functionally, it's no big deal. A little bit of a pain having to maintain two unique indexes, one for the PK and one for AK, but I've worked with such...
"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
November 15, 2013 at 10:45 am
Just to be clear, 10 join operations is not very much. Joins are not a bad thing within a relational data structure. In fact, they're fairly necessary.
"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
November 14, 2013 at 4:34 am
to understand how indexes are in use on your system, use the sys.dm_db_index_usage_stats. But, there are some caveats around what it shows as to whether or not an index has...
"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
November 14, 2013 at 4:32 am
Lynn Pettis (11/13/2013)
Lynn Pettis (11/13/2013)
It is 23:27 Afghan time. Three minutes until my phone interview. Wish me luck!
Just finished the interview, and I feel like a Junior DBA....
"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
November 13, 2013 at 3:46 pm
Your query is extremely simple, but the execution plan is very complex. So, it looks like you're joining or nesting views. You've got a "Reason for early termination" of 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
November 12, 2013 at 4:14 am
I'm pretty constantly bombarded by job requests. I'd say the activity is out there. Heck, I just got told of another by a friend (anyone, that I can vouch for,...
"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
November 11, 2013 at 4:42 pm
Viewing 15 posts - 9,346 through 9,360 (of 22,219 total)