Forum Replies Created

Viewing 15 posts - 1 through 15 (of 17 total)

  • RE: Question on IF EXISTS()

    GilaMonster (2/16/2010)

    kingscriber (2/16/2010)

    It would seem that Exists needs to perform full table scans within that view?

    No it doesn't

    Maybe the optimizer doesn't work for functions like this?

    Sure it does.

    The execution...

    February 16, 2010 at 7:44 am

    #1119288

  • RE: Question on IF EXISTS()

    Jeff Moden (2/15/2010)

    What happens if you reverse the order between the two methods?

    I'm thinking that cache helped the second one... a lot.

    Good thinking, but I am afraid I get the...

    February 16, 2010 at 6:37 am

    #1119232

  • RE: Conflicting Information

    TheSQLGuru (1/28/2010)

    >>Do you have a suggestion on migrating to something else? Such as a sequential integer or something like that? What is more popular?

    Deciding on an indexing strategy is...

    January 28, 2010 at 9:16 am

    #1110140

  • RE: Conflicting Information

    GilaMonster (1/28/2010)

    Because it's often very useful in combination with other columns. Without seeing your query or the exec plan, that's all I can really suggest.

    This series (3 parts) is maybe...

    January 28, 2010 at 8:34 am

    #1110091

  • RE: Conflicting Information

    TheSQLGuru (1/28/2010)

    We cannot really help you without lots more information, and true help may be beyond the scope of forum postings/responses.

    However, I can say unequivocally that GUIDs are...

    January 28, 2010 at 8:17 am

    #1110068

  • RE: Conflicting Information

    CirquedeSQLeil (1/27/2010)

    Some of what factors into the performance and which column to list first comes from the query and how it is written. Could you provide the query and...

    January 27, 2010 at 6:49 am

    #1109246

  • RE: Deadlock Scenario

    GilaMonster (1/19/2010)

    That's good to know. Can you change the isolation level in the linq? If you do, does it fix the deadlocks?

    I can change it, and it does seem to...

    January 19, 2010 at 7:13 am

    #1105398

  • RE: Deadlock Scenario

    I just got some breaking news about the TransactionScope Class and what is going on with my .Net client.

    Currently the operation that I am calling uses a mix of ADO.NET...

    January 18, 2010 at 3:26 pm

    #1105168

  • RE: Deadlock Scenario

    GilaMonster (1/18/2010)

    If you're talking about a SQL cursor, then not by itself it doesn't.

    Either there's a different isolation level set by the client or there's an explicit SET TRANSACTION...

    January 18, 2010 at 2:43 pm

    #1105150

  • RE: Deadlock Scenario

    GilaMonster (1/18/2010)

    Excessive locking timeout are not normal. It tells me that you've got the lock timeout set too low or you have excessive blocking. I would suggest, given that and...

    January 18, 2010 at 9:18 am

    #1104999

  • RE: Deadlock Scenario

    Allow me to try to get this right. I think it would be rude for me to be ignorant of the specifics of what you are trying to say.

    SELECT

    lockMode="RangeS-S"...isolationlevel="serializable (4)"

    UPDATE

    lockMode="X"...isolationlevel="read...

    January 18, 2010 at 7:29 am

    #1104927

  • RE: Deadlock Scenario

    Yes I can set the isolation level for my .Net Data Provider. It sounds like that might be the way to go anyways.

    I did do this:

    set transaction isolation level...

    January 16, 2010 at 7:11 am

    #1104591

  • RE: Deadlock Scenario

    GilaMonster (1/15/2010)

    SQL doesn't decide on isolation levels. If it's something other than read committed, that isolation level was explicitly set by the client, or in a stored proc

    Well, I did...

    January 15, 2010 at 1:31 pm

    #1104430

  • RE: Deadlock Scenario

    ok I figured it out...it was all the way at the bottom of the page. Anyways, it is called SPandTableInfo.zip. It has everything you are requesting in there. Thank you...

    January 15, 2010 at 9:06 am

    #1104269

  • RE: Deadlock Scenario

    Can't seem to find a way to post a zip file of that information. Maybe because I am a newbie poster?

    Edit: Check out my post below

    January 15, 2010 at 8:53 am

    #1104262

Viewing 15 posts - 1 through 15 (of 17 total)