Viewing 15 posts - 9,601 through 9,615 (of 22,232 total)
I do stuff like that all the time. Let's say we're building a system for storing personal information. You have a table to define the person
PersonID FirstName LastName
With the primary...
"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
September 6, 2013 at 4:10 am
Jeff Moden (9/5/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
September 6, 2013 at 4:03 am
patrickmcginnis59 10839 (9/5/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
September 5, 2013 at 12:05 pm
patrickmcginnis59 10839 (9/4/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
September 5, 2013 at 11:18 am
facemann (9/5/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
September 5, 2013 at 8:37 am
Without knowing what's happening inside those UDF's, it's hard to say whether or not it would affect performance. I'm willing to bet money that there's some type of "security" check...
"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
September 5, 2013 at 7:32 am
The most honest suggestion I can make, don't run it at all. The DTA recommendations are usually weak, at best. Sometimes they are down right frighteningly dangerous. I am 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
September 5, 2013 at 6:47 am
It doesn't matter if that login doesn't have permission to show execution plans. You can query the dynamic management objects (DMO) to get the plans from cache.
But, I'll bet it...
"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
September 5, 2013 at 4:23 am
Honestly, it sounds like you might be way over your head on this one. I'd suggest bringing in someone with SQL Server experience. A good consultant should be able to...
"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
September 5, 2013 at 4:21 am
You're already on to the better tool for the job. The index_usage_stats will show you, pretty much, what is being accessed, but, if you have monthly or quarterly or some...
"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
September 5, 2013 at 4:19 am
Do you mean an export of the data?
I'd look at Powershell to do this. You can have it walk the user tables of a database and generate export files 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
September 5, 2013 at 4:16 am
ScottPletcher (9/4/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
September 4, 2013 at 5:21 pm
ScottPletcher (9/4/2013)
Grant Fritchey (9/4/2013)
Instead I've noticed that you're probably going to have an "identity more likely than not" approach on most systems just because it makes sense.
I'd disagree even with...
"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
September 4, 2013 at 4:49 pm
DaveDB (9/4/2013)
So, would you say that it makes more sense to have a clustered index on a column besides an ID column? Seems like that would be...
"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
September 4, 2013 at 4:08 pm
Sean Lange (9/4/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
September 4, 2013 at 3:51 pm
Viewing 15 posts - 9,601 through 9,615 (of 22,232 total)