Forum Replies Created

Viewing 15 posts - 91 through 105 (of 789 total)

  • RE: How to Connect to & Manage ?

    Are you trying to connect with SSMS to that instance !?

    Seems that your instance name is incorrect!!!

    In Express Edition you should connect like this:

    ServerName\InstanceName

    or

    YourComputerName\InstanceName

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

    April 30, 2010 at 9:31 am

    #1160526

  • RE: SSC Databases

    CirquedeSQLeil (4/30/2010)

    Dugi (4/30/2010)

    Henrico Bekker (4/29/2010)

    Nice to know! one more question: is your sa account enabled and what is the password? 😛

    It is not documented by Steve, so I guess he...

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

    April 30, 2010 at 12:39 am

    #1160229

  • RE: SSC Databases

    Henrico Bekker (4/29/2010)

    Nice to know! one more question: is your sa account enabled and what is the password? 😛

    It is not documented by Steve, so I guess he doesn't have...

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

    April 30, 2010 at 12:33 am

    #1160223

  • RE: Backup and restore solution for 800TB of data

    GilaMonster (4/29/2010)

    Lowell (4/29/2010)

    Steve can you put out some numbers for perspective? SSC has a lot of users and traffic, compared to many of us small biz guys we usually deal...

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

    April 29, 2010 at 4:19 pm

    #1160095

  • RE: SSC Databases

    Thanks for the Info!

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

    April 29, 2010 at 2:21 pm

    #1160056

  • RE: Backup and restore solution for 800TB of data

    WayneS (4/29/2010)

    D.Oc (4/29/2010)

    My bet is on GB's not TB.

    Especially singe "G" is right under "T" on the keyboard...

    I think we choose the situation, now what any solution scenario for this...

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

    April 29, 2010 at 9:15 am

    #1159792

  • RE: Backup and restore solution for 800TB of data

    GregoryF (4/29/2010)

    Are you really sure it's 800TB and not 800GB?

    SQL 2008 only support 512TB Databases

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

    So does SQL 2005

    http://msdn.microsoft.com/en-us/library/ms143432(SQL.90).aspx

    No SQL Server supports over 512 TB, take a look more closely, the...

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

    April 29, 2010 at 7:52 am

    #1159699

  • RE: Backup and restore solution for 800TB of data

    If the situation is true, it would be very interesting about DB architecture info ( data files & log files architecture ) :w00t::hehe::w00t:

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

    April 29, 2010 at 7:47 am

    #1159694

  • RE: Backup and restore solution for 800TB of data

    According to max specifications of SQL Server how it can be log file 100 TB ( max spec. 2TB)! ? !

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

    April 29, 2010 at 7:33 am

    #1159669

  • RE: Issue with SQlServer Agent

    Just curious, did you have latest updates for SQL Server ( SPs and other Comulative Updates)!?

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

    April 28, 2010 at 7:39 am

    #1158912

  • RE: Query 5000 Tables for data

    9000 * 5000 = 45 000 000 records and growing up if they have new customers hahaa you should look for the nice performance with those records in a one...

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

    April 16, 2010 at 4:37 pm

    #1153201

  • RE: Query 5000 Tables for data

    Interesting situation, I can see that for every new customer, the new table will created ...will it continue or it stops at 5000th customer's table, and you just trying to...

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

    April 16, 2010 at 3:27 pm

    #1153178

  • RE: DBA Tools:sp_who3

    Works nice in SQL Server 2008 x64!

    It would be better if you add the IP info!

    Thanks for sharing 😎

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

    April 15, 2010 at 2:26 am

    #1151950

  • RE: Career Advice

    For the beginning check this http://www.sqlservercentral.com/articles/DBA/68526/

    Never say Never, Never is too late...everyday we learn new things....!

    And take a look one quote here

    I wish you success....!

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

    April 4, 2010 at 12:37 am

    #1145418

  • RE: Concatenate result sets

    vaibhav.tiwari (3/30/2010)

    Thanks for the suggestion and got the hint i can do it by row_number function.

    Thanks again

    Let us know how you did!?

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

    March 30, 2010 at 9:02 am

    #1142313

Viewing 15 posts - 91 through 105 (of 789 total)