Forum Replies Created
Viewing 15 posts - 11,161 through 11,175 (of 22,219 total)
-
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 -
RE: sql parameters
dianerstein 8713 (4/3/2012)
My company has such extreme change control procedures, it is difficult to put anything into production. There is so much you need to fill out to put anything..."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: DeadLock
The things I'd look at first are the two processes. Each of those shows you the lock that it was holding. That's where the conflict comes in, so that's 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: Catching the culprit!!
S_Kumar_S (4/3/2012)
Thanks So much Grant! Good to see big guys helping out "lesser knowns" 🙂Grant Fritchey (4/3/2012)
Since you're trying to track data changes, batch_requests and rpc_complete are the two events..."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: Catching the culprit!!
Since you're trying to track data changes, batch_requests and rpc_complete are the two events I would track. For details on how to use extended events, hit the Books Online and...
"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: Help Me:Order of operators operation.
I posted the question on twitter (#sqlhelp) to get some more feedback. This is anticipated behavior (at least according to Microsoft). You can see it in this Connect item.
Basically...
"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,219 total)