Forum Replies Created

Viewing 15 posts - 3,076 through 3,090 (of 3,348 total)

  • RE: Indexes

    Sorry Steve, but I have to disagree with you on this one.

    Indexed views are not an index type. They are a special type of view, created by creating an index...

    December 19, 2008 at 12:59 am

    #915024

  • RE: Backup and Recovery

    michael vessey (12/12/2008)

    Either we're allowed to assume that ALL steps succeed or that Any step could fail....

    therefore If all steps succeeded then the answer is YES (because you must have...

    December 12, 2008 at 5:10 am

    #911568

  • RE: Backup and Recovery

    Lee Nadelman (12/11/2008)

    If we presume the log backup is there, that would mean a full backup had to be made. Therefore if an full backup was made, recovery at...

    December 11, 2008 at 12:37 pm

    #911287

  • RE: Backup and Recovery

    Michael Kipp (12/11/2008)

    the reason why I think there was a full backup is that the questions says: "can I recover to the point in time between the inserts using the...

    December 11, 2008 at 3:09 am

    #910912

  • RE: Backup and Recovery

    Arshad Ali (12/11/2008)

    It is not possible to make a transaction log backup without having a full backup first. So if the transaction log backup available, it implies that a full...

    December 11, 2008 at 3:01 am

    #910908

  • RE: Backup and Recovery

    Michael Kipp (12/11/2008)

    Clearly the actions and outcome of them were not explicitely described, otherwise it would have mentioned that the log backup failed. If the answers were more like you...

    December 11, 2008 at 2:49 am

    #910901

  • RE: Backup and Recovery

    The explanation is misleading. Especially this part:

    you cannot use the log backup to recover the database

    since it implies that you can MAKE a log backup after creating a new database...

    December 11, 2008 at 2:01 am

    #910884

  • RE: Calculate the Running Total for the last five Transactions

    Jeff Moden (11/27/2008)

    Lynn Pettis (11/27/2008)

    Okay, can't wait to see Jeff's response. I was using a technique I picked up from him for completing running totals.

    Hugo is putting out a...

    November 28, 2008 at 2:47 am

    #904635

  • RE: Calculate the Running Total for the last five Transactions

    Lynn Pettis (11/27/2008)

    Yep, the code you wrote works about the way you say it will, but I figured out the problem in your code in the second block. First,...

    November 28, 2008 at 2:19 am

    #904629

  • RE: Calculate the Running Total for the last five Transactions

    Jacob Luebbers (11/27/2008)

    Hey Hugo,

    Hugo Kornelis (11/27/2008)

    Point taken. Though the flipside is that TABLOCK increases the chance to get an unordered scan instead of an ordered one. More on that below.

    Maybe...

    November 28, 2008 at 2:09 am

    #904625

  • RE: Calculate the Running Total for the last five Transactions

    Jacob Luebbers (11/27/2008)

    Hey Hugo,

    Hugo Kornelis (11/27/2008)

    ...

    * The optimizer might choose a non-clustered index to drive the query

    ...

    The technique also uses an index hint specifying the clustered index, with TABLOCKX to...

    November 27, 2008 at 5:12 pm

    #904512

  • RE: Calculate the Running Total for the last five Transactions

    Jacob Luebbers (11/27/2008)

    Hey Hugo,

    I think the consensus for those that have taken up the "Jeff-style" quirky update method is to use the MAXDOP=1 option on the UPDATE...

    November 27, 2008 at 4:02 pm

    #904502

  • RE: Calculate the Running Total for the last five Transactions

    Lynn Pettis (11/27/2008)

    Actually, the author was using it in his code (which I included in my post for comparision purposes), I was using it in my code exclusively to provide...

    November 27, 2008 at 2:40 pm

    #904488

  • RE: Calculate the Running Total for the last five Transactions

    Jeff Moden (11/27/2008)

    Hugo Kornelis (11/27/2008)

    What I was refering too is the lack of ROW_NUMBER() in SQL Server 2000. This means you'll either have to take your chance with IDENTITY, at...

    November 27, 2008 at 1:58 pm

    #904482

  • RE: Calculate the Running Total for the last five Transactions

    Lynn Pettis (11/27/2008)

    Since the purpose of the identity field was order, if there was a gap it wouldn't have caused an issue.

    Hi Lynn,

    But you are using the IDENTITY values for...

    November 27, 2008 at 1:51 pm

    #904479

Viewing 15 posts - 3,076 through 3,090 (of 3,348 total)