Viewing 15 posts - 7,216 through 7,230 (of 22,226 total)
What is it that you're trying to do?
"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
November 24, 2014 at 8:13 am
You can, but it's not at all the same partitioning mechanisms available in the earthed product. Here's some sample code on how to set it up from Microsoft. Here's 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
November 22, 2014 at 9:27 am
You could probably pay Gartner or one of their equivalents. I've no doubt they have that sort of information available. But I'm not aware of it being published anywhere.
"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
November 22, 2014 at 9:18 am
Effectively, the use of an index in the ON clause is the same as the use of an index in the WHERE clause. The criteria can act as a filter...
"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
November 22, 2014 at 9:14 am
And compare execution times and reads.
But I would suspect they'll resolve out to the same plan during the simplification phase.
"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
November 22, 2014 at 9:12 am
Glad to hear you worked it out, and thanks for posting the answer too. Now when someone who has the same problem does a search, they'll know what the solution...
"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
November 22, 2014 at 9:10 am
Red Gate tools (and that was for 11 years before I started to work for them). Other than that, paid tools kind of depends on what you're doing. Monitoring, I'd...
"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
November 22, 2014 at 9:09 am
Without knowing the software better, I'm not sure what you're referencing. It's possible that the inserts of data from the first server is causing blocking and/or resource contention for the...
"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
November 22, 2014 at 8:35 am
To really help out, the execution plan and the query would be best.
"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
November 22, 2014 at 8:23 am
The licensing costs between 2012 & 2014 are not severe such as they are between 2012/2014 and all the rest of the older versions of SQL Server. With that in...
"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
November 22, 2014 at 7:37 am
To summarize the rest of the answers:
It depends.
"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
November 15, 2014 at 5:45 am
allenb-717661 (11/14/2014)
Thanks SSChampion tried that and no change. How do I send it to a file?
Menu:
Tools, Options, Query Results, SQL Server.
There's an option in the very first drop down...
"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
November 15, 2014 at 5:40 am
Oh, and for a more sophisticated look at index & stats maintenance, I'd suggest you track down the Midnight DBA scripts for Minion. They've put a lot of thought into...
"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
November 15, 2014 at 5:37 am
sqlnaive (11/14/2014)
1. Can we start index defragmentation job for different DBs at same time ? Will it effect anything ? Is...
"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
November 15, 2014 at 5:34 am
And, i agree with the others, just making the three columns into a clustered key, especially if it's unique will work well. But, in that case, reverse what I said...
"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
November 15, 2014 at 5:14 am
Viewing 15 posts - 7,216 through 7,230 (of 22,226 total)