Forum Replies Created

Viewing 15 posts - 7,696 through 7,710 (of 49,552 total)

  • RE: Sql Server 2008 backup and transaction log backup

    ying.wang (9/24/2014)

    According to my understand, when I do Sql Server full database backup, data in transaction log will be written to data files and transaction log is cleared.

    No.

    When 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

    September 24, 2014 at 2:49 pm

    #1747983

  • RE: Optimise procedure sql server 2008

    Go look at the blog post again. Play with the example listed there if you need to. It's really not hard and it's explained in that blog post.

    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

    September 24, 2014 at 6:36 am

    #1747809

  • RE: DDL Trigger - Suspect DB

    No.

    DDL triggers are there to catch users making changes to the database.

    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

    September 24, 2014 at 6:34 am

    #1747808

  • RE: Are the posted questions getting worse?

    Melanie.Townsend (9/23/2014)

    I've just logged a request with the developers to see if they can have a look and see if we can get the points back. Fingers crossed.

    Melanie

    Thanks

    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

    September 23, 2014 at 2:11 pm

    #1747645

  • RE: Are the posted questions getting worse?

    Sean Lange (9/23/2014)

    Koen Verbeeck (9/23/2014)

    Melanie.Townsend (9/23/2014)

    I've just logged a request with the developers to see if they can have a look and see if we can get the points back....

    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

    September 23, 2014 at 2:09 pm

    #1747644

  • RE: SQL Server EE Licensing Question

    dave 67553 (9/23/2014)

    This would be from MSDN not a Developer Edition per se, and would not be used for production during normal use, but only if failed over to, which...

    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

    September 23, 2014 at 11:36 am

    #1747596

  • RE: Seems like my SQL database is corrupted

    CliffordPreston (9/23/2014)

    Anyway maby anybody can help me here, I hope so. Thnks for advise.

    Unlikely. The people here know SQL Server, not MySQL, and for fixing database corruption you really need...

    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

    September 23, 2014 at 11:25 am

    #1747593

  • RE: Premature Optimisation

    Meow Now (9/23/2014)

    It gets quite frustrating when everything runs fine for months and then all of suddent some code takes a nose dive in performance, only in production at random...

    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

    September 23, 2014 at 11:15 am

    #1747587

  • RE: SQL 2008 R2 / SQL 2014 Sort Order

    Because the query plan that the optimiser generated there resulted in the data coming out in that order once the last query operators had finished with it.

    There is NO guarantee...

    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

    September 23, 2014 at 7:35 am

    #1747456

  • RE: need a query to map Object_ID to File_ID

    Risk for shrinking files? What risk?

    Any table over a single page could be spread across multiple files if there are multiple files in the filegroup.

    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

    September 23, 2014 at 7:25 am

    #1747442

  • RE: Optimise procedure sql server 2008

    You're already using dynamic SQL in your code. How can you say you're not allowed to do something you're already doing?

    If you're using SQL 2008, the way you optimise 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

    September 23, 2014 at 7:24 am

    #1747438

  • RE: need a query to map Object_ID to File_ID

    Tables are specific to a filegroup, not files. If there are multiple files in a filegroup, any table/index created on that filegroup will be spread across all the files 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

    September 23, 2014 at 7:09 am

    #1747426

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (9/23/2014)

    There is a sync job for the points, so I think we'll get our points back in a matter of time.

    That job runs every hour, so if 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

    September 23, 2014 at 7:02 am

    #1747422

  • RE: Are the posted questions getting worse?

    george sibbald (9/23/2014)

    Some of you guys must have taken a really big hit. 😀

    Yup. Close on 3000 points.

    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

    September 23, 2014 at 7:01 am

    #1747420

  • RE: SQL 2008 R2 / SQL 2014 Sort Order

    No ORDER BY, no guarantee of order. End of story.

    If you want a particular order, you put an ORDER BY. If you don't, you're telling SQL that it can return...

    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

    September 23, 2014 at 7:00 am

    #1747418

Viewing 15 posts - 7,696 through 7,710 (of 49,552 total)