Forum Replies Created

Viewing 15 posts - 331 through 345 (of 516 total)

  • RE: Data Archival

    Hi Lynn

    Very rightly pointed out that my table is actually a heap, without clustered index (I should have been more specific earlier). Just to add on, the transaction table does...

    September 20, 2012 at 9:53 pm

    #1540457

  • RE: Tracking Processes

    Thanks Naseer...a very easy question to conclude this week 🙂

    September 20, 2012 at 9:45 pm

    #1540455

  • RE: Data Archival

    Lynn Pettis (9/19/2012)

    First, INSERT INTO will be fully logged, not minimally logged (iirc).

    Hi Lynn

    I am using table locking option TABLOCK, this support minimal logging.

    September 20, 2012 at 6:26 am

    #1540024

  • RE: Resource Governor

    Cool...good question Naseer. Thanks for posting.

    September 19, 2012 at 9:54 pm

    #1539877

  • RE: FILTER

    Sean Lange (9/18/2012)

    Nice back to basics question. I am astounded that at the time of my posting there are 111 (14%) that answered this wrong. I can understand those that...

    September 18, 2012 at 10:51 pm

    #1539381

  • RE: FILTER

    Stewart "Arturius" Campbell (9/18/2012)

    Good question, thanks

    However, I must agree with Hugo regarding the explanation, espacially with regard to SET.

    Hey Stewart/Hugo

    Taken your words. Will be more specific with the explanation hereon.

    Thanks...

    September 18, 2012 at 10:47 pm

    #1539380

  • RE: Tablesample

    Got into the trap...thought query may return 1 or 2....overlooked the primary key factor :w00t:

    A good question though. Thanks for posting.

    September 18, 2012 at 9:51 pm

    #1539376

  • RE: FILTER

    Raghavendra Mudugal (9/17/2012)

    Thanks for the question Lokesh-ji, (so simple and yet so much to consider). )

    Glad to know that Raghu..sometimes we are so engrossed in the perplexities of complex issues...

    September 17, 2012 at 11:51 pm

    #1538902

  • RE: New Line Character

    Skanda (9/17/2012)

    what is the new line character, to display the below query.

    Please be clear and specific. If you are new to this forum, its worth looking at best practices to...

    September 17, 2012 at 6:05 am

    #1538544

  • RE: Backups

    demonfox (9/17/2012)

    forgot Cell phone !! That is more of amber than blue ;D

    btw, the link you provided were really informative.

    Thanks for that...

    You are welcome Avi:-)

    September 17, 2012 at 5:58 am

    #1538540

  • RE: Backups

    Thanks for the feedback & for providing the informative link Lokesh.

    You are welcome Divine 🙂

    September 17, 2012 at 5:57 am

    #1538538

  • RE: Backups

    demonfox (9/16/2012)

    nice question ... I got it wrong anyways.. was suppose to mark the another answer 🙁

    I need coffee

    Me too got this question wrong...

    Took a wrong turn on...

    September 17, 2012 at 12:00 am

    #1538402

  • RE: Backups

    Wonderful question Divine. I would recommend taking a look at the following link as well:

    http://msdn.microsoft.com/en-us/library/ms178062.aspx

    It talks about Media Sets, Media Families, and Backup Sets in SQL Server.

    September 16, 2012 at 11:32 pm

    #1538399

  • RE: DBA Basics

    Raghavendra Mudugal (9/14/2012)

    demonfox (9/13/2012)

    Lokesh Vij (9/13/2012)

    An easy one for Friday!

    I love using Rollback [after specified time].....to warn developers to log-off from the database otherwise they will automatically be logged-off...

    September 14, 2012 at 5:42 am

    #1537747

  • RE: DBA Basics

    An easy one for Friday!

    I love using Rollback [after specified time].....to warn developers to log-off from the database otherwise they will automatically be logged-off after specified time 🙂

    Thanks for...

    September 13, 2012 at 9:55 pm

    #1537613

Viewing 15 posts - 331 through 345 (of 516 total)