Forum Replies Created

Viewing 15 posts - 26,686 through 26,700 (of 49,552 total)

  • RE: Transfer DBs between SQL2K, SQL2K8

    schleep (4/15/2011)

    So I've set TransferAllViews = $False, how do I add that collection to the transfer ObjectList?

    Err, you're asking me? I can barely spell powershel.

    Let me get some assistance here...

    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 15, 2011 at 12:20 pm

    #1312296

  • RE: Transfer DBs between SQL2K, SQL2K8

    On 2000 there were a couple system objects that were system objects but were not marked system. Is there a way in powershell to check the ISMSShipped property? If so,...

    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 15, 2011 at 10:47 am

    #1312264

  • RE: Database Recovery - DB Not Detached - SQL Server 2000

    You should simply be able to attach them. No need for convoluted tricks unless there's damage of some form.

    If they won't simply attach, post the errors.

    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 15, 2011 at 10:43 am

    #1312260

  • RE: Transfer DBs between SQL2K, SQL2K8

    Don't transfer system objects. System objects are for SQL to create only

    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 15, 2011 at 10:41 am

    #1312259

  • RE: SalesForce attachments are extracted as binary files and need to rendered viewable.

    GaMusicMan (4/15/2011)

    I can tell all you quick to judge and condemn peolpe on thing and that is... you need to be a bit morepatient with new people here and...

    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 15, 2011 at 10:39 am

    #1312256

  • RE: Restore Differential with Replace

    No. What's in the Diff is not a complete database, it's just the extents that have changed since the full that the diff is based on.

    I suspect the replace 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

    April 15, 2011 at 9:24 am

    #1312219

  • RE: SalesForce attachments are extracted as binary files and need to rendered viewable.

    Please don't cross post.

    No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1094197-148-1.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

    April 15, 2011 at 9:21 am

    #1312216

  • RE: Salesforce attachments

    No further replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1094197-148-1.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

    April 15, 2011 at 9:20 am

    #1312214

  • RE: Maintenance plan for large databases, how many times?

    Depends. What's in the maintenance plan?

    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 15, 2011 at 7:57 am

    #1312153

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (4/15/2011)

    GilaMonster (4/15/2011)

    Roy Ernest (4/15/2011)

    Since everyone is switching back to their own avatars, Can Gail please be the lizard once again?? Please, Pretty please? 🙂

    Nah, think I'll stick with...

    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 15, 2011 at 7:16 am

    #1312114

  • RE: Tools to get the DML statement count

    Please don't post multiple threads for the same question. It just wastes people's time.

    No more replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1093936-391-1.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

    April 15, 2011 at 7:09 am

    #1312103

  • RE: Are the posted questions getting worse?

    Roy Ernest (4/15/2011)

    Since everyone is switching back to their own avatars, Can Gail please be the lizard once again?? Please, Pretty please? 🙂

    Nah, think I'll stick with Marcus for 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

    April 15, 2011 at 7:08 am

    #1312102

  • RE: Tools to get the DML statement count

    No, not with any degree of accuracy.

    You can query the query_stats dmv, but that is dependant on the plans for the queries still being in cache, and after a month...

    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 15, 2011 at 6:49 am

    #1312082

  • RE: Tools to get the DML statement count

    There are log reader tools, like Apex SQLLog, but they are not cheap.

    The transaction log is not designed as an audit log. If you will need this info going forward,...

    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 15, 2011 at 4:27 am

    #1312024

  • RE: 'Operand type clash: uniqueidentifier is incompatible with int'

    Please note: year-old thread.

    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 15, 2011 at 4:16 am

    #1312023

Viewing 15 posts - 26,686 through 26,700 (of 49,552 total)