Forum Replies Created

Viewing 15 posts - 16,501 through 16,515 (of 49,552 total)

  • RE: What are the best options to secure backups without using third part tools ?

    Upgrade to SQL 2008 and use TDE on the database (Enterprise edition only). Otherwise 3rd party tool of some form (backup tool, password protected archiver, etc)

    The password on SQL backups...

    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

    September 24, 2012 at 4:04 am

    #1541322

  • RE: Changing Locations of DataFile

    It might. It might not. Depends on the current bottlenecks, the drive architecture and a whole lot of other factors.

    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

    September 24, 2012 at 4:00 am

    #1541321

  • RE: How to filter condition by column?

    Jeff Moden (9/23/2012)

    GilaMonster (9/22/2012)

    You *can* use dynamic SQL. Whether it's a good idea to do so is another matter...

    Do you have an alternative?

    Yes.

    I'm waiting for the OP to 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

    September 23, 2012 at 2:03 pm

    #1541234

  • RE: rebuild index

    Nope. REstored DB will be identical to the DB that was backed up

    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

    September 23, 2012 at 12:47 pm

    #1541220

  • RE: rebuild index

    sqlfriends (9/23/2012)

    Also for above statement, do you mean when first time import data to a new table, the index is not fragmented, and the statistics is up to date?

    The index...

    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

    September 23, 2012 at 12:23 pm

    #1541210

  • RE: An Indexing Discussion

    opc.three (9/23/2012)

    In a heap, when an existing row is updated and that row no longer fits on the page where it lives a forwarding record is created to hold that...

    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

    September 23, 2012 at 12:18 pm

    #1541207

  • RE: Unexpected Result of Select Statement: Shubham Saxena

    Hmmm... deja vu

    http://www.sqlservercentral.com/Forums/FindPost1362083.aspx

    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

    September 23, 2012 at 8:16 am

    #1541171

  • RE: Is there any way to cancel redo logs in mirror server ?

    Should be.

    Forcing a failover won't help, because this is not the failover process, it's the bringing of the DB online after the failover.

    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

    September 23, 2012 at 3:49 am

    #1541153

  • RE: Is there any way to cancel redo logs in mirror server ?

    No, it's the same as crash recovery when starting up a DB. Without there are logged changes that do not reflect in the data file, ie the database would be...

    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

    September 22, 2012 at 2:04 pm

    #1541121

  • RE: SQL Server Best Practices

    Recurs1on (9/22/2012)

    Do you think it's worth trying to re-write this or just handle it by more vigilant reviews by senior staff.

    I'd say drop it and require that table designs be...

    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

    September 22, 2012 at 1:20 pm

    #1541118

  • RE: SQL Server Best Practices

    Recurs1on (9/22/2012)

    The original intent was to avoid unnecessary table scans because of poorly written queries that use NOT EXISTS, NOT IN or != in cases where it is possible...

    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

    September 22, 2012 at 12:08 pm

    #1541106

  • RE: How to filter condition by column?

    You *can* use dynamic SQL. Whether it's a good idea to do so is another matter...

    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

    September 22, 2012 at 11:03 am

    #1541099

  • RE: SQL Server Best Practices

    Recurs1on (9/22/2012)

    The reason this item was here originally was because unless I'm mistaken, negative logic forces a table scan. Am I wrong on that one?

    Yes.

    'Negative' logic can mean a table...

    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

    September 22, 2012 at 10:59 am

    #1541098

  • RE: SQL DB Administration

    Please read through this - Managing Transaction Logs[/url]

    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

    September 22, 2012 at 10:09 am

    #1541086

  • RE: rebuild index

    The problem was unlikely to be due to a fragmented index, while fragmentation can slow queries, it's not usually that much. Most likely what fixed the problem was the statistics...

    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

    September 22, 2012 at 3:54 am

    #1541058

Viewing 15 posts - 16,501 through 16,515 (of 49,552 total)