Viewing 15 posts - 10,471 through 10,485 (of 22,224 total)
dt2 (9/17/2012)
Yes it was in 2012. Simply a vanilla build 2008 R2 server, with vanilla sql 2012 instance.
I created a new database,...
"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 17, 2012 at 7:21 am
SQLSACT (9/17/2012)
Grant Fritchey (9/17/2012)
SQLSACT (9/17/2012)
Grant Fritchey (9/14/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 17, 2012 at 6:46 am
Not MSSQLSERVER(local). Just:
(local)
And not MSSQLSERVER.(local). Just:
.
You might also try:
yourmachinename\MSSQLSERVER
Please, I don't mean literally "yourmachinename" but rather, the name of your windows machine. Just trying to be more clear.
"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 17, 2012 at 6:27 am
dt2 (9/17/2012)
I can reproduce this on a vanilla 2008 R2 server, with a vanilla SQL install.
Maybe you are just too good and i'm just a dummy, but what am...
"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 17, 2012 at 6:21 am
Because you have to take an initial transaction log backup to begin that process. You're setting up log shipping. It requires you to have logs to ship. The log being...
"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 17, 2012 at 6:13 am
Perry Whittle (9/17/2012)
Grant Fritchey (9/17/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 17, 2012 at 6:01 am
rhythmk (9/17/2012)
Grant Fritchey (9/17/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 17, 2012 at 5:58 am
yuvipoy (9/17/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 17, 2012 at 5:58 am
ISNULL and COALESCE on columns in the where clause are going to hurt performance. I still think your stats are off. I'm seeing estimated 4.5 million, actual 15,000. That's 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 17, 2012 at 5:53 am
SQLSACT (9/17/2012)
Grant Fritchey (9/14/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 17, 2012 at 5:45 am
"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 17, 2012 at 4:31 am
Why on earth would you want to use the GUI anyway?
But, no, I just did a test. Ran a full backup, modified data, ran a differential backup. Made sure all...
"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 17, 2012 at 4:29 am
Full backups do not contain the transaction logs. That's a myth. A full backup has a complete copy of the database including all completed transactions up to the point 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
September 17, 2012 at 4:24 am
If this is occurring over & over, I'd start worrying about my hardware. Have you run consistency checks on these databases to determine what's wrong?
"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 17, 2012 at 4:19 am
If you're not writing your own scripts, you should look to Olla Hollengren or Michelle Ufford. Each person has a set of scripts. I think Olla's are more complete and...
"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 17, 2012 at 4:17 am
Viewing 15 posts - 10,471 through 10,485 (of 22,224 total)