Forum Replies Created

Viewing 15 posts - 29,656 through 29,670 (of 49,552 total)

  • RE: Full DB Backup getting File System Limitation error

    Native SQL backup or 3rd party tool?

    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

    October 29, 2010 at 10:08 am

    #1244309

  • RE: 1 database in a server can't be opened

    mashikoo (10/29/2010)

    "Database 'TIN0650' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details."

    So what details were in the 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

    October 29, 2010 at 10:02 am

    #1244304

  • RE: Managing VLF's

    SwayneBell (10/29/2010)

    So, if we find that we have too many VLF's (e.g. due to a log that has grown many times by small increments), do we have options to reduce...

    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

    October 29, 2010 at 9:48 am

    #1244297

  • RE: Full DB Backup getting File System Limitation error

    What's the exact error you're getting?

    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

    October 29, 2010 at 9:45 am

    #1244291

  • RE: Most CPU intensive queries

    It's not creating the proc, it's running it.

    When you query sys.dm_exec_sql_text and the handle you pass is for a running stored proc, you get back the creation script for the...

    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

    October 29, 2010 at 6:37 am

    #1244105

  • RE: SQL Server 2008 (R2?)

    The exams are for SQL 2008. There are no R2 features within the exam material, there are no exams on 2008 R2.

    This can be seen from the list of...

    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

    October 29, 2010 at 6:05 am

    #1244082

  • RE: Most CPU intensive queries

    ps. (10/28/2010)

    Line number 7 is most amusing to me as it shows that particular SP has been created 17163 times in the last 12 hours or so (server was rebooted...

    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

    October 29, 2010 at 5:18 am

    #1244053

  • RE: SQL Server 2008 (R2?)

    The exams are for SQL 2008. They do not cover the additional features in R2.

    As for the differences, they're covered in lots of places, try a google/bing search.

    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

    October 29, 2010 at 3:14 am

    #1244025

  • RE: 24 x 7 x 365 HA environment

    If you need that kind of availability and you're not familiar with HA/DR, get a consultant in to advise and help you. This is not an area you want 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

    October 29, 2010 at 3:12 am

    #1244024

  • RE: How to Kill 000-105 test?

    That's not a Microsoft exam code. What exam is it?

    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

    October 28, 2010 at 11:32 pm

    #1243987

  • RE: Duplicate Index Performance

    Hint: What makes a clustered index different from a nonclustered index?

    Yes, it may be possible with work to make a nonclustered index larger than the cluster, it's not something 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

    October 28, 2010 at 11:17 pm

    #1243985

  • RE: Log-shipping - How to sync two different databases - Primary is Live and Seconday is for Archiving

    MidBar (10/28/2010)

    But thats what i am trying to do. Delete record before setup log-shipping and then remove Log of that deletion before i create a Log-shipping. So whenever needed, i...

    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

    October 28, 2010 at 4:45 pm

    #1243924

  • RE: Quick SQL question

    scott.pletcher (10/28/2010)

    (really generally you should avoid IN / NOT IN, and instead use the correct type of join, but that's a different matter).

    Why do you say that?

    What do 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

    October 28, 2010 at 4:35 pm

    #1243921

  • RE: Unable to shrink database log file

    Yup. Wait a bit and try again. It happens sometimes.

    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

    October 28, 2010 at 4:30 pm

    #1243919

  • RE: Unable to shrink database log file

    jonathan.rottanburg (10/28/2010)

    I ran the following:

    DbIdFileIdCurrentSizeMinimumSizeUsedPagesEstimatedPages

    627301024318573010243184

    ??

    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

    October 28, 2010 at 4:20 pm

    #1243913

Viewing 15 posts - 29,656 through 29,670 (of 49,552 total)