Forum Replies Created

Viewing 15 posts - 3,751 through 3,765 (of 5,590 total)

  • RE: Deadlock graph help

    G33kKahuna (7/25/2010)

    Thanks Wayne, interesting query. I would just modify it to extract deadlock graph from the XDL file.

    I have the details but confused why even with the triggers disabled keys...

    July 25, 2010 at 11:11 am

    #1197949

  • RE: Are the posted questions getting worse?

    Lynn Pettis (7/23/2010)

    Stefan Krzywicki (7/23/2010)

    Lynn Pettis (7/23/2010)

    Okay everyone, the hardest thing I have had to do since I started here (work) a little over 5 years ago is done, now...

    July 23, 2010 at 2:47 pm

    #1197781

  • RE: Index Types

    cengland0 (7/22/2010)

    WayneS (7/22/2010)

    For everyone that thinks that the BOL reference in the QotD is wrong and that there are just 5 types of indexes: I created a connect item at...

    July 23, 2010 at 5:07 am

    #1197430

  • RE: top 5th to 10 th record of a table

    You've been asked to provide some DDL and sample data. Since all we have is a generic problem, here is a generic solution.

    ;WITH CTE AS

    (

    SELECT *,

    ...

    July 23, 2010 at 4:57 am

    #1197425

  • RE: Reading Deadlock Trace

    Kwisatz78 (7/21/2010)

    Oh wow I was just looking at some of your code on another post 🙂 it makes it much easier to read thanks.

    I do have some niggly questions...

    July 22, 2010 at 7:20 pm

    #1197295

  • RE: Reading Deadlock Trace

    doobya (7/21/2010)

    wayne: that is very handy bit of sql

    :blush: Thanks. It's been very handy for me also.

    it is impossible / unreasonable and unnecessary to stop all deadlocks

    It depends on what...

    July 22, 2010 at 6:30 pm

    #1197292

  • RE: Deadlock graph help

    Take the deadlock graph xml, and put it into the variable in this code below, and run. It will show you lots of information about the deadlock.

    declare @deadlock xml

    set @deadlock...

    July 22, 2010 at 6:26 pm

    #1197291

  • RE: Sum Daily Data Into Weekly Data

    First, thank you for posting the table DDL and expected output.

    Second, it would really help if you were to actually post insert statements for your data. Please read the article...

    July 22, 2010 at 6:21 pm

    #1197288

  • RE: Any Service Pack released for SQL Server 2008 R2?

    It just shipped like what, 2 months ago? It's a wee bit premature to be looking for one anytime soon.

    I believe that it typically takes 9 mos or longer...

    July 22, 2010 at 5:58 pm

    #1197280

  • RE: Are the posted questions getting worse?

    WayneS (7/22/2010)

    Grant Fritchey (7/22/2010)

    WayneS (7/22/2010)

    How does one go about creating a connect item? I think I've got about a dozen to submit on indexes.....

    It's not hard. Go to connect.microsoft.com and...

    July 22, 2010 at 5:44 pm

    #1197278

  • RE: Index Types

    For everyone that thinks that the BOL reference in the QotD is wrong and that there are just 5 types of indexes: I created a connect item at https://connect.microsoft.com/SQLServer/feedback/details/577460/documentation-types-of-indexes to...

    July 22, 2010 at 5:13 pm

    #1197270

  • RE: Are the posted questions getting worse?

    Grant Fritchey (7/22/2010)

    WayneS (7/22/2010)

    How does one go about creating a connect item? I think I've got about a dozen to submit on indexes.....

    It's not hard. Go to connect.microsoft.com and follow...

    July 22, 2010 at 1:50 pm

    #1197160

  • RE: Are the posted questions getting worse?

    GilaMonster (7/22/2010)

    WayneS (7/22/2010)

    Two questions about this list:

    1. Isn't HEAP a characteristic of the table, meaning that the table has no index?

    2. Where is full-text index?

    As mentioned to Paul, HEAP is...

    July 22, 2010 at 12:19 pm

    #1197083

  • RE: Are the posted questions getting worse?

    GilaMonster (7/22/2010)

    Paul White NZ (7/22/2010)

    A primary XML index is clearly different from a clustered index...right?

    Yes it is, because it can only be defined on an XML column, because it doesn't...

    July 22, 2010 at 12:17 pm

    #1197079

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (7/22/2010)

    I tend to agree with you, Gail, but a reference is a reference for purposes of discussion.

    I do think this is a thorny issue. Would welcome...

    July 22, 2010 at 12:02 pm

    #1197060

Viewing 15 posts - 3,751 through 3,765 (of 5,590 total)