Viewing 15 posts - 5,776 through 5,790 (of 22,219 total)
Yeah, what Gail said.
It's not that we don't know the answer. It's that the question, as you have it phrased, can't be answered. There's no way to know how many...
"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
August 5, 2015 at 6:13 am
If there isn't a service running, SSMS isn't going to be able to connect to anything. Further, at least from what you're showing, you don't have a SQL Server instance...
"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
August 5, 2015 at 6:10 am
Based on this information, we can't answer it either. The question seems pretty suspect to me. I'd suggest following up with whoever provided it and see what they thought 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
August 5, 2015 at 4:43 am
You'll need to go to backups of those databases, and backups taken when they were still 2012. You can't simply downgrade the database. When you did the upgrade, they were...
"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
August 5, 2015 at 4:41 am
Koen Verbeeck (8/5/2015)
"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
August 5, 2015 at 4:29 am
I'd guess it's something on the code side of things. How it's connecting or how the call is being made. There's nothing on the SQL Server side that would limit...
"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
August 5, 2015 at 4:00 am
Also, you know that a TOP without an ORDER BY is not guaranteed to get the same results each time, right?
"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
August 5, 2015 at 3:58 am
If you can, I'd suggest capturing the current system behavior and then using Distributed Replay to simulate your load. It'll take some work, but you should be able to at...
"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
August 5, 2015 at 3:56 am
Yeah, you're trying to create an Azure SQL Database copy of Adventureworks. You're in a VM. That's just like any other version of SQL Server. So you can go 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
August 4, 2015 at 11:54 am
Steve Jones - SSC Editor (8/4/2015)
Is there value in getting the questions/knowledge that people lack in interviews published? Not...
"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
August 4, 2015 at 10:58 am
JoshDBGuy (8/4/2015)
Grant Fritchey (8/4/2015)
"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
August 4, 2015 at 10:51 am
Luis Cazares (8/4/2015)
Grant Fritchey (8/4/2015)
xsevensinzx (8/3/2015)
"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
August 4, 2015 at 8:49 am
xsevensinzx (8/4/2015)
Grant Fritchey (8/4/2015)
xsevensinzx (8/3/2015)
"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
August 4, 2015 at 8:41 am
xsevensinzx (8/3/2015)
"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
August 4, 2015 at 4:50 am
You're better off doing custom scripts. MERGE can, and does, function. But, it's not very tuneable. You get a single execution plan for the INSERT/UPDATE/DELETE regardless of which is used...
"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
August 4, 2015 at 4:42 am
Viewing 15 posts - 5,776 through 5,790 (of 22,219 total)