Forum Replies Created

Viewing 15 posts - 946 through 960 (of 2,647 total)

  • RE: Rename instance name in SQL Server 2008 R2

    RBarryYoung (5/14/2012)

    SQLKnowItAll (5/14/2012)

    RBarryYoung (5/14/2012)

    I always use named instances, because I never know for sure if I may need to add another instance (permanently or temporarily) on the current server.

    Since, as...

    Jared
    CE - Microsoft

    May 14, 2012 at 8:18 pm

    #1487507

  • RE: Rename instance name in SQL Server 2008 R2

    RBarryYoung (5/14/2012)

    I always use named instances, because I never know for sure if I may need to add another instance (permanently or temporarily) on the current server.

    Since, as already noted,...

    Jared
    CE - Microsoft

    May 14, 2012 at 1:17 pm

    #1487353

  • RE: Rename instance name in SQL Server 2008 R2

    ndevr (5/14/2012)

    whats is the best practice for prod server Named Instance or Default instance? Please suggest (Pros and cons)

    Thanks!

    Personally, I find no benefit to having a named instance if you...

    Jared
    CE - Microsoft

    May 14, 2012 at 12:47 pm

    #1487329

  • RE: Rename instance name in SQL Server 2008 R2

    ndevr (5/14/2012)

    @above yes you r right.. Please let me know to rename intance name

    Again, you cannot rename an instance. You can only uninstall/re-install with a new named instance.

    Jared
    CE - Microsoft

    May 14, 2012 at 12:16 pm

    #1487314

  • RE: Rename instance name in SQL Server 2008 R2

    ndevr (5/14/2012)

    I successfully renamed instance with following steps

    First collect the output of the current instance configuration

    1. sp_helpserver

    2. select @@servername

    Execute the below query to change the instance name

    ...

    Jared
    CE - Microsoft

    May 14, 2012 at 12:08 pm

    #1487306

  • RE: Rename instance name in SQL Server 2008 R2

    Geoff A (5/14/2012)

    you do this with sp_dropserver and sp_addserver

    a restart will be required.

    you will also have to handle the Admin login, msdb SQL Agent jobs and linked servers (if any)...

    This...

    Jared
    CE - Microsoft

    May 14, 2012 at 11:57 am

    #1487295

  • RE: Is this true?

    I don't see any updates in the errata for the book on this.

    Let me maybe rephrase the question based on the book:

    Paragraph begins saying: "During the checkpoint process, SQL Server...

    Jared
    CE - Microsoft

    May 14, 2012 at 9:47 am

    #1487211

  • RE: Left Join Killing Me

    chandan_jha18 (5/14/2012)

    drew.allen (5/11/2012)

    I still don't see any sample data. It's hard to rewrite your view if we don't have data to compare the original results with the revised results.

    Also,...

    Jared
    CE - Microsoft

    May 14, 2012 at 7:36 am

    #1487106

  • RE: Left Join Killing Me

    Anoter thing to try while you gather your DDL and execution plan is to move your where condition into the join condition for that table.

    Jared
    CE - Microsoft

    May 10, 2012 at 2:02 pm

    #1485964

  • RE: Maintenance plan tab shows only backup task

    Hmm... I can't seem to see any tasks.

    What are you referring to?

    Jared
    CE - Microsoft

    May 10, 2012 at 1:44 pm

    #1485952

  • RE: Replication - MSubscriptions table have a Status of 3 for Newly Defined Publication and Subscriber

    As stated earlier... What is the problem? If replication is working, don't do anything. And certainly don't go updating tables when you don't know what it will affect, that's just...

    Jared
    CE - Microsoft

    May 10, 2012 at 10:54 am

    #1485849

  • RE: cant create logins in SQL

    There is no default password of 'sa'. You had to set a password.

    Jared
    CE - Microsoft

    May 9, 2012 at 3:24 pm

    #1485376

  • RE: Table-based Functions vs. Views

    Putts (5/9/2012)

    SQLKnowItAll (5/9/2012)

    Putts (5/9/2012)

    SQLKnowItAll (5/9/2012)

    You can use 1 SP built to handle all 3 of those scenarios and then no views, no functions, and you only change 1 SP. 1...

    Jared
    CE - Microsoft

    May 9, 2012 at 2:38 pm

    #1485355

  • RE: Table-based Functions vs. Views

    Putts (5/9/2012)

    SQLKnowItAll (5/9/2012)

    You can use 1 SP built to handle all 3 of those scenarios and then no views, no functions, and you only change 1 SP. 1 SP per...

    Jared
    CE - Microsoft

    May 9, 2012 at 2:17 pm

    #1485348

  • RE: Table-based Functions vs. Views

    GilaMonster (5/9/2012)

    SQLKnowItAll (5/9/2012)

    You can use 1 SP built to handle all 3 of those scenarios and then no views, no functions, and you only change 1 SP. 1 SP per...

    Jared
    CE - Microsoft

    May 9, 2012 at 2:16 pm

    #1485346

Viewing 15 posts - 946 through 960 (of 2,647 total)