Viewing 15 posts - 40,936 through 40,950 (of 49,552 total)
How many rows are you deleting from Tx1? Any blocking?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2009 at 11:32 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic660511-8-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2009 at 11:31 am
Is that a particularly expensive query? The total cost of all the operators in the query will be 100, so if it's a simple query, there's nothing wrong with one...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2009 at 11:29 am
Jack Corbett (2/19/2009)
Would some sort of Mock Interview work as a networking opportunity?
I'd think so.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2009 at 10:40 am
Grant Fritchey (2/19/2009)
I'm testing for my 3rd degree on the 14th of March.
3rd Degree black? Woot! Good luck.
My sensei's been pushing me to do 2nd for a while.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2009 at 10:35 am
jay holovacs (2/19/2009)
"object reference not set to an instance of an object"
What version's the server and what version's your client tools?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2009 at 10:34 am
Grant Fritchey (2/19/2009)
uh, you have to promise not to let her hit me.
What's this? I practice a defensive style. He's the one who knows how to punch!
http://www.alandallessandrokarate.com/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2009 at 10:17 am
Aaron N. Cutshall (2/19/2009)
If I change them for an OR clause, won't that invalidate the index lookup?
Try it and see.
Test a version with the ISNULL against a version with...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2009 at 9:17 am
What's the max that the usage gets to in the course of normal operations?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2009 at 9:07 am
Putts (2/19/2009)
The first one will complete in 3 seconds. The second one will take 1min 17sec.
No surprise. Distinct means "Sort (or hash) the entire result set, eliminate duplicate...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2009 at 9:00 am
Ok, disregard index suggestions from earlier, the actual plan's very different
Widen the index IX_tbAtt_Patient_RIGlobalProviderID on tbAtt_Patient. Add SourceID and IsParticipating to the index key
Add an index on tbREg_MedGroup (ReportGroup, Eff_DateBeg,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2009 at 8:53 am
There's a couple of definite row estimate discrepancies.
The ad-hoc query shows an estimated 697 rows from the att_patient table, while the function shows just 1. Which sounds more correct?
There's no...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2009 at 8:40 am
Aaron N. Cutshall (2/19/2009)
Sorry for the estimated plans, but since we couldn't get the function to operate, we were unable to get actual plans.
Could you post the actual plan for...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2009 at 8:24 am
am (2/19/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2009 at 8:13 am
Lynn Pettis (2/19/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2009 at 8:12 am
Viewing 15 posts - 40,936 through 40,950 (of 49,552 total)