Forum Replies Created

Viewing 15 posts - 31 through 45 (of 320 total)

  • RE: Combining union and union all

    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!

    March 8, 2012 at 4:26 am

    #1456442

  • RE: Log record ID corruption

    are they running administrative commands on server? (for example: DBCC) or the access only by website without admin commands?

    [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!

    March 7, 2012 at 4:45 am

    #1455883

  • RE: Log record ID corruption

    Benki Chendu (3/7/2012)

    ...... state_desc is showing as online only..

    is database working fine?

    did you lost any data???

    [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!

    March 7, 2012 at 4:20 am

    #1455866

  • RE: Log record ID corruption

    sorry, is state_desc!!!

    select name, state_desc

    from sys.databases

    where name = 'maximum'

    [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!

    March 7, 2012 at 3:53 am

    #1455851

  • RE: Log record ID corruption

    execute the follow t-sql:

    select name, state_desc from sys.databases

    where name = 'maximum'

    [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!

    March 7, 2012 at 3:24 am

    #1455837

  • RE: Full Recovery Model

    Stewart "Arturius" Campbell (3/7/2012)

    Nice, simple back-to-basics question, thanks, Peter

    For the explanation, refer to Working with Transaction Log Backups, specifically the third paragraph

    +1

    😎

    [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!

    March 7, 2012 at 3:08 am

    #1455828

  • RE: Suggestions for inserting 420 million rows into a table?

    detail your doubt!!!! 😀

    [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!

    March 5, 2012 at 12:39 pm

    #1454960

  • RE: BETWEEN

    bitbucket-25253 (3/3/2012)

    Nice question - gets one back to the basics....

    😎

    +1

    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!

    March 5, 2012 at 3:58 am

    #1454712

  • RE: Not In

    very 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!

    March 5, 2012 at 3:55 am

    #1454711

  • RE: Arithmetic 1

    good question!!!

    thanks Ron!!!

    [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 29, 2012 at 4:28 am

    #1453047

  • RE: SQL Server Agent Roles

    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 28, 2012 at 5:04 am

    #1452513

  • RE: Table Value Constructor 1

    nice question !!!

    thanks Ron!!

    [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 27, 2012 at 4:09 am

    #1451971

  • RE: Are you using heartbeat in SQL 2008 R2 clusters

    Prakash Heda (2/20/2012)

    Very interesting, all votes for using heartbeat....

    I have configured without hearbeat as new quoram model support with no issue...

    I've not configured without heartbeat, I had no time!!!, but...

    [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 24, 2012 at 3:28 am

    #1451283

  • RE: Service Service Accounts

    Kameswari Aravindh (2/23/2012)

    The Option specified is wrong it is not Sys.dm_service_services but it is Sys.dm_server_services.....

    +1

    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 24, 2012 at 3:10 am

    #1451274

  • RE: Object_Id 1

    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 23, 2012 at 7:23 am

    #1450846

Viewing 15 posts - 31 through 45 (of 320 total)