Forum Replies Created
Viewing 15 posts - 12,391 through 12,405 (of 22,227 total)
-
RE: query running slow
There are differences between the systems already identified. I suspect if you dig you'll find more. You can't have differences, especially as big as different service packs, and still expect...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
GilaMonster (6/9/2011)
I post too much.Congratulations, and no you don't.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Recompilation Reason: "FOR BROWSE PERMISSIONS CHANGED"
That is a weird one. Sorry I couldn't help.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: DMV's
I would pick up a copy of Louis Davidson's and Tim Ford's book. That will give you a bunch of the standard DMOs and how to use them.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Why compatibilty level is important
Basically, if the compatibility level is set to a lower value than the current value of the server, you will have reduced functionality in that database.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: query running slow
First thing to compare between the three servers is the execution plan. If it's identical on all three, then you need to look at server settings. If it's different, first...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Query is running slowly in morning times and it is running normally in evening times.
An execution plan isn't going to tell you that tempdb is 97% of usage. It's giong to tell you that you have index scans instead of seeks or a loop...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
Kiara (6/9/2011)
Tom.Thomson (6/9/2011)
Kit G (6/8/2011)
Wearing boots with a kilt isn't a problem (as long as we have socks). But sandals and a kilt? Perhaps... maybe... in a Roman..."The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
GilaMonster (6/9/2011)
Is this person irritating anyone else, or am I just in low-tolerance mode at the moment?Some of the posts seem... less than original.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
GilaMonster (6/9/2011)
Stefan Krzywicki (6/8/2011)
Kit G (6/8/2011)
Wearing boots with a kilt isn't a problem (as long as we have socks). But sandals and a kilt? Perhaps... maybe... in a..."The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
Stefan Krzywicki (6/8/2011)
Kit G (6/8/2011)
Grant Fritchey (6/8/2011)
Finished my 3 mile contribution gotta go log it.I hate to tell you this, but I wear sandals, sneakers & boots with kilts, but...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Recompilation Reason: "FOR BROWSE PERMISSIONS CHANGED"
andykr-773587 (6/8/2011)
Sounds like I need to do some more digging here.Thanks for the input though, I will report back if I find anything.
(When will you be out our way again?...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: DBA Books for new DBA
Itzik's books are some of the first I recommend. After that, get a copy of Kalen Delaney's book SQL Server Internals. Since you're just getting going, you might want to...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: SQL Profiler: Capture writes for specific table(s)
I don't think you can do this with Profiler. You can do it using Extended Events though.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Shrink or Not to Shrink
In general, I'm always wary to shrink log files until I'm sure that I've got them under control so I know what size they really ought to be. You don't...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 15 posts - 12,391 through 12,405 (of 22,227 total)