Forum Replies Created

Viewing 15 posts - 25,126 through 25,140 (of 49,552 total)

  • RE: A TO Z of Indexing

    That could easily be an entire book (but one doesn't exist)

    Start with this series: http://www.sqlservercentral.com/articles/Indexing/68439/

    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

    July 6, 2011 at 8:29 am

    #1349017

  • RE: Brain racking for fun (Can you track/capture a select from a specific Login)

    Server-side trace. The T-SQL:StmtStarting event

    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

    July 6, 2011 at 8:27 am

    #1349015

  • RE: Cannot take a database offline

    Yup. SSMS just runs commands against SQL. Exactly the same command you can write and run.

    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

    July 6, 2011 at 8:25 am

    #1349011

  • RE: Cannot take a database offline

    Same thing. To make a DB single user there much be no other users in it.

    Forget about messing with single user, make sure your connection is not using...

    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

    July 6, 2011 at 7:48 am

    #1348968

  • RE: Are the posted questions getting worse?

    Kit G (7/6/2011)

    GilaMonster (7/6/2011)

    Branching, cause 2 bad jokes are worse than one.

    Kit G (7/6/2011)

    Fal (7/6/2011)

    anyone with a minor dose of manners and a sense of humor is invited.

    Please, kind...

    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

    July 6, 2011 at 7:18 am

    #1348934

  • RE: Reduce size of mdf file.

    Ol'SureHand (7/6/2011)

    Gail, as you said: The backup runs a checkpoint before it starts and that's what truncates the log, not the backup.

    Perhaps that's what happens technically; practically, I don't know...

    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

    July 6, 2011 at 7:17 am

    #1348932

  • RE: SQL Server Synchronous and Asynchronous reads

    These are the two key whitepapers

    SQL Server I/O Basics (SQL Server 2000) http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlIObasics.mspx

    SQL Server I/O Basics, Chapter 2 (SQL Server 2005) http://www.microsoft.com/technet/prodtechnol/sql/2005/iobasics.mspx

    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

    July 6, 2011 at 7:09 am

    #1348917

  • RE: SSAS

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1137119-1291-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

    July 6, 2011 at 7:08 am

    #1348913

  • RE: Impossible Total Server Memory values with realistic Target Server Memory

    I could actually almost believe those. SQL's a memory hog.

    What's your max memory set to on the two instances?

    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

    July 6, 2011 at 7:02 am

    #1348904

  • RE: Log backup

    anil_kumar32 (7/6/2011)

    Once back up is complete all the modications made by commited transactions are truncated from the transaction log file.

    Not necessarily. There are a number of things that can keep...

    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

    July 6, 2011 at 7:00 am

    #1348901

  • RE: How expensive are my page checksums

    Don't. Seriously.

    Tune the queries that are causing the high CPU. You'll get a far better return on that than dropping back to a less reliable page verification. Bear in mind,...

    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

    July 6, 2011 at 6:58 am

    #1348899

  • RE: Are the posted questions getting worse?

    Branching, cause 2 bad jokes are worse than one.

    Kit G (7/6/2011)

    Fal (7/6/2011)

    anyone with a minor dose of manners and a sense of humor is invited.

    Please, kind Ladies and Gents,...

    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

    July 6, 2011 at 6:53 am

    #1348889

  • RE: Transparent database encryption

    Thomas Abraham (7/6/2011)

    If my first post was sarcastic it was not intentional. To those that took it that way, I apologize.

    Accepted (yes, I did read it as sarcastic)

    (Now slinking off...

    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

    July 6, 2011 at 6:51 am

    #1348883

  • RE: Reduce size of mdf file.

    Ol'SureHand (7/6/2011)

    In practical simplified terms, a full backup will achieve what is needed, i.e. a cleanup that I suspect does not get done, because the default settings for new 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

    July 6, 2011 at 6:50 am

    #1348881

  • RE: What happens to SQL Server when we shut down/Start Windows..?

    Jayanth_Kurup (7/6/2011)

    Moral of the Story :-before shutting down the OS give SQL enough time to perform a clean shutdown of the databases else face long recovery times when...

    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

    July 6, 2011 at 6:45 am

    #1348875

Viewing 15 posts - 25,126 through 25,140 (of 49,552 total)