Viewing 15 posts - 8,506 through 8,520 (of 22,224 total)
I've never seen SSMS by itself cause any issues and I've left it open for days at a time.
"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
March 31, 2014 at 4:14 pm
Ummm... You might not want to move to working as a DBA if network admin was stressful. DBA work becomes hyper-stressful. Think about it, one of the single most important...
"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
March 31, 2014 at 4:13 pm
New Born DBA (3/31/2014)
Thanks everybody for replying. Can I use import export utility? Just asking.
This will put more load on the production system than using the backup and restore process.
"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
March 31, 2014 at 11:58 am
Even if you do tests to determine an approximate run time, you can still hit resource contention or blocking issues that cause that time to change. This is a tough...
"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
March 31, 2014 at 5:45 am
Partitioning is not primarily a performance tuning mechanism. It is primarily a data management mechanism. There are cases where you can get performance improvements, but you need to remember that...
"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
March 31, 2014 at 5:33 am
The only suggestion I had for the higher versions of SQL Server is that you could use the ROW_NUMBER to break up the deletes into smaller groups. You still 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
March 30, 2014 at 2:26 pm
Nope. You got it. If you're inserting to a table with a clustered index, it's inserting into the clustered index. That event, by itself, is absolutely not a performance problem.
"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
March 28, 2014 at 1:26 pm
A clustered index stores the data. So when you run a delete statement, it goes to the clustered index to delete the data. That's how it works.
"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
March 28, 2014 at 12:23 pm
As I said before, your choices in 2000 are more limited. Filter the data on additional criteria to reduce the batch size so you're deleting in smaller chunks and providing...
"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
March 28, 2014 at 12:12 pm
Steve Jones - SSC Editor (3/28/2014)
GilaMonster (3/28/2014)
Ed Wagner (3/28/2014)
Grant - You have booth babes??? :w00t:Grant *is* the booth 'babe' 🙂
What am I?
We're still working on that.
"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
March 28, 2014 at 11:01 am
Ed Wagner (3/28/2014)
GilaMonster (3/28/2014)
Ed Wagner (3/28/2014)
Grant - You have booth babes??? :w00t:Grant *is* the booth 'babe' 🙂
Oh boy - I should have kept my mouth shut. Please, no pictures...
"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
March 28, 2014 at 10:06 am
JoshDBGuy (3/28/2014)
New Born DBA (3/28/2014)
JoshDBGuy (3/28/2014)
"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
March 28, 2014 at 8:22 am
Jeff Moden (3/28/2014)
SQLRNNR (3/28/2014)
Sean Lange (3/28/2014)
dwain.c (3/28/2014)
Ville-Pekka Vahteala (3/27/2014)
Luis Cazares (3/27/2014)
I'm afraid that this database is full of...
"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
March 28, 2014 at 8:09 am
Sure sounds like you're either not backing up transaction logs or not backing them up often enough. Read more about it here[/url].
It's also possible that you have a broken replication...
"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
March 28, 2014 at 8:01 am
mpdillon (3/28/2014)
I did not know that so thanks for the advice. In this instance I have a Server dedicated to testing. I am the only one using it. I turn...
"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
March 28, 2014 at 7:57 am
Viewing 15 posts - 8,506 through 8,520 (of 22,224 total)