Viewing 15 posts - 5,761 through 5,775 (of 22,219 total)
j-1064772 (8/7/2015)
Move to the top, before any DML the following:[/font]
[font="Courier New"]CREATE TABLE #results(...[/font]
[font="Comic Sans...
"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 7, 2015 at 8:13 am
VERIFYONLY is a good test of a backup. However, it's an incomplete test. For it to be more complete, you must use CHECKSUM when you take the backup. Then 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 7, 2015 at 7:25 am
JaybeeSQL (8/7/2015)
GilaMonster (8/6/2015)
Replay isn't to monitor the effects of the load, it's to generate that load against a test server. You could...
"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 7, 2015 at 7:23 am
The main issue is that you'll be slowing down performance of INSERT/UPDATE/DELETE queries to maintain all your indexes. The "too many" label can be hard to define. If you need,...
"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 7, 2015 at 4:27 am
sqlguy-736318 (8/6/2015)
Can you describe any specific scenarios where not having the "go" keyword will cause the SSMS batch to fail?
Let's say you have a script that creates two stored procedures....
"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 7, 2015 at 4:24 am
This is really straight forward. You can use the RESTORE command and provide a new name. You just have to use the WITH MOVE options of the command in order...
"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 7, 2015 at 4:22 am
Jeff Moden (8/6/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 7, 2015 at 3:57 am
GilaMonster (8/6/2015)
Replay isn't to monitor the effects of the load, it's to generate that load against a test server. You could use...
"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:22 am
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
Viewing 15 posts - 5,761 through 5,775 (of 22,219 total)