Forum Replies Created

Viewing 15 posts - 29,026 through 29,040 (of 49,552 total)

  • RE: Database Engine!

    subha.mcts2005 (12/6/2010)

    sql server Engine how to identify the databases ?

    iam asking sql engine will consider any sid ?

    Why is this important to you? What's the reasoning behind this question?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 6, 2010 at 9:25 am

    #1259095

  • RE: Database Engine!

    Steve Jones - SSC Editor (12/6/2010)

    The system databases are:

    master, model, msdb, tempdb, ReportServer, ReportServerDB

    You can identify them with an IN clause

    ...WHERE name not in ('master', 'model', 'msdb', 'tempdb', 'ReportServer', 'ReportServerDB')

    As...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 6, 2010 at 9:24 am

    #1259094

  • RE: SQL Server 2005 - Database Mirroring (Change of Recovery Model)

    Steve Jones - SSC Editor (12/6/2010)

    Mirroring doesn't affect the log, with the exception that the log is needed to send the data to the mirror database.

    unless mirroring gets suspended, then...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 6, 2010 at 9:23 am

    #1259092

  • RE: SQL Server 2005 - Database Mirroring (Change of Recovery Model)

    river1 (12/6/2010)

    1) I will put some apps that i have, in mirror, but this apps use Bulk operations to import data at the end of the day. In mirror,...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 6, 2010 at 7:27 am

    #1259011

  • RE: Database Engine!

    Not sure what you're asking. Please clarify.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 6, 2010 at 7:24 am

    #1259008

  • RE: Are the posted questions getting worse?

    Grant Fritchey (12/6/2010)

    Jeff Moden (12/5/2010)

    Heh... I found a way around all of the "problems" with WordPress... I write articles on SQL Server instead of blogging. 😛

    You may be on the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 6, 2010 at 6:07 am

    #1258965

  • RE: Database mirroring?

    Huh? Are you referring to compatibility mode?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 6, 2010 at 3:09 am

    #1258933

  • RE: help me code for trigger:

    Please post table definitions, sample data and expected results as per http://www.sqlservercentral.com/articles/Best+Practices/61537/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 6, 2010 at 2:39 am

    #1258927

  • RE: Duplicate data inserted while click refreh in asp.net

    You might get better answers if you ask this in an asp.net forum. Maybe one of the microsoft forums? (http://social.msdn.microsoft.com/Forums/en-US/category/netdevelopment)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 6, 2010 at 2:21 am

    #1258923

  • RE: Database Mirroring.

    subha.mcts2005 (12/6/2010)

    1.plz help me how to start the mirroring ?

    2.basically what are the steps i have to follow?

    Have you tried a search engine? There's lots of resources available on mirroring,...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 6, 2010 at 2:11 am

    #1258920

  • RE: Reduce Physical size of Transaction Log

    Great, now make sure you have log backups scheduled regularly, or you'll be right back in the same scenario in a few weeks.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 5, 2010 at 11:36 pm

    #1258895

  • RE: Restoring database using .mdf and .ldf files

    Malcolm Daughtree (12/5/2010)

    having a backup of Master is like having a key to the house but the movers have already been and gone. Master only holds the configuration of...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 5, 2010 at 11:35 pm

    #1258894

  • RE: Restoring database using .mdf and .ldf files

    sraned (12/5/2010)

    I have the copy of the master database from date in question. But the custom program was made on test database and there was no back up of test...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 5, 2010 at 11:25 pm

    #1258891

  • RE: whether it will boost performance of SQL server? Would be it Good Design?

    Will see if I can dig up an example. Will need to be a query with hardcoded values and one that's not so simple it gets auto-parameterised.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 5, 2010 at 6:12 pm

    #1258867

  • RE: Are the posted questions getting worse?

    Don't go for tonnes of plugins. Get ones you really need (like syntax highlighting), add more as the requirements arrive.

    I've only got 7 plugins in total.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 5, 2010 at 6:11 pm

    #1258866

Viewing 15 posts - 29,026 through 29,040 (of 49,552 total)