Viewing 15 posts - 12,601 through 12,615 (of 22,227 total)
The traceflag puts a lot more information than that into the error log. You should be able to get the database id, the spid involved, the exact resources at 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
May 5, 2011 at 5:28 am
If updating the stats works, then are you updating stats in production? Is production on a different version of SQL Server? If so, it's possible that you're effectively performing an...
"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
May 5, 2011 at 5:26 am
The amount of work to DELETE your data down to 5% of the size of production is probably just as much work to INSERT data up to 5% of production....
"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
May 4, 2011 at 8:08 am
First thing that comes to mind is that it's the compile time. Probably not since the next query can run much quicker. Second thing that comes to mind is 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
May 4, 2011 at 7:57 am
Jack Corbett (5/4/2011)
GilaMonster (5/4/2011)
Jack Corbett (5/4/2011)
"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
May 4, 2011 at 7:47 am
Whether in Simple or in Full, you need enough space in your log to support the transactions you put through it. Exactly what that size represents is something that you...
"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
May 4, 2011 at 5:52 am
Did I find any difference between what and what?
The right protocol is the one that supports your network. If you are on a network that doesn't have TCPIP packets (which...
"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
May 4, 2011 at 5:24 am
You can't do both. If your database is in Full recovery, you have to run log backups. If you don't want to run log backups, you take the database to...
"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
May 4, 2011 at 5:22 am
That's an estimated plan unfortunately, so there will be less data there.
You have tons of functions. I can't tell what's happening in here without seeing that code as well. It's...
"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
May 3, 2011 at 4:16 pm
Raymond van Laake (5/3/2011)
Hehe, you're absolute right about testing! I certainly will, it's just @#$@$@##$@* busy here... but I know I must take the time to do the tests.Thanks!
Just imagine...
"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
May 3, 2011 at 12:00 pm
I agree, Red Gate SQL Compare. What's more, you don't have to run a restore. SQL Compare can read a backup and compare the backup to your 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
May 3, 2011 at 10:42 am
You have just discovered exactly why so many people caution so strongly against using nolock. It's just not a "run fast" switch as it keeps getting used.
"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
May 3, 2011 at 7:08 am
GilaMonster (5/2/2011)
Woot!!!!!!!!!!http://www.allenkinsel.com/archive/2011/05/further-promoting-the-growth-of-speakers/
Well earned too. Congratulations! Nothing like knowing you have a reservation.
"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
May 2, 2011 at 8:28 pm
GilaMonster (5/2/2011)
Totally irrelevant and useless,...
"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
May 2, 2011 at 8:27 pm
GilaMonster (5/2/2011)
Please note: 4 year old thread
That's weird. It popped up on my RSS feed. I should only see new posts. I didn't even bother to check.
"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
May 2, 2011 at 3:41 pm
Viewing 15 posts - 12,601 through 12,615 (of 22,227 total)