Viewing 15 posts - 20,146 through 20,160 (of 22,224 total)
Congratulations. Good work.
"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
June 17, 2008 at 8:22 am
Provisional-DBA? But that'd be true & not funny.
Uhm... wanna-be-DBA?
"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
June 16, 2008 at 11:16 am
OK, but what did it mean?
"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
June 16, 2008 at 10:42 am
You're hitting a variation of parameter sniffing (here's Ken Henderson's description of parameter sniffing). Usually this is a good thing, but sometimes it isn't. Ken shows a method for helping,...
"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
June 16, 2008 at 8:49 am
I'd suggest two things, first, get an estimated execution plan with the parameters and compare it to an actual execution plan without. Also, because you're setting your date values to...
"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
June 16, 2008 at 6:55 am
Do everything the previous poster said. If you're still getting the error, post the full error, not "something like this" because that's really hard to narrow down.
"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
June 16, 2008 at 6:23 am
Start by succinctly explaining the problem you're trying to solve. Absolutely show hard number examples. Be very careful of using technical jargon, these aren't tslq coders, they're managers. Focus on...
"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
June 16, 2008 at 6:19 am
Another vote for Itzik's books. Absolute must reads. Kalen Delaney's book on internals is a must read.
I've heard that Kalen's book on performance and troubleshooting is good but I haven't...
"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
June 16, 2008 at 6:10 am
I'm flummoxed.
When I said recompiles, I did mean recompiles caused by the code, not a recompile that you ran. Do you have anying in the code that would cause 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
June 13, 2008 at 10:58 am
Duly chastised and I've proven my lack of reading ability, yet again.
"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
June 13, 2008 at 10:54 am
Part of the problem is returning 1 million rows. Does the user need a million rows? Are they really using a million rows? Are they going to look at 1...
"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
June 13, 2008 at 8:59 am
Whoa! What a mess. So, in short, FIRST() functions in a fashion somewhat, but not entirely, similar to TOP(1)?
"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
June 13, 2008 at 7:27 am
What everyone else said is very correct. Multiple disks with multiple files and file groups is the way to go.
The one thing I would add is that I've read (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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 13, 2008 at 7:18 am
Looking at the execution plan, I'd try creating a second index, just on fk_tbl_visits_id. There's no guarantee it's going to work. 1m rows out 60m has a .0167 ratio, which...
"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
June 13, 2008 at 7:08 am
Purist anything in databases is usually a sign for disaster. There are places where an identity column as a PK and as FK's in all the related tables not only...
"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
June 13, 2008 at 6:55 am
Viewing 15 posts - 20,146 through 20,160 (of 22,224 total)