Forum Replies Created
Viewing 15 posts - 12,376 through 12,390 (of 22,224 total)
-
RE: Basic Index Question
First off, that article is 7 years old, so almost anything it says might be slightly off these days. However, I just read through it and frankly, the author is...
"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: Determining last update to a table
It's not actually a table. It's a Dynamic Management View. If you're looking for it in SSMS, you need to look in system views. But no, unless you've got 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: Stop SQL Server Service or Server Shutdown
Probably no difference because starting the shut down process on the server is going to start the shut down process on SQL Server. But I would still do it by...
"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: CXPACKET Wait - advice on Max Dop setting
The decision for which queries to put through parallelism is all based on the cost threshold, so controlling than rather than simply turning off parallelism completely I've found to be...
"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: Can data in sys.dm_db_index_usage_stats be deleted due to memory pressure?
To my knowledge it can't be, but these tables are all very small. If you have that much memory pressure, you should be looking at your processes, not attempting 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: CXPACKET Wait - advice on Max Dop setting
I would not recommend setting MAXDOP to 1 for most systems. Instead, I'd experiment with bumping up the cost threshold for parallelism. The default value of 5 is way too...
"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: Alias Problems
Nope, server aliases are a shortcut for local connections, not a way to rename the server.
"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: Determining last update to a table
What version of SQL Server are you running? If it's SQL Server 2000, that would explain your issue.
"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?
Tom.Thomson (6/10/2011)
Kit G (6/9/2011)
GilaMonster (6/9/2011)
Stefan Krzywicki (6/9/2011)
I think I'd be more worried about someone with a gladius on a subway car. A claymore is a lot of steel 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: your spare time?
Spare time? Interesting concept as I sit here in an airport traveling back from a user group meeting and posting online here.
Write books and help run a scout troop,...
"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: sys.dm_os_performance_counters
those counters can be accessed through TSQL Queries. There is no set-up required. The Windows OS is maintaining that data for you all the time. Running the query simply accesses...
"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 Function performance / design question
You're running into the basic problems with table variables. They don't have statistics. So, while coding in them looks very neat and clean, performance is a total bear. You're doing...
"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
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
Viewing 15 posts - 12,376 through 12,390 (of 22,224 total)