Viewing 15 posts - 9,601 through 9,615 (of 22,224 total)
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
Brandie Tarvin (9/3/2013)
Grant Fritchey (9/3/2013)
Brandie Tarvin (9/3/2013)
Grant Fritchey (9/3/2013)
Presumably they all use the internet.
One can hope. I know several older people who barely know what email is let alone...
"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 7:58 am
Brandie Tarvin (9/3/2013)
Grant Fritchey (9/3/2013)
Presumably they all use the internet.
One can hope. I know several older people who barely know what email is let alone what websites are out...
"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 7:29 am
Viewing 15 posts - 9,601 through 9,615 (of 22,224 total)