Forum Replies Created

Viewing 15 posts - 61 through 75 (of 320 total)

  • RE: TRUNCATE TABLE and ROLLBACK TRAN

    GilaMonster (2/6/2012)

    Given the distribution of answers, I'm considering a followup question - "does recovery model ever affect the ability to rollback transactions?" because it appears way too many people don't...

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

    February 6, 2012 at 5:25 am

    #1443033

  • RE: TRUNCATE TABLE and ROLLBACK TRAN

    great question!!!

    Thanks!

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

    February 6, 2012 at 5:24 am

    #1443032

  • RE: INSERT OUTPUT

    good question!!!!

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

    February 3, 2012 at 3:33 pm

    #1442679

  • RE: SET option hierarchy

    well, I think that 4# answer should be removed of question!!! it's wrong!!!

    good question!!!

    thanks!!!

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

    February 1, 2012 at 7:04 am

    #1441198

  • RE: Initialize Subscriptions

    nice!!!!

    thanks!!!

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

    January 30, 2012 at 10:03 am

    #1440115

  • RE: Strings and Defaults

    good question!!!

    thanks Gail!!!!

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

    January 26, 2012 at 3:28 am

    #1438647

  • RE: Concurrent Administration

    good question!!!

    thanks!!!

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

    January 25, 2012 at 3:18 am

    #1438151

  • RE: Hashing

    This issue is so obvious that i was confused!!!

    Good question!

    thanks Steve!!!!

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

    January 24, 2012 at 3:27 am

    #1437559

  • RE: Better Backups

    Good question Steve, but answer its wrong!!!

    A and D it's correct!!!!

    the resource governor doesn't limit I/O, but limits CPU and Memory utilization!!!

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

    January 23, 2012 at 4:03 am

    #1437007

  • RE: billy-yons and billy-yons of rows

    easy question!!!

    Thanks Steve!

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

    January 20, 2012 at 3:11 am

    #1436339

  • RE: Understanding and Using APPLY (Part 2)

    Very good article Paul.

    the explanation is very good and easy understanding.

    Thanks!

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

    January 16, 2012 at 7:14 am

    #1434062

  • RE: Checking database access

    Good question!!!

    Thanks Steve!!!!!

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

    January 12, 2012 at 5:32 am

    #1432382

  • RE: A New SMK

    very good question!!!

    I learned more thing!!!!!!

    thanks Steve!!!

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

    January 6, 2012 at 5:36 am

    #1429566

  • RE: Reindexing and fragmentation

    how many time to execute the select command in table?

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

    January 5, 2012 at 1:55 pm

    #1429351

  • RE: Reindexing and fragmentation

    Guras (1/5/2012)

    total number of rows - 361

    I don't know how to find the kb.

    361 rows???

    the size is in property of table - storage!!!

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

    January 5, 2012 at 11:08 am

    #1429224

Viewing 15 posts - 61 through 75 (of 320 total)