Viewing 15 posts - 9,286 through 9,300 (of 22,219 total)
Wow! Thank you. Very high praise. Happy I can help.
"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 12, 2013 at 5:40 am
Is it a problem? I mean, you're using a lot of CPU, but are you experiencing slow performance? And further, is that slow performance caused by CPU? What are 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
December 12, 2013 at 4:36 am
You can look to the dynamic management function sys.dm_exec_plan_attributes. It will show the user_id that created the plan among other things. You'll just have to pass it the plan_handle.
"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 12, 2013 at 4:34 am
You can set up extended events to capture logins. That's the one sure way to get it. But if you haven't set that up, I'm not sure there is a...
"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 12, 2013 at 4:29 am
Default trace and a server-side trace are absolutely one direction for solving this.
But, a better direction would be to take advantage of extended events. They're more lightweight, less intrusive and...
"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 12, 2013 at 4:19 am
I'm not sure. You may need to open a case with Microsoft. I'd say it sounds like you've set them up on the same ports, but you said you checked...
"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 12, 2013 at 4:12 am
There isn't a single definition for what exactly is meant by "data dictionary."
Do you mean the table definitions, indexes, constraints, all as defined by T-SQL? Or are we talking about...
"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 11, 2013 at 8:05 am
IgorMi (12/11/2013)
bugg (12/11/2013)
GilaMonster (12/11/2013)
Have you considered one of the rowversion-based isolation levels?
I have considered this, but it will mean downtime to Enable READ_COMMITTED_SNAPSHOT ON, which unfortunately I cannot do anytime...
"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 11, 2013 at 7:21 am
Not really. If a user can create a database, they can access that database.
On the existing instance, you can set the user as data_reader only which will prevent them...
"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 11, 2013 at 7:19 am
It's largely because heap storage goes where ever. It's one of the fundamental issues with heaps and why it's worth pointing out that fundamental storage and access in SQL Server...
"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 11, 2013 at 7:16 am
prabhu.st (12/11/2013)
Hi G.F,yes,
it works as Charm..
Thanks,
Prabhu
Which, the cost threshold change?
"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 11, 2013 at 6:02 am
Obviously you're getting two different plans with two different execution times. I'd say the principal difference is in the hash keys residual that adds the CustomerSets data to the combined...
"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 11, 2013 at 5:20 am
GilaMonster (12/11/2013)
That's a formatting issue that should be dealt with in whatever application is reading this data.
Absolutely!
"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 11, 2013 at 5:06 am
yayomayn (12/11/2013)
Grant Fritchey (12/11/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
December 11, 2013 at 4:06 am
If you understand that NUMERIC is a precision and then a scale, then you'd know that you need NUMERIC(10,5). Read up on it here. I'd also suggest, instead of NUMERIC,...
"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 11, 2013 at 3:49 am
Viewing 15 posts - 9,286 through 9,300 (of 22,219 total)