Viewing 15 posts - 35,941 through 35,955 (of 49,558 total)
Esalter (11/11/2009)
I'm surprised that non clustered indexes don't also use the RID to provide a more efficient use of space.
A RID is 8 bytes. An integer column defined as identity...
November 11, 2009 at 8:24 am
TheSQLGuru (11/11/2009)
November 11, 2009 at 8:17 am
siddartha pal (11/11/2009)
Yes, we are not changing any isolation level in code.
Well something is setting the isolation level to serialisable. I think you need to find what it is. Check...
November 11, 2009 at 7:57 am
talltop-969015 (11/11/2009)
Hmmm, the link is there at the bottom of Part 2 though.
Yes it is. Steve added the links, probably so that he wouldn't have to repeatedly edit the...
November 11, 2009 at 7:01 am
Is there supposed to be any transactional replication set up? Are there any transactional replication publications?
November 11, 2009 at 6:49 am
talltop-969015 (11/11/2009)
Unfortunately, I was not able to read Part 3 as of yet since there seems to be an error on the web page.
That's because it hasn't been...
November 11, 2009 at 6:48 am
Can you post the entire deadlock graph please?
November 11, 2009 at 6:25 am
Esalter (11/11/2009)
I find it difficult to believe this article, especially the reference that all non clustered indexes use the clustered index as their lowest level address
Why do you find...
November 11, 2009 at 6:15 am
siddartha pal (11/11/2009)
SELECT MAX(ID) FROM dbo.RequestStatusWHERE RequestID = @requestID AND (StatusID = 10 OR NextStatusID = 10)
Just to double check, dbo.RequestStatus is a table?
Does this deadlock happen often? Can...
November 11, 2009 at 5:51 am
dan-404057 (11/10/2009)
I have a database set for Full Recovery, which I run Snapshot Replication on for DW purposes once per day. (The log_reuse_wait field = 6).
Any transactional replication?
What does...
November 10, 2009 at 3:41 pm
|--| (11/10/2009)
By the way, you would be surprise of who I am and my experience.
Do tell.
November 10, 2009 at 3:37 pm
|--| (11/9/2009)
Everything inside MS-SQL cache, should and must be actual execution plans or not? if s there, means it ran or it is running now.
Estimated and actual are,...
November 10, 2009 at 3:32 pm
For that particular query, quick guess would be a composite index on
DocID, DocDate, docSubject, docNo (in that order)
November 10, 2009 at 2:34 pm
Viewing 15 posts - 35,941 through 35,955 (of 49,558 total)