Viewing 15 posts - 5,776 through 5,790 (of 22,226 total)
sgmunson (8/6/2015)
Sounds to me like whoever created this question has either set up a "trick question", or doesn't know what they're doing.
Why not both?
"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 6, 2015 at 7:21 am
Stuff like this has to go:
INNER JOIN app.fund F
ON CAST(l.lipperid AS varchar(50))= CAST(f.AccountGr AS varchar(50))
You're going to have to work through this in really small pieces. There's no magic bullet...
"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 6, 2015 at 7:18 am
I agree. Neither of those are on the deprecation list.
"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 6, 2015 at 6:45 am
jasona.work (8/5/2015)
GilaMonster (8/5/2015)
jasona.work (8/5/2015)
GilaMonster (8/5/2015)
And to get back on...
"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 9:33 pm
JaybeeSQL (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 9:30 pm
Deprecated means it's going to be removed from a future version of the product. It's still there. But, if you build anything based on it, don't be surprised when 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
August 5, 2015 at 10:24 am
Well, Luis is right. It won't run and therefore will return zero rows. But that question is an extremely poor demonstration of SQL Server knowledge. However, the provided answers 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 7:27 am
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
Viewing 15 posts - 5,776 through 5,790 (of 22,226 total)