Viewing 15 posts - 7,231 through 7,245 (of 22,232 total)
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
SeanNerd (11/14/2014)
"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:13 am
SeanNerd (11/13/2014)
I have a table where we cannot use the typical int identity primary key column. The table can have millions...
"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:11 am
Dana Medley (11/14/2014)
"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 14, 2014 at 7:58 am
Yeah, I have to agree. The posted code fails to compile. I can edit it, but I'm guessing I won't see the error if I 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 14, 2014 at 6:28 am
Gotta agree. Without an edition being stated, the answers change. Just saying SQL Server, I would assume the full product, then the minimum is 1gb, but the recommended is 4gb....
"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 14, 2014 at 4:35 am
You might want to post that on Connect so that Microsoft is aware of it and makes it part of the documentation.
"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 14, 2014 at 4:31 am
Resender (11/14/2014)
We have a similar scenario
A query that runs an inner join on a select statement on a linked server
If the linked server is unavoidable,what...
"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 14, 2014 at 4:02 am
If you have the money, you'd better off with more than one disk to stripe the access. Also, for ~600gb of data, 8gb is a shockingly small amount of memory....
"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 13, 2014 at 9:11 pm
TheSQLGuru (11/13/2014)
I will add that you must be on Enterprise (or Developer) Edition of SQL Server to use them at all.
Oh, and that. Thanks.
"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 13, 2014 at 5:12 pm
Viewing 15 posts - 7,231 through 7,245 (of 22,232 total)