Forum Replies Created

Viewing 15 posts - 31,156 through 31,170 (of 49,552 total)

  • RE: MYSQL Deadlock

    This is a SQL Server forum, not a MySQL forum. I'd bet that most people here have minimal experience with MySQL. I suggest that you try asking this on a...

    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

    August 20, 2010 at 1:51 am

    #1209497

  • RE: Transaction log size with moving large amounts of data

    Just stick a Ckeckpoint in between the iterations. No need to put a delay.

    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

    August 19, 2010 at 3:58 pm

    #1209409

  • RE: /3GB Switch Question

    32 bit or 64 bit? (windows and SQL)?

    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

    August 19, 2010 at 2:55 pm

    #1209377

  • RE: Database Restore from .bak file

    srathna77 (8/19/2010)

    Thanks SSC.

    Who?

    Can you give me the full query.

    That is the full query.

    Do note that you don't need to create a database before doing a restore. A restore creates...

    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

    August 19, 2010 at 11:28 am

    #1209276

  • RE: Database Shrinking

    More correct to say shrink should only be used if there has been unexpected growth of data or log (or a massive archiving operation) to get things back to normal...

    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

    August 19, 2010 at 11:27 am

    #1209272

  • RE: Trace files

    SQL 2000 does not have a default trace.

    If trace files are been created it's because either C2 auditing is enabled or there's a custom trace running. First thing you...

    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

    August 19, 2010 at 10:31 am

    #1209240

  • RE: How can CREATE INDEX be made more effecient

    YSLGuru (8/19/2010)

    Sadly there's no way I know of to focre SQL to use that Index (since the CREATE INDEX statement is coming from the tool that I can't edit)

    You...

    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

    August 19, 2010 at 10:28 am

    #1209238

  • RE: How can CREATE INDEX be made more effecient

    YSLGuru (8/19/2010)

    I take it you don't believe that an existing index with teh same structure but by a different name would help speed up the create index statement?

    It quite likely...

    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

    August 19, 2010 at 9:26 am

    #1209209

  • RE: How can CREATE INDEX be made more effecient

    YSLGuru (8/19/2010)

    Also know that this Purge tool we have been sent by the Vendor is not a step by step process so once it starts I have no way 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

    August 19, 2010 at 9:05 am

    #1209192

  • RE: Are the posted questions getting worse?

    Trey Staker (8/19/2010)

    What are peoples thoughts on the remaining 5 candidates? The only one I really know anything about is Andy Warren.

    I know Geoff fairly well. He's an awesome...

    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

    August 19, 2010 at 8:58 am

    #1209184

  • RE: Restore SQL 2005 Enterprise backup to SQL Express 2005

    MostInterestingMan (8/19/2010)

    Excellent!!! Thanks for the information, Gail.

    Emphasis 'should'. I don't have an express instance around to try it out on.

    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

    August 19, 2010 at 8:19 am

    #1209144

  • RE: Restore SQL 2005 Enterprise backup to SQL Express 2005

    It should be, providing the database doesn't use any features not supported in Standard and is no larger than the DB size limit on Express (4GB)

    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

    August 19, 2010 at 8:05 am

    #1209132

  • RE: Database Disaster Recovery

    No.

    Recovering or restoring? What's the context?

    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

    August 19, 2010 at 7:54 am

    #1209117

  • RE: Strange count results with uncommitted isolation level

    If accurate results are important, don't use readuncommitted

    See - http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.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

    August 19, 2010 at 7:53 am

    #1209116

  • RE: Insert spaces into a decimal field

    Add a derived column transform in SSIS where you remove the spaces from the data. I think there's a replace function in there. Either replace ' ' with '' or...

    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

    August 19, 2010 at 7:50 am

    #1209111

Viewing 15 posts - 31,156 through 31,170 (of 49,552 total)