Viewing 15 posts - 10,501 through 10,515 (of 22,219 total)
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
I'm going by what the error message says : This SQL Server edition and/or Windows Server System does not meet one or more of the requirements.
This means you've got something...
"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 6:48 am
READ ONLY on a database means it no longer bothers maintaining locks because there is not possibility of data modification.
"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 6:36 am
The one thing I see missing are log backups. You don't list those as the types of backups, but you have databases in FULL recovery. If you're not running log...
"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 6:18 am
If the Availability Group says you don't have the right configuration, then probably you don't have the right configuration. Do you have an outstanding reboot which will finish the install...
"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 6:14 am
The vast majority is done through the provided interfaces and T-SQL. But if you're really interesting in automating administration of the servers and instances, PowerShell is your bestest friend in...
"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 6:12 am
Viewing 15 posts - 10,501 through 10,515 (of 22,219 total)