Forum Replies Created
Viewing 15 posts - 11,161 through 11,175 (of 22,224 total)
-
RE: Are the posted questions getting worse?
Koen Verbeeck (4/5/2012)
Grant Fritchey (4/5/2012)
Yeah, I feel for him. I've had WAY too many arguments with people demanding that I rearrange the laws of physics because they said so.If I...
"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?
Koen Verbeeck (4/5/2012)
SQLRNNR (4/4/2012)
GilaMonster (4/4/2012)
Who feels like doing the impossible? http://www.sqlservercentral.com/Forums/Topic1278455-391-1.aspxA lot of attitude on that one.
I think the attitude comes from a lot of frustration.
Yeah, I feel for him....
"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: Reading data from the Transaction Log?
anthony.green (4/5/2012)
couple of things and sorry if you cant do this either but you only detail no changes to the current databases.could you not create a secondary version of the...
"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: Reading data from the Transaction Log?
I'd probably go with using extended events to audit the changes, but I can see how that might be difficult to see what's changed when, etc.
So, let's think outside the...
"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: Treat the Database like Code
call.copse (4/5/2012)
This is one area I do find hard to make easy. I do agree it has to be done absolutely but getting a team of people to use 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: slow running query until DBCC FREEPROCCACHE
Make sure your statistics are up to date is about your only option in SQL SErver 2005.
In 2008 or better you can start looking at filtered indexes, plan guides, other...
"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 Behaviour
I don't understand the statement "not get anything in the execution plan." What are you expecting to get? The values in the execution plan regarding cost are only estimates based...
"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
You just have to load it in smaller chunks and make sure your transaction log backups are running often enough (if the database is in FULL recovery). We use 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: Why so fast .. or is it, why so slow?
Without setting up the tests, I can't tell you why. But... I can tell you where to look.
Check out both execution plans. In fact, you don't have to rerun the...
"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 Behaviour
While that query is simple, as you've illustrated, the optimizer is probably going to be able to rearrange the structure so that you're getting a good clean JOIN. But, as...
"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
I wouldn't recommend using Profiler on a production system. The way it gathers data can lead to performance problems. Better to set the trace up using TSQL scripts.
If you can'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: Performance issues on huge table (40 columns, 500M rows)
aaron.reese (4/3/2012)
Grant Fritchey (4/3/2012)
And the JOIN criteriaDRP.rank = DRD.rank + 1I suspect that's going to lead to scans too.
Why? - not saying it won't but what makes you think that...
"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: is it possible to re-order the intellisense options as they appear?
There must be something else going on. You should be seeing Football first. See this example from AdventureWorks
You can see the SalesPerson and then the SalesPersonQuotaHistory. Yours should be going...
"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: Performance issues on huge table (40 columns, 500M rows)
And the JOIN criteria
DRP.rank = DRD.rank + 1I suspect that's going to lead to scans 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: Are the posted questions getting worse?
Lynn Pettis (4/3/2012)
Some people really shouldn't be allowed near SQL Server systems.Come on. I'm not that dangerous.
"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 - 11,161 through 11,175 (of 22,224 total)