Forum Replies Created

Viewing 15 posts - 37,186 through 37,200 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (8/10/2009)

    Thanks Gail! I'm never patient when it's time to learn something new, especially from you!

    Please note I'm asking for an article review, either a technical review or comments...

    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 10, 2009 at 6:18 am

    #1036713

  • RE: Twenty tips to write a good stored procedure

    Jeff Moden (8/10/2009)

    [font="Arial Black"]Absolutely not true. Please, folks... stop perpetuating this myth.[/font] That's a left over wives tale for the original version of 6.5. Don't take my...

    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 10, 2009 at 6:13 am

    #1036710

  • RE: Twenty tips to write a good stored procedure

    rja.carnegie (8/10/2009)

    How much space does a variable consume? I assume kilobytes at most typically, which is really nothing at all. I mean, you aren't going to use thousands...

    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 10, 2009 at 6:09 am

    #1036708

  • RE: Twenty tips to write a good stored procedure

    kuldip.bhatt (8/10/2009)

    one question is every thing is true for sql 2008 or not ?

    No. But then not everything in the article is true for 2005 or 2000 either.

    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 10, 2009 at 6:05 am

    #1036705

  • RE: Creating Query with Sub-Query containing multipal records

    Try moving the subquery to the from clause as a derived table.

    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 10, 2009 at 4:31 am

    #1036670

  • RE: Transaction Log full for production database

    I just told you how to troubleshoot and fix orphaned connections. The first part of my post above that talks about sys.sm_tran_locks.

    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 10, 2009 at 4:08 am

    #1036655

  • RE: MCDBA OR MCTP

    The exams for the MCDBA cert were retired months ago and hence the cert can no longer be obtained.

    See here for current certs

    http://www.microsoft.com/learning/mcp/certifications.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

    August 10, 2009 at 4:07 am

    #1036654

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (8/10/2009)

    Any volunteers to proof read an article on indexing?

    Here's one! What should I do to get this exclusive preview?

    Be patient. It's not finished yet. If you're keen 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 10, 2009 at 3:30 am

    #1036637

  • RE: Using a subquery in select list with a GROUP BY clause?

    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 10, 2009 at 3:07 am

    #1036634

  • RE: Are the posted questions getting worse?

    Woot. My muse has returned. Sat down over the weekend and hammered out 3 pages of an article that I've been staring blankly at for the last couple months.

    Any...

    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 10, 2009 at 3:05 am

    #1036633

  • RE: Twenty tips to write a good stored procedure

    Chris Howarth (8/10/2009)

    I disagree with point 7 - regarding the sp_ prefix, try the example below.

    What he said is mostly true. It was true on SQL 2000 (if I recall)....

    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 10, 2009 at 2:49 am

    #1036631

  • RE: Transaction Log full for production database

    To fix the spid -2 problems (which is an orphaned distributed transaction) run this

    select request_owner_guid from sys.dm_tran_locks

    where request_session_id = -2

    Pass the guid the the query returns to the KILL command...

    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 10, 2009 at 2:40 am

    #1036630

  • RE: Twenty tips to write a good stored procedure

    Sorry, but I'm going to greatly disagree with a number of these 'tips'

    8. sp_executeSQL and the KEEPFIXED PLAN options - Both sp_executesql and the KEEPFIXED PLAN option avoid the recompilation...

    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 10, 2009 at 2:30 am

    #1036626

  • RE: required help

    Can you explain what it is that the cursor's doing?

    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 10, 2009 at 1:58 am

    #1036619

  • RE: DTA (database tuning advisor) tool

    The Database tuning advisor is only included in Standard, Enterprise and Developer editions. You can either download a 180 day trial of Enterprise edition or you can buy developer edition...

    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 10, 2009 at 1:46 am

    #1036618

Viewing 15 posts - 37,186 through 37,200 (of 49,552 total)