Viewing 15 posts - 40,951 through 40,965 (of 49,571 total)
Leo Leong (2/19/2009)
well, here is a simplified version of my scripts:Table Structure (Actual table consists of > 100 columns and 20 mil records)
February 19, 2009 at 12:27 pm
madhu.arda (2/19/2009)
Iam not sure that somebody manually created these statistics with exacltly the same form(Excep sqlserver admin) nobody has access though).If some body created them how can we know?
Use INDEXPROPERY...
February 19, 2009 at 12:26 pm
Be nice. He's new at this. (apparently)
Edit: Or maybe not. How have I managed to not notice this guy so far?
Alvin Ramard (2/19/2009)
February 19, 2009 at 12:08 pm
SanjayAttray (2/19/2009)
SQL Server is by default is set to page lock.
SQL will use row, page, extent or table as necessary depending on the number of rows been affected...
February 19, 2009 at 11:58 am
How many rows are you deleting from Tx1? Any blocking?
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
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...
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.
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.
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?
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!
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...
February 19, 2009 at 9:17 am
What's the max that the usage gets to in the course of normal operations?
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...
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,...
February 19, 2009 at 8:53 am
Viewing 15 posts - 40,951 through 40,965 (of 49,571 total)