Viewing 15 posts - 7,666 through 7,680 (of 22,219 total)
Anything that the server does in a completely automated fashion needs to, under most circumstances, and in most cases, not cause harm. Rebuilding indexes could be problematic. For example, an...
"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
July 29, 2014 at 6:09 am
patrickmcginnis59 10839 (7/28/2014)
Koen Verbeeck (7/28/2014)
patrickmcginnis59 10839 (7/28/2014)
Ed Wagner (7/28/2014)
SQLRNNR (7/27/2014)
Jeff Moden (7/26/2014)
SQLRNNR (7/26/2014)
But the BS around rep just sucks.That might be where the word "Overflow" comes from. 😛
So they named...
"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
July 28, 2014 at 12:15 pm
pmscorca (7/23/2014)
I repeat that I know that SQL Server 2014 has rights to downgrade.
Simply, I want to know how technically I...
"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
July 23, 2014 at 12:21 pm
Schema changes will get modified across in the same way as anything else. If you have to have users off one system to make the changes, you need them off...
"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
July 23, 2014 at 8:59 am
Best answer I can give you is to test it. In all likelihood, I'd say, yes, you'll see a performance benefit since the vast majority of systems have more reads...
"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
July 23, 2014 at 8:58 am
Uninstall and reinstall. There is not a "downgrade" path for installations. If you don't have databases to worry about, it should be very quick.
"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
July 23, 2014 at 8:49 am
I see what everyone is saying and I don't disagree with them, but I know where Brandie is coming from. You make compromises in order to make things work well....
"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
July 23, 2014 at 8:45 am
WayneS (7/23/2014)
Steve Jones - SSC Editor (7/22/2014)
That first one is great, Gail. And that was a great costume.Having never been to SQLBits, what is the deal with the costumes there?
They...
"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
July 23, 2014 at 8:42 am
I'm really not going to do the work for you.
I'll give you a hint to get you started though. There are three items listed above that are people. Figure 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
July 23, 2014 at 6:11 am
Brandie Tarvin (7/23/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
July 23, 2014 at 5:39 am
For the same server, with the same data, on the same database, with identical statistics, for a single execution, with absolutely zero contention, you should be seeing roughly the same...
"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
July 23, 2014 at 5:35 am
Thanks for posting your solution. Now when anyone searches for this same problem and finds it, they'll know what you did to solve it. That really helps.
"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
July 23, 2014 at 5:26 am
I won't design it for you. I don't get any grade.
Don't think of it as wills and people. Just think of it as things. Some of the requirements you have...
"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
July 23, 2014 at 5:25 am
You can't do an include on a constraint. Your only real alternative would be to recreate the index as just a unique, non-clustered index. Then you could do includes. You...
"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
July 23, 2014 at 3:54 am
You might also want to take a look at Michelle Ufford's scripts[/url].
"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
July 23, 2014 at 3:49 am
Viewing 15 posts - 7,666 through 7,680 (of 22,219 total)