Viewing 15 posts - 9,346 through 9,360 (of 22,214 total)
You're also missing some JOIN criteria here:
LEFT OUTER JOIN SALES_TAX RIGHT OUTER JOIN
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...
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...
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.
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...
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.
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...
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....
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...
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,...
November 11, 2013 at 4:42 pm
There are, as Steve says, almost limitless issues. One of them is most likely that you have the default value set for "Cost Threshold for Parallelism." That value is 5....
November 11, 2013 at 4:36 pm
It kind of depends on what the job is doing how you can monitor it. If it's running DOS or PowerShell commands, the primary metrics are going to be the...
November 8, 2013 at 5:30 am
I'm with Kevin. It's very likely to be contention.
But, from the differences you're seeing, I'd also suggest it's possibly statistics being different between the two. Those differences in estimations the...
November 8, 2013 at 3:34 am
There are only a few that do both.
Dell (formerly Quest) Foglight
Solarwinds
Microsoft Systems Center Operation Manager
Personally, I'm not crazy about the job that Foglight does on SQL Server, but it works...
November 8, 2013 at 3:30 am
If you don't set the max memory on each instance, they will fight for the memory resources and you could see a "winner" in that fight.
In general, if a...
November 7, 2013 at 4:11 am
Viewing 15 posts - 9,346 through 9,360 (of 22,214 total)