Forum Replies Created

Viewing 15 posts - 181 through 195 (of 789 total)

  • RE: Identity column limitation

    Ok, let me say that I'm wrong and let consider the small databases!

    😎

    I said before that large and medium DBs have tables that the Identity Col has generated value...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 12, 2010 at 7:24 am

    #1102408

  • RE: SQL SERVER clustering

    brainy (1/12/2010)

    on same lines can you tell me which operating system we can use...?

    The best is the OS with all features like Windows Server 2008 R2 Enterprise or Datacenter editions.

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 12, 2010 at 7:11 am

    #1102399

  • RE: Only Configuration Manager Installs

    S Hodkinson (1/12/2010)

    Correction it was the standard edition.

    What are the issues with the virtual machine that it could be?

    I said issue, because, it depends also what you installed in your...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 12, 2010 at 6:53 am

    #1102370

  • RE: SQL SERVER clustering

    Yes, it can be done with Virtual Machine installed in your only server...!

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 12, 2010 at 6:31 am

    #1102352

  • RE: Only Configuration Manager Installs

    Maybe any issue with your virtual machine, but I don't believe so!

    Which SQL Server edition you installed in VMachine!?

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 12, 2010 at 6:22 am

    #1102349

  • RE: Identity column limitation

    I said, because meant if you start form 1 till 2 000 000 000 will take long time (maybe 1 year on large companies like banks and telephony), I think....

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 12, 2010 at 5:51 am

    #1102335

  • RE: Identity column limitation

    ...also GilaMonster has great experience with SQL Server (she's MVP also) and I think that she wrote enough info for what you ask!

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 12, 2010 at 5:19 am

    #1102321

  • RE: Identity column limitation

    Vivek29 (1/12/2010)

    After 2 billion insertions or max of the datatype limit the identity column has reached what will happen and how to tackle that?

    Did you reach a 2 billion records...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 12, 2010 at 5:15 am

    #1102319

  • RE: space issue

    Do you have rights in backup folder!?

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 12, 2010 at 2:14 am

    #1102235

  • RE: 70-432 vs 70-450

    The Order is MCTS then MCITP, I think that you should go first with MCTS, and after that with MCITP!

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 11, 2010 at 12:01 pm

    #1101974

  • RE: Auto Start

    sudhakara (1/10/2010)

    Are you getting error messages while starting the sql server services manually ?

    As he mentioned above NO, he can starts services manually without any error msgs!

    But reasons that...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 10, 2010 at 10:44 am

    #1101525

  • RE: Auto Start

    What is your error in event viewer!? Did you check it!?

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 10, 2010 at 9:39 am

    #1101519

  • RE: Auto Start

    Did you change your password!

    If you changed your password, you should go to configure manually to start services with new password!

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 10, 2010 at 9:04 am

    #1101513

  • RE: selecting TOP row from a result set

    I think one of the solution is to use Row_number() function but for more precise result, please post table structure and some sample data as GilaMonster said!

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 10, 2010 at 2:46 am

    #1101476

  • RE: how to restore DB with only MDF

    Try this locations for your case...

    http://www.sqlservercentral.com/Forums/Topic646802-146-1.aspx

    or

    http://social.msdn.microsoft.com/Forums/en/sqldisasterrecovery/thread/189be01f-23de-48b0-96cc-8f1292c13c54

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    January 9, 2010 at 9:41 am

    #1101397

Viewing 15 posts - 181 through 195 (of 789 total)