Forum Replies Created

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

  • RE: Date Conversion Fills the Transaction log

    Jeff Moden (8/21/2010)

    Using a computed column also overcomes my itch (and a lot of other people's itches) about storing an actual formatted date in a database (which is considered by...

    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

    August 21, 2010 at 9:52 am

    #1210037

  • RE: Use database name dynamically - Use @dbname

    Dynamic SQL's the only way to do that and once the USE is in dynamic, everything to be done in the DB needs to be as well.

    What are you trying...

    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

    August 20, 2010 at 11:24 pm

    #1209990

  • RE: Do you advise to apply Recomendations given by DTA?

    SqlServerLover (8/20/2010)

    Do you advise to create those additional statistics and indexes?

    I advice people to test those recommendations carefully, and then apply only the ones that make a noticeable improvement 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

    August 20, 2010 at 11:23 pm

    #1209989

  • RE: Updateusage on SQL2008

    simon.letts (8/20/2010)

    Once I copied the data back in the stats were looknig better...10mb reserved, 9 mb data, 1mb unused. After a while it went back to the original figures...

    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

    August 20, 2010 at 3:00 pm

    #1209939

  • RE: Deprecated form of CROSS JOIN

    I don't think that the above syntax can be deprecated. Not unless they also deprecate any form of predicates comparing two tables in the where clause (and that would 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

    August 20, 2010 at 1:14 pm

    #1209889

  • RE: help needed in code tuning.

    Jeff Moden (8/20/2010)

    Comment withdrawn. I couldn't find the MS reference that I remember seeing to support what I said so I've withdrawn my comment.

    Now I'm curious... PM...

    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

    August 20, 2010 at 1:11 pm

    #1209886

  • RE: Questions about moving large table to its own file group

    jeff.mason (8/20/2010)

    Well, you have to drop the primary key in order to drop the clustered index, if the primary key was created PRIMARY KEY CLUSTERED. And of course 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

    August 20, 2010 at 1:09 pm

    #1209884

  • RE: Session blocking performance

    Books Online does have sample code under either sys.dm_exec_requests or sys.dm_exec_sql_text (or maybe both)

    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

    August 20, 2010 at 11:55 am

    #1209843

  • RE: How to stop a 'Shrink Database' from the GUI

    No way from the gui. Open a query window, find the session id that the shrink is running from and KILL it.

    Regarding the shrink...

    Shrinking causes massive fragmentation and will just...

    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

    August 20, 2010 at 11:20 am

    #1209826

  • RE: Update 'failure' that not failing

    Why should it fail?

    When you have subqueries within another query, the tables and columns in the outer query are fully visible in all of the subqueries. In your example, tbl2...

    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

    August 20, 2010 at 11:17 am

    #1209823

  • RE: Back up on External Hard Drive keeps

    tt-615680 (8/20/2010)

    ... but I need it to backup all the data that I have not been saved since the last differential back up

    A single differential will do that. Differential backups...

    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

    August 20, 2010 at 11:14 am

    #1209821

  • RE: Deleteing part data from a database

    Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    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

    August 20, 2010 at 8:35 am

    #1209702

  • RE: Back up on External Hard Drive keeps

    GilaMonster (8/20/2010)

    Appending or overwriting?

    What's the frequency of your full and diff backups, and do they both go to the external?

    Remember that a diff backs up changes since the last full...

    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

    August 20, 2010 at 8:34 am

    #1209701

  • RE: Session blocking performance

    Yes. Query sys.dm_exec_requests and CROSS APPLY sys.dm_exec_sql_text. The column text will give you the batch or proc that the session is running.

    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

    August 20, 2010 at 8:33 am

    #1209700

  • RE: How do I get the Last Inserted / Modifed Record

    If you need to get the last inserted/modified, then you need a datetime column to store modification dates and a trigger to update them (or a rowversion column)

    Then you can...

    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

    August 20, 2010 at 8:24 am

    #1209695

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