Viewing 15 posts - 16,936 through 16,950 (of 22,219 total)
The one good source I know of is Allen White's blog. He's also published a couple of articles over at Simple Talk. If you find anything else good, let me...
"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
July 22, 2009 at 9:30 am
Yeah, estimated plans are seldom terribly helpful. It's basically the same plan though. It really looks like, based on what you provided, SQL Server is doing the right thing. 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
July 22, 2009 at 9:18 am
That's a slightly odd looking plan. It doesn't have a SELECT statement or a query or any of the meta data about the plan in the XML. How did 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
July 22, 2009 at 8:38 am
Kit G (7/22/2009)
Grant Fritchey (7/22/2009)
"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
July 22, 2009 at 8:00 am
Ah, right. ALZDBA answered it. You're not forcing the backup, you're forcing the restore, but not even that really, you're just kicking all the users off the 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
July 22, 2009 at 7:24 am
Kit G (7/22/2009)
"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
July 22, 2009 at 7:23 am
Tara (7/22/2009)
I think your point make sense to me but would like to know about how it works.
As you said we do have a column " Cdate " which is...
"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
July 22, 2009 at 7:20 am
You need to use the SQL Agent. It's right there in Management Studio. It runs as a service on the machine with SQL Server. Right click on the Jobs folder...
"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
July 22, 2009 at 6:17 am
It's hard to make suggestions without seeing the query and an actual execution plan. Can you post those? Also, in case people need to experiment it's useful to post 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
July 22, 2009 at 6:11 am
I'd suggest using sys.dm_tran_locks instead of the old method. You can get much more granular information and combine the output with other views to get a great deal more information.
"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
July 22, 2009 at 6:08 am
Nothing. I'm an idiot. Sorry, I just misread your question.
No, I don't usually see perfmon miss data, but it's possible. How much are you trying to collect and how frequently...
"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
July 22, 2009 at 6:02 am
The transaction log can fill from transactions, regardless of the recovery mode, although some recovery modes are less likely to fill the log than others. You need to keep 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
July 22, 2009 at 5:55 am
What do you mean by a "forced" database backup?
"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
July 22, 2009 at 5:52 am
. (7/21/2009)
What kind of roleplaying game involves conspiracies, Gail?fnord
Call of Cthulhu. It's all a conspiracy. The Elder Gods. He Who Sleeps. The Crawling Chaos. Ia Ia, Cthulhu Fhtagn!
"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
July 22, 2009 at 5:28 am
Yeah, I'd pay postage on stuff you want to get rid of as well. Post the list. We'll make claims.
"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
July 21, 2009 at 12:20 pm
Viewing 15 posts - 16,936 through 16,950 (of 22,219 total)