Forum Replies Created

Viewing 15 posts - 49,576 through 49,590 (of 59,078 total)

  • RE: Do I need more memory?

    jjssilva (6/27/2008)

    What I ment was, in order to have maximum performance gain from the DB, it should be in memory. Usually around 80% is enough. You can have less memory...

    June 27, 2008 at 8:40 am

    #835395

  • RE: Do I need more memory?

    Matt Miller (6/27/2008)

    I keep waiting for my guys to install that 1 Exabyte RAMdisk I asked for. Just would make all of those nasty delays just melt away...I wonder...

    June 27, 2008 at 8:37 am

    #835394

  • RE: The T-SQL Quiz

    Ummm... you think the use of a While loop is "elegant"? :blink: :Whistling:

    June 27, 2008 at 8:32 am

    #835388

  • RE: How to design an optional unique constraint

    Stephanie Giovannini (6/27/2008)

    Hmmm... I suppose the second table is the best way to do it, if I'm allowed to do so. At least I now have ammunition.

    Sorry, Stephanie... I have...

    June 27, 2008 at 8:30 am

    #835384

  • RE: Table Valued functions Vs Scalar Valued Functions

    TheSQLGuru (6/27/2008)

    At each of my last 3 SQL 2005 performance tuning/analysis client gigs I have addressed tremendous performance issues by removing the use of TVFs (and also table variables). ...

    June 27, 2008 at 8:09 am

    #835365

  • RE: Grouping GROUP BY subtotals

    jcrawf02 (6/27/2008)

    Sergiy (6/27/2008)

    jcrawf02,

    can you explain this:

    ISNULL(count(distinct #PLANDATA_Claim.claimid),0) AS "FFS",

    What ISNULL is doing here?

    I have...

    June 27, 2008 at 8:07 am

    #835363

  • RE: Grouping GROUP BY subtotals

    jcrawf02 (6/27/2008)

    Sorry, didn't use that in this example. What I ended up doing in my live version is this:

    LEFT JOIN #member ON (ISNULL(PLANDATA_Claim.enrollid,ENCOUNTER_Claim.enrollid) = #member.enrollid )

    Hmmmm.... I suppose that...

    June 27, 2008 at 8:05 am

    #835361

  • RE: For loop in sql server

    Thanks for the feedback...

    June 27, 2008 at 8:00 am

    #835358

  • RE: more elegant search

    Heh... wasn't me, Bill... I'm still trying stuff out...

    June 27, 2008 at 7:54 am

    #835350

  • RE: Float vs Decimal?

    JohnG (6/27/2008)

    yes, I have an accounting degree

    Heh... nothing real evil meant here, John... but when I see something like that, I remember all the folks that I've interviewed that had...

    June 27, 2008 at 7:50 am

    #835349

  • RE: How can I limit CPU usage per user in SQL 2005?

    Yuckon (6/27/2008)

    Hi chaps

    Thanks for your input but I think you are missing my point.

    The code is made up,

    The end user is not the best at writing efficient SQL and I...

    June 27, 2008 at 7:39 am

    #835340

  • RE: Archetype Records

    That's the fun part about this world... you looked up things having to do with Records and SQL... that's too much info. Forget about "Archetype Records"... you don't even...

    June 27, 2008 at 7:35 am

    #835338

  • RE: extracting database sizes using sp_spaceused

    susan.bartrum (6/26/2008)

    I have trawled through lots of sys views and I have not found anything usable yet.

    Another tip would be...

    When you find a useful MS provided stored procedure such as...

    June 27, 2008 at 7:30 am

    #835335

  • RE: Compare 2 tables

    eddy (6/27/2008)

    is not so expensive if you see what you get in return

    I've gotta agee there... what you get is proven code with no bugs... Red Gate is real good...

    June 27, 2008 at 7:19 am

    #835319

  • RE: Datetime

    Careful... using CONVERT to strip the time off the date (1st example) or the date off the time (2nd example) can slow queries down quite a bit.

    June 27, 2008 at 7:17 am

    #835314

Viewing 15 posts - 49,576 through 49,590 (of 59,078 total)