Forum Replies Created

Viewing 15 posts - 18,991 through 19,005 (of 49,552 total)

  • RE: Data is only saving in temp db not in .mdf files -- sql server 2000

    msmartsairam (4/16/2012)

    Then on-wards data is not storing in .mdf files (On drive it is showing last files attached date - its not showing recent data when last data is modified)...

    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

    April 18, 2012 at 12:47 pm

    #1475599

  • RE: multiple drives for database files and log files

    Yes, it is possible for that to give performance gains, it's not an automatic thing though.

    Do move the log files onto another drive. It's good for DB availability and recoverability...

    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

    April 18, 2012 at 12:42 pm

    #1475594

  • RE: Want to create a Log Shipping

    Lynn Pettis (4/18/2012)

    Also, mirroring would require both instances be the same version of SQL Server as well.

    No it doesn't.

    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

    April 18, 2012 at 12:41 pm

    #1475593

  • RE: Want to create a Log Shipping

    Database mirroring is a DR technology that can also be used for reporting. Again, it's great if the primary requirement is DR and reporting is secondary.

    As I said earlier, if...

    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

    April 18, 2012 at 11:35 am

    #1475545

  • RE: Want to create a Log Shipping

    If you insist on using log shipping, they have to be the same version. Again though, log shipping is not the best solution if all you want is a reporting...

    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

    April 18, 2012 at 11:12 am

    #1475524

  • RE: Non-user created temporary tables in Tempdb are in the thousands

    Not work tables.

    Table variables or the cached shells of temp tables.

    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

    April 18, 2012 at 10:47 am

    #1475494

  • RE: Want to create a Log Shipping

    Well, firstly log shipping is not the best solution for a purely reporting secondary. IMHO replication would be better. Log shipping it primarily a DR solution that can be used...

    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

    April 18, 2012 at 10:45 am

    #1475491

  • RE: multiple drives for database files and log files

    ???

    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

    April 18, 2012 at 10:31 am

    #1475478

  • RE: Want to create a Log Shipping

    Then you'll have to restore WITH NORECOVERY leaving the database unavailable.

    There is little point in log shipping between versions unless done as an upgrade mechanism. You can't make the secondary...

    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

    April 18, 2012 at 9:33 am

    #1475422

  • RE: if------then ----else in select statement

    hbtkp (4/18/2012)

    inline table valued function can call sp?thats my question

    Please don't hijack other people's threads.

    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

    April 18, 2012 at 9:11 am

    #1475400

  • RE: Getting example database setup - password problem

    DataAnalyst110 (4/18/2012)

    /****** Object: Login GalacticReporting Script Date: 5/23/2004 11:18:21 AM ******/

    if not exists (select * from master.dbo.syslogins where loginname = N'GalacticReporting')

    BEGIN

    declare @logindb nvarchar(132), @loginlang nvarchar(132) select...

    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

    April 18, 2012 at 8:30 am

    #1475369

  • RE: Joins

    Andy Hyslop (4/18/2012)

    To the OP here is the link Gail was referring to:

    http://sqlinthewild.co.za/index.php/2007/12/30/execution-plan-operations-joins/

    Yes, indeed. Thank you. Also read Craig Freedman's post that it links to.

    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

    April 18, 2012 at 6:46 am

    #1475308

  • RE: Want to create a Log Shipping

    Drop the database and restore it again, specifying WITH STANDBY. Or better, since it's log shipping, use the log shipping dialog to set it up the first time.

    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

    April 18, 2012 at 6:43 am

    #1475302

  • RE: SQL 2012 BI MCSA - 70-461, 70-462, & 70-463

    Ells (4/18/2012)

    I think that while this is a good idea to wrap some DBA stuff into the Cert this is where a few of us will come unstuck. Thats...

    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

    April 18, 2012 at 6:42 am

    #1475301

  • RE: Joins

    ravi@sql (4/18/2012)

    Merger Join -- if the both left and right tables are sorted then merge join will take place.

    Nested loop-- If the left side table having less number of rows...

    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

    April 18, 2012 at 4:54 am

    #1475253

Viewing 15 posts - 18,991 through 19,005 (of 49,552 total)