Viewing 15 posts - 6,451 through 6,465 (of 22,221 total)
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
To build a web front end for your database can be a lot of work. There are multiple third party products out there that should help. Assuming you have 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
April 6, 2015 at 12:24 pm
Sagar-636902 (4/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
April 6, 2015 at 12:19 pm
Yep, LSNs are reused. It won't make for a great unique identifier.
"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 10:58 am
Are you using the DMVs to look at the blocked and blocking processes? If not, sys.dm_exec_requests will show you which processes are blocked and which are blocking. You can then...
"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 10:24 am
I'll go one further. I'd suggesting taking a look at Jeff Moden's article on Tally Tables[/url] and using that to take the comma delimited list and turn it directly into...
"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 8:45 am
efyuzegeekgurl (4/5/2015)
Thanks for replying.
Actually on our production server, we have a standard maintenance plan setup that runs the "Check Database Integrity Task" nightly before taking a full backup....
"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:53 am
Yes. Although, generally, you don't see deadlocks from a procedure that only has 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
April 5, 2015 at 5:24 am
Maybe I'm confused, but it just sounds like an INSERT... SELECT operation. Insert into the new table using the values of the old one. Or am I missing something? 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 5, 2015 at 5:22 am
Assuming you have a primary key to identify each row, I'd suggest setting things up through the MERGE command instead of just insert. That way you can do what's appropriate,...
"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 5, 2015 at 5:19 am
I'll just add that you should make sure you still run DBCC CHECKDB on your production server, but that you just do the PHYSICAL ONLY check. Since you're going 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
April 5, 2015 at 5:16 am
A lot of what you're asking about isn't necessarily related to capacity planning. Just speaking on capacity planning, focus on size and volume and growth. "How many" and "how much"...
"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 5, 2015 at 5:13 am
Jeff Moden (4/4/2015)
krypto69 (4/4/2015)
Grant Fritchey (4/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
April 5, 2015 at 4:54 am
xsevensinzx (4/4/2015)
Grant Fritchey (3/31/2015)
Steve Jones - SSC Editor (3/31/2015)
Grant Fritchey (3/31/2015)
I use semicolons on terminators for all my statements. Everyone should.
You do or Prompt does it for you?
Well, Prompt does...
"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 5, 2015 at 4:53 am
Viewing 15 posts - 6,451 through 6,465 (of 22,221 total)