Viewing 15 posts - 6,436 through 6,450 (of 22,219 total)
Yeah, that will reduce the number of values, but most people don't hit the issue. But, if you do, you can RESEED and set the seed to -1 and 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
April 7, 2015 at 5:21 pm
It means that even though you define the column as INT, if a given value would have fit within TINYINT, then that's what gets defined and stored for that value....
"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
April 7, 2015 at 4:22 pm
So a restore of the database on dev and the proc runs good, but in production the proc runs bad?
Sounds like a server setting and/or hardware then. Without that, I'd...
"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
April 7, 2015 at 4:14 pm
Do you have third party software installed on one of the servers for doing backups?
"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
April 7, 2015 at 3:54 pm
Can you restore the backup on the original server (if it's production, obviously, move it to a different database in the restore)?
"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
April 7, 2015 at 3:51 pm
You might want to go look at the documentation for SP3. Maybe there's something that if fixes that mess with restores from SP2. That's my best guess at the moment.
"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
April 7, 2015 at 3:47 pm
Yeah, everything that was between SP1 & SP2 will be included. Anything after SP2 will 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
April 7, 2015 at 12:24 pm
Deadlocks will present themselves as errors, not just a long running proc.
I agree it could be blocking. Check to see if there are blocking issues. Does your production server 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
April 7, 2015 at 12:23 pm
Are you sure they're exactly the same version of SQL Server? Because it sounds like you're getting a version error. Could the one server be SQL Server 2008R2 and 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
April 7, 2015 at 12:18 pm
Hate to backtrack if it's been asked, but have you looked at the wait statistics on this? I'd be curious as to what it is waiting on. Maybe it 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
April 7, 2015 at 11:30 am
Maddave (4/7/2015)
Do you mean as follows: (Obviously changing the values dynamically for each pass in the real code).
DELETE DocumentResultDataItem
WHERE DocumentResultDataItem.ResultItemRecordId BETWEEN 225392327
...
"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
April 7, 2015 at 5:43 am
If you have an MSDN license, you can work with Azure for free, up to a certain limit each month. The pricing is here[/url]. Just keep the size of your...
"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
April 7, 2015 at 4:19 am
GilaMonster (4/7/2015)
If an LSN ever reset to a lower value it would result in the database being suspect and needing...
"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
April 7, 2015 at 4:07 am
Since you have the start and end values, instead of just say TOP 10000, how about just saying, delete 10000 rows of information. Pass the start value, then 100000 past...
"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
April 7, 2015 at 4:06 am
dianne 32446 (4/6/2015)
Thank you so much! At least that gives me somewhere to start reading. 😛
Sorry, wasn't trying to be unhelpful. There just really isn't anything for putting...
"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
April 6, 2015 at 4:11 pm
Viewing 15 posts - 6,436 through 6,450 (of 22,219 total)