Viewing 15 posts - 9,601 through 9,615 (of 22,226 total)
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
PiMané (9/4/2013)
Temp tables created with SELECT .. INTO #temp FROM ... and then create clustered index ......
"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:50 pm
Loading & querying XML is expensive, especially with regards to memory. But, if you're already loading it, then it's not that much more expensive to use it twice. However, if...
"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 9:20 am
#temp tables have statistics. It's table variables that do not have statistics.
Here's a question. Will more than one user be running this query? If so, using a permanent table will...
"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 9:02 am
I don't really know of any. Data Architect is a pretty loose term for someone with a lot of experience and knowledge who can help you build, architect, your systems...
"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:57 am
There is no way to go back in time to retrieve an execution plan. So, if you have a need to monitor particular plans, you need to set up, ahead...
"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:54 am
I just wrote and submitted a 400 word editorial for Simple-Talk on MCM.
"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 3, 2013 at 9:13 am
Viewing 15 posts - 9,601 through 9,615 (of 22,226 total)