Forum Replies Created

Viewing 15 posts - 32,371 through 32,385 (of 49,552 total)

  • RE: Index with Included Columns and Index Fragmentation

    Are you shrinking the database (manual or auto shrink) That'll cause fragmentation.

    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

    June 18, 2010 at 3:22 am

    #1181991

  • RE: NetApp iSCSI "SAN" and OLTP ?

    No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic939306-1550-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

    June 18, 2010 at 3:16 am

    #1181990

  • RE: Performance tunning SQL 2005

    Try these

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    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

    June 18, 2010 at 2:59 am

    #1181986

  • RE: Are the posted questions getting worse?

    Lynn Pettis (6/17/2010)

    Don't you love it when some one PM's you for help? Just deciding if I should help, post it for others as well, or just ignore 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

    June 18, 2010 at 2:50 am

    #1181984

  • RE: Where is my declared table stored?

    BrainDonor (6/18/2010)

    Interestingly, while working through Microsoft's training book for 70-433 I came across this, in answer to one of the questions:

    "You can eliminate all the intermediate temporary tables by 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

    June 18, 2010 at 2:34 am

    #1181979

  • RE: WTF?? concatenating Date and time varchar fields messes up the milliseconds!!

    Create a custom CLR type and re-implement all of the datetime functions? Store the miliseconds in a separate column?

    There's no easy (or even really practical) way on SQL 2005.

    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

    June 17, 2010 at 2:24 pm

    #1181854

  • RE: Five Things I Learned at the PASS Summit

    Steve Jones - Editor (6/17/2010)

    You can hear some of the audience.

    Depends how loud they shout. 😉

    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

    June 17, 2010 at 2:20 pm

    #1181852

  • RE: Recover corrupted mdf file - SS 2000

    What did you do to get it into emergency mode? the ALTER DATABASE described on the blog is only for SQL 2005+, it won't work on SQL 2000.

    Basically, what are...

    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

    June 17, 2010 at 2:00 pm

    #1181838

  • RE: Five Things I Learned at the PASS Summit

    No. The speaker is supposed to repeat audience questions before answering, most of them do most of the time.

    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

    June 17, 2010 at 1:59 pm

    #1181837

  • RE: Five Things I Learned at the PASS Summit

    The DVDs are very good. They're not videos of the presenter, they're desktop captures + audio. so you don't have to worry about whether or not you can see 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

    June 17, 2010 at 1:47 pm

    #1181827

  • RE: WTF?? concatenating Date and time varchar fields messes up the milliseconds!!

    Because datetime has an accuracy of 3 milliseconds. It cannot store 351 milliseconds, only 350 or 353.

    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

    June 17, 2010 at 1:45 pm

    #1181826

  • RE: Using an Int to store a date

    That's how MSDB stores job-related dates. If anyone's ever tried to write custom scripts against the MSDB job tables, they'll know how complex that method of storage makes queries.

    Dates should...

    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

    June 17, 2010 at 1:04 pm

    #1181801

  • RE: can I shrink the database include log file, when database is a Transaction (Subscription) database

    Then drop the publication. By having it there (and I assume not having the log reader running) the log cannot be reused because it's marked for replication.

    Once you've dropped 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

    June 17, 2010 at 12:59 pm

    #1181797

  • RE: can I shrink the database include log file, when database is a Transaction (Subscription) database

    MAK-1128556 (6/17/2010)

    I am 110% sure this db is a subscriber

    Replicated Transaction Information:

    Oldest distributed LSN : (318309:27942:217)

    ...

    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

    June 17, 2010 at 11:52 am

    #1181764

  • RE: can I shrink the database include log file, when database is a Transaction (Subscription) database

    Don't stop the log reader. It has to be running (and running without error) to mark log space as reusable.

    Are you sure (100% sure) that this is the subscriber, not...

    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

    June 17, 2010 at 11:43 am

    #1181757

Viewing 15 posts - 32,371 through 32,385 (of 49,552 total)