Forum Replies Created

Viewing 15 posts - 43,006 through 43,020 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Jeff Moden (11/22/2008)

    But none of us has written a book like some of the good folks we know. 😉

    And he's writing another one. A full, published dead-tree book...

    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

    November 22, 2008 at 6:14 pm

    #902114

  • RE: Are the posted questions getting worse?

    Lynn Pettis (11/22/2008)

    Yeh, it has been a killer week telling everyone to read Jeff's article on how to post better questions over and over. I feel like a broken...

    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

    November 22, 2008 at 5:54 pm

    #902112

  • RE: Jonathan Kehayias: SQL Hero!

    Ninja's_RGR'us (11/22/2008)

    I sure hope this presentation of writing bad code will find its way on the newsletter someday... I'd sure love to read that!

    I'll check with the PASS people. If...

    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

    November 22, 2008 at 5:50 pm

    #902110

  • RE: DBCC SHRINK FILE with NOTRUNCATE , how to see the results?

    llokshin (11/22/2008)

    For now I just did index defrag for some of the tables in db and see that used space isn't changed but free space grew for about...

    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

    November 22, 2008 at 5:42 pm

    #902108

  • RE: Defragmentation issue

    teddunaveen (11/22/2008)

    hi Experts how are you

    We're busier than we would like due to multiple threads that could easily be answered by a quick read through of Books Online.

    1)How to do...

    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

    November 22, 2008 at 5:41 pm

    #902107

  • RE: When to shrink database, right before or after a Full Backup

    full backup has never truncated the tran log. not in 2005, not in SQL 2000.

    samalex (11/21/2008)

    If we do a trans log backup 4 times a day I assume this will...

    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

    November 22, 2008 at 12:12 pm

    #902076

  • RE: Can we change 1st table read in an exection plan

    Marco André Duarte Francisco (11/22/2008)

    Thanks for your reply.

    Well, I'm starting to use query hints a lot...in my particular case, the index hints.

    Don't. Hints should be a last resort 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

    November 22, 2008 at 12:00 pm

    #902075

  • RE: SQL Server's Role in "The Cloud"

    Databases are going to need managing whether they're in the 'cloud' or in your server room. Maybe you can pay extra for backup services, but that's not all a DBA...

    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

    November 22, 2008 at 11:56 am

    #902073

  • RE: Are the posted questions getting worse?

    Jack Corbett (11/22/2008)

    Oh, and based on your tweets it didn't seem like you were late to any of the PASS Summit parties!:D:P

    Grant late for a party? That'll be...

    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

    November 22, 2008 at 11:40 am

    #902071

  • RE: Jonathan Kehayias: SQL Hero!

    Jack Corbett (11/22/2008)

    Glad it was packed out Gail.

    It wasn't completely packed out. There were empty seats. I'd say the room was 50-60% full. Bob Ward's session in 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

    November 22, 2008 at 11:39 am

    #902070

  • RE: Undocumented Routines: Forbidden fruit.

    Phil Factor (11/22/2008)

    One slightly scarey thought bothers me though: If the structure and processes of the transaction log were fully documented, then would it then be maliciously hacked? We'd then...

    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

    November 22, 2008 at 11:36 am

    #902068

  • RE: Security Settings for replication

    Where? When setting up the distributor? When setting up the publication? When setting up the subscription? There are a number of places where security gets set doing replication.

    Generally 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

    November 22, 2008 at 11:23 am

    #902066

  • RE: Jonathan Kehayias: SQL Hero!

    rbarryyoung (11/22/2008)

    You were there too? Rats! If I had know that I would have tried to find you...

    Jonathan was the one who commented about Linq.

    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

    November 22, 2008 at 11:19 am

    #902064

  • RE: Security Settings for replication

    What settings where do you not understand? When setting up the distributor? The publication? The subscription?

    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

    November 22, 2008 at 12:48 am

    #901995

  • RE: Undocumented Routines: Forbidden fruit.

    Phil, you say

    I include DBCC Log, and its offspring fn_dblog, where there seems to be no documented way of doing perfectly legitimate actions to maintain or audit your own data.

    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

    November 22, 2008 at 12:41 am

    #901994

Viewing 15 posts - 43,006 through 43,020 (of 49,552 total)