Forum Replies Created

Viewing 15 posts - 39,361 through 39,375 (of 49,552 total)

  • RE: SSC Members Name

    Paul White (4/30/2009)

    I use Chrome, and the standard code=sql thing makes for really quite small text, so I added size=3 which looks good in Chrome.I'll stop doing that eh?

    😀

    Please. I...

    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

    April 30, 2009 at 4:25 pm

    #987059

  • RE: Are the posted questions getting worse?

    You do know that your link in that thread is 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

    April 30, 2009 at 3:37 pm

    #987021

  • RE: SSC Members Name

    Excluding, of course, creation of any constraints or indexes

    With the same table that I used earlier, I make it

    Table 'Users'. Scan count 1, logical reads 269, physical reads 0

    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

    April 30, 2009 at 3:30 pm

    #987014

  • RE: Oracle create table syntax

    Oracle Express has a web interface. i was using that. I think I'll find something else to use now.

    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

    April 30, 2009 at 3:23 pm

    #987006

  • RE: Are the posted questions getting worse?

    RBarryYoung (4/30/2009)

    Glad Gail got to him first, she always handles these very professionally. I would have had him two feet off the ground, grasping at his own throat.

    That's one...

    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

    April 30, 2009 at 3:20 pm

    #987004

  • RE: Holy Dynamic GUID Batman!

    This may be of interest to you.

    http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

    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

    April 30, 2009 at 1:46 pm

    #986916

  • RE: SSC Members Name

    ALTER TABLE Users ALTER COLUMN UserName VARCHAR(42)

    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

    April 30, 2009 at 1:36 pm

    #986906

  • RE: case when 'Holy' then 'Cow' else 'Going Nuts' end

    From Books Online (page on CASE)

    Returns the highest precedence type from the set of types in result_expressions and the optional else_result_expression.

    All of the columns you specify in the CASE...

    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

    April 30, 2009 at 12:44 pm

    #986860

  • RE: SSC Members Name

    RBarryYoung (4/30/2009)

    Don't forget to put the CASE back in if you do.

    True. That's what I get for posting while playing computer games....

    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

    April 30, 2009 at 12:44 pm

    #986858

  • RE: Queries running slower in SQL 2008 than in SQL 2000

    Frank Carrelli (4/30/2009)

    The Query Plan does look solid except for two Key Lookups on two different sub-select statements. They are not using the indexes we originally created for those select...

    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

    April 30, 2009 at 12:43 pm

    #986857

  • RE: Query runs slow due to MAX Date function.. suggestions?

    SELECT CustomerID,

    MaxCommentDate

    FROM Customer INNER JOIN

    (select Max(Comment.CommentDate) AS MaxCommentDate, CustomerID

    From Comment

    Where CommentType = 1

    GROUP BY CustomerID) AS Comments ON...

    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

    April 30, 2009 at 12:32 pm

    #986849

  • RE: Query runs slow due to MAX Date function.. suggestions?

    Udfs have an unpleasnat tendency to perform rather poorly. One reason being that they run once for each row of the resultset so if you have 50000 customers, that function...

    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

    April 30, 2009 at 12:19 pm

    #986838

  • RE: SSC Members Name

    RBarryYoung (4/30/2009)

    Hmm, depending on the duplicates density, this might be faster:

    Better on IOs, worse on time (at least on my PC)

    SQL Server parse and compile time:

    CPU...

    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

    April 30, 2009 at 11:44 am

    #986819

  • RE: SSC Members Name

    RBarryYoung (4/30/2009)

    Steve Jones - Editor (4/30/2009)

    Anyone got a better performing solution than Gail?

    Heh. Now you know we'll need to see the execution plan to better answer that. 😀

    Use...

    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

    April 30, 2009 at 11:40 am

    #986815

  • RE: SUBSCRIPTION

    Please don't cross post. It just wastes peoples time and fragments replies.

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

    April 30, 2009 at 10:53 am

    #986788

Viewing 15 posts - 39,361 through 39,375 (of 49,552 total)