Forum Replies Created

Viewing 15 posts - 21,166 through 21,180 (of 49,552 total)

  • RE: Moving Table to a different File group

    qew420 (1/10/2012)

    So far I found the following and tested it and it is working

    1.-create a new table on the new filegroup

    2.-copy the entire table containing (text,image data) to 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

    January 10, 2012 at 12:41 pm

    #1431368

  • RE: Microsoft Gold Certified Partner Companies - Horror Stories

    LutzM (1/10/2012)

    royce.bacon (1/10/2012)

    Before calling this a bad design you need to consider the functionality the software is providing. If the software allows the users to define the field names...

    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

    January 10, 2012 at 12:40 pm

    #1431367

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (1/10/2012)

    GilaMonster (1/10/2012)

    Gianluca Sartori (1/10/2012)

    GilaMonster (1/10/2012)

    Gianluca Sartori (1/10/2012)

    Even worse: http://141microseconds.wordpress.com/2011/09/24/faster-than-light/.

    Oh my....

    Remember this next time you complain about your politicians. 😉

    Yours are just in serious need of a scientific adviser. Mine...

    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

    January 10, 2012 at 7:25 am

    #1431138

  • RE: How to find deleted database?

    I already did.

    GilaMonster (1/10/2012)

    http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/

    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

    January 10, 2012 at 7:21 am

    #1431132

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (1/10/2012)

    GilaMonster (1/10/2012)

    Gianluca Sartori (1/10/2012)

    Even worse: http://141microseconds.wordpress.com/2011/09/24/faster-than-light/.

    Oh my....

    Remember this next time you complain about your politicians. 😉

    Yours are just in serious need of a scientific adviser. Mine are outright...

    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

    January 10, 2012 at 7:16 am

    #1431129

  • RE: How to find deleted database?

    azdzn, please start a new thread rather than hijacking someone else's

    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

    January 10, 2012 at 7:05 am

    #1431114

  • RE: SQL Server 2008 Express SP1

    I think so, but I can never remember exactly what was in each of the download options (there were 3 or 4 at one point)

    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

    January 10, 2012 at 7:03 am

    #1431110

  • RE: Are the posted questions getting worse?

    Greg Edwards-268690 (1/10/2012)

    The Bending of light to enable you to become invisible?:-D

    That's already been done iirc

    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

    January 10, 2012 at 6:59 am

    #1431106

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (1/10/2012)

    GilaMonster (1/10/2012)

    Ninja's_RGR'us (1/10/2012)

    Gianluca Sartori (1/10/2012)

    mtillman-921105 (1/9/2012)

    jcrawf02 (1/9/2012)

    And what does that make those of us who are following the debates about the faster than light neutrinos?

    I've been interested in...

    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

    January 10, 2012 at 6:54 am

    #1431100

  • RE: How to find deleted database?

    Did you check the default trace?

    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

    January 10, 2012 at 6:51 am

    #1431095

  • RE: SQL Server 2008 Express SP1

    There are several downloads for express edition. The basic one (first in the drop down box on this page: http://www.microsoft.com/betaexperience/pd/SQLEXP08V2/enus/) does not have management studio. It's just the database engine....

    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

    January 10, 2012 at 6:46 am

    #1431086

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (1/10/2012)

    Gianluca Sartori (1/10/2012)

    mtillman-921105 (1/9/2012)

    jcrawf02 (1/9/2012)

    And what does that make those of us who are following the debates about the faster than light neutrinos?

    I've been interested in that too... ...

    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

    January 10, 2012 at 6:33 am

    #1431071

  • RE: How to find deleted database?

    Are you sure default trace is enabled? Are there any trace files in the SQL error log directory?

    What's the entire output of a query of sys.traces?

    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

    January 10, 2012 at 6:31 am

    #1431069

  • RE: How to find deleted database?

    http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/

    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

    January 10, 2012 at 5:25 am

    #1431023

  • RE: How to find deleted database?

    It'll be in the default trace, providing the delete wasn't too long ago. The trace files are in the SQL error log directory, you can copy them then open in...

    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

    January 10, 2012 at 4:49 am

    #1431004

Viewing 15 posts - 21,166 through 21,180 (of 49,552 total)