Viewing 15 posts - 10,501 through 10,515 (of 22,224 total)
Yeah, if the question is a follow-up to a discussion in the thread, I tell them to post it to the thread and I answer it there. I won't mess...
"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
September 14, 2012 at 9:08 am
Catcha (9/14/2012)
Yes, with recreating the index I will use the following orderNon-clustered -> primary key -> clustered
So rebuilding of whole table will be performed last.
Thought?
Nope. Backwards. If...
"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
September 14, 2012 at 9:02 am
I can't see the attachments. Based on what's described, I have a guess. That sounds like a messy complex query. I'll bet, if you look at the Reason for Early...
"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
September 14, 2012 at 9:00 am
ksr39 (9/11/2012)
Actually I am taking my backup from cmd window with a script it’s a general script to take a backup, but I am taking the backup file to a...
"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
September 14, 2012 at 8:51 am
OceanDeep (9/13/2012)
"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
September 14, 2012 at 6:02 am
Good suggestion. I haven't started tuning the query yet, but that's absolutely one of the changes I'll make. Thanks.
"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
September 13, 2012 at 6:03 am
Another suggestion. Get a copy of virtualbox. It's free. You can install your OS to a virtual machine and get it set, then make a copy. Try installing SQL Server...
"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
September 6, 2012 at 2:34 pm
Do you mean that you used the uninstall process for software through the Control Panel? If so, you should be ready to go for a clean install. If you did...
"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
September 6, 2012 at 1:44 pm
GilaMonster (9/5/2012)
What you describe (SSMS starting and asking you to connect to a server) is completely correct...
"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
September 6, 2012 at 5:42 am
Brandie Tarvin (9/5/2012)
L' Eomot Inversé (9/5/2012)
Brandie Tarvin (9/5/2012)
Steve Jones - SSC Editor (9/4/2012)
"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
September 5, 2012 at 7:23 am
jrichards54 (9/3/2012)
"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
September 4, 2012 at 2:05 pm
jason.spangler (8/31/2012)
"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 31, 2012 at 7:16 am
It does look like it might be intellisense crashing the restore. Have you tried it with intellisense turned off? This is mighty strange.
"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 30, 2012 at 4:51 am
Do you have the deadlock graph? I suspect you might be seeing a deadlock within a system table, but I can't be sure about that, just a guess.
"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 29, 2012 at 9:11 am
First, I'd stick to using 1222. It has better information than 1204. Second, yes, these are very lightweight processes. They don't put excessive load on the system. They capture 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 29, 2012 at 9:09 am
Viewing 15 posts - 10,501 through 10,515 (of 22,224 total)