Viewing 15 posts - 10,501 through 10,515 (of 22,226 total)
Those are valid counters and will show how your system is behaving. They're the same counters you get from running Performance Monitor. You can also look at sys.dm_exec_query_stats to see...
"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:14 am
Yeah, TDE gets you encrypted backups. Other than that, you need to look at something like Red Gate SQL Backup[/url]. We do encryption and password protection. The tool also provides...
"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:12 am
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
Viewing 15 posts - 10,501 through 10,515 (of 22,226 total)