Viewing 15 posts - 4,771 through 4,785 (of 5,843 total)
Eswin (2/12/2009)
TanxI created indexes for my temp table but still the issue persists . table scan costs 100%.
The optimizer is pretty darn good. table scans can often be much...
February 13, 2009 at 7:53 am
GĀ² (2/11/2009)
You could also pass in an XML string and parse it into a temp table or table variable.Greg
That is covered in the document I referenced, with example...
February 11, 2009 at 10:36 am
I think RAM usage may be a red herring here. Disk IO is not problematic per the OP. I would check page life expectancy in perf mon just...
February 11, 2009 at 9:45 am
I think Erland has the definitive documentation on this topic:
February 11, 2009 at 9:40 am
Grant Fritchey (2/6/2009)
TheSQLGuru (2/6/2009)
I have seen this for massively partitioned tables as well.
Really. When did it occur? When the query had to hit lots of the partitions or is it...
February 6, 2009 at 11:44 am
Grant Fritchey (2/5/2009)
February 6, 2009 at 9:42 am
Even if you could set at a system level, isolation level is a CONNECTION level setting and is almost universally set by the subsystem doing the connecting as one of...
February 4, 2009 at 12:49 pm
My comments on tempdb have almost NOTHING to do with SPACE. It is IO PERFORMANCE that matters. I can create a 1TB tempdb on a SINGLE DRIVE these...
February 4, 2009 at 10:02 am
Charles Kincaid (2/3/2009)
Joe Celko (2/3/2009)
Hey! I teach SQL, not ethics! š
:w00t: And here I keep buying your books to wave around in our ethics meetings! :w00t:
Good, fast, cheep. ...
February 4, 2009 at 8:21 am
krypto69 (2/3/2009)
Will do ...thanks..While I'm here would there be any benefit to me using
snapshot isolation?
Can you tell me how much investigation/study did you do about snapshot isolation prior to...
February 4, 2009 at 8:18 am
krypto69 (2/3/2009)
So I added the NOLOCK, that stopped the deadlock errors..so then..
I removed all indexes, and created...
February 3, 2009 at 12:10 pm
1) nonclustered indexes are NOT helpful if the value you are searching for is not VERY specific (like <1% of the total rows in the table)
2) at 1K/sec inserts, index...
February 3, 2009 at 9:31 am
Marios Philippopoulos (1/31/2009)
There are two puzzling aspects...
February 3, 2009 at 8:42 am
I think any discussion on deadlock troubleshooting should reference this blog series: http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx
February 2, 2009 at 12:46 pm
Other than the ol' trigger-firing-itself-due-to-update-inside-trigger-ploy, 2 other questions:
1) any OTHER triggers on this table?
2) is the join column a primary key or unique index value? Looks like cartesian...
February 2, 2009 at 12:45 pm
Viewing 15 posts - 4,771 through 4,785 (of 5,843 total)