Forum Replies Created

Viewing 15 posts - 49,606 through 49,620 (of 59,099 total)

  • 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...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    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...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    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...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    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...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    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...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    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.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 27, 2008 at 7:17 am

    #835314

  • RE: Do I need more memory?

    jjssilva (6/27/2008)

    Jeff Moden (6/26/2008)

    jjssilva (6/26/2008)

    Check Buffer Cache values. Also, how big are the Databases?

    The DB shouldn't take more than 80% of the available RAM.

    So... what do you do when you...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 27, 2008 at 7:15 am

    #835313

  • RE: eliminating duplicates

    Heh... Hey, Barry! Did I 'splain all that correctly? :hehe:

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 27, 2008 at 7:10 am

    #835305

  • RE: eliminating duplicates

    Don't look at the symbols... the symbols mean nothing to humans. What is important is the ASCII value... it can be 0 to 255 in a single character VARCHAR...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 27, 2008 at 7:09 am

    #835304

  • RE: what date format is this?

    Chris Morris (6/27/2008)

    Jeff Moden (6/26/2008)

    Heh... no problem... if you think no coffee is bad, I'm trying to quit smoking... got anyone you want to take to a porkchop dinner? 😀

    Ahah...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 27, 2008 at 7:03 am

    #835300

  • RE: Grouping GROUP BY subtotals

    I don't see where you've used that particular ISNULL as a join. It think it would be a problem if it were actually in a join because it uses...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 27, 2008 at 6:58 am

    #835294

  • RE: Need Some Queries

    jezemine is correct, though. I didn't really help with your test questions and you should learn how to use Books Online to find those answers.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 27, 2008 at 6:48 am

    #835289

  • RE: SQL table dynamic creation

    gerald.duncan (6/27/2008)

    My goal is to create a table for each flat file.

    You still haven't explained why you want to do that, Gerald. Not trying to bust your chops......

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 27, 2008 at 6:44 am

    #835287

  • RE: For loop in sql server

    Thank you for the awesome compliment, Jim! Folks like you sure help keep me going...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 27, 2008 at 6:42 am

    #835285

  • RE: Parameter list query - peformance 32bit vs 64bit

    Wow... I guess 64 bit isn't ready for primetime...

    Of course, I still say that about 2k5 when the optimizer makes the wrong choice... 😛

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 27, 2008 at 12:23 am

    #835172

Viewing 15 posts - 49,606 through 49,620 (of 59,099 total)