Forum Replies Created

Viewing 15 posts - 36,946 through 36,960 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Kit G (8/19/2009)

    Yeah, but what if you're trying to do the union of two queries and the results you want from one of the sub-queries depends on the ORBER BY...

    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, 2009 at 9:18 am

    #1041632

  • RE: moving SQL db from one drive to another

    Good point.

    For moving the system databases, see books online as the method is different for the different system databases.

    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, 2009 at 9:08 am

    #1041622

  • RE: New Picture of Steve Jones in the Daily Email

    I like the friday pic better.

    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, 2009 at 9:07 am

    #1041621

  • RE: Retrive a dropped db from sqlserver2005

    If there's no backup, you're probably not getting it back. All database should have backups, critical or not. The only time I can see a DB not needing a backup...

    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, 2009 at 9:00 am

    #1041606

  • RE: Database Mirroring

    Have you read through all the material in Books Online?

    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, 2009 at 8:59 am

    #1041604

  • RE: moving SQL db from one drive to another

    Two options.

    1) Detach the database, move the files, reattach the database.

    2) Use the ALTER DATABASE ... ALTER FILE to change the metadata. Take the database offline, move the files, bring...

    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, 2009 at 8:59 am

    #1041603

  • RE: Run Time ERROR 2147467259

    Before you do anything else to this database.

    1) Please run this and post the full output

    DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS

    2) Take a look at this...

    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, 2009 at 8:25 am

    #1041574

  • RE: Managing Transaction Logs

    Bob Bridges (8/19/2009)

    Is there a problem if I change to Full model while users are in the system or must I do this at an "off-time"?

    It can be done any...

    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, 2009 at 8:15 am

    #1041559

  • RE: SELECT database WHERE size = 'biggest in the world'

    I know that MySpace (which runs on SQL Server) is not one database. Last time I heard they had 100 or so database servers with the data distributed between them.

    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, 2009 at 8:00 am

    #1041541

  • RE: unused indexes

    Please note that index_usage_stats only contains info since the last time the SQL Service was started. If an index is, for example, only used at month end and the server...

    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, 2009 at 7:59 am

    #1041538

  • RE: Retrive a dropped db from sqlserver2005

    Restore from backup.

    You do have a backup, don't 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, 2009 at 7:57 am

    #1041533

  • RE: SELECT database WHERE size = 'biggest in the world'

    No idea how accurate any of these are...

    http://www.usatoday.com/money/industries/technology/maney/2006-05-16-nsa-privacy_x.htm

    I'd love to play with even the baby of the listed ones. 312 TB is one hell of a challenge.

    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, 2009 at 7:54 am

    #1041529

  • RE: No folders available under DB

    What happened to the log files? You need those for a reattach as well.

    There's no way that anyone can say what's happened or why without the information that we've asked...

    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, 2009 at 7:43 am

    #1041513

  • RE: No folders available under DB

    Sounds like the DB is suspect or recovery-pending.

    Did SQL restart just before this happened?

    Any errors relating to this DB in the SQL error log?

    What happens if in a query...

    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, 2009 at 7:30 am

    #1041501

  • RE: Back up Strategy

    CJ (8/19/2009)

    The full backups can create deadlocks and hold up your server.

    If you're talking about SQL deadlocks, then no. Backups don't take locks. They can increase IO load and slow...

    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, 2009 at 7:28 am

    #1041497

Viewing 15 posts - 36,946 through 36,960 (of 49,552 total)