Forum Replies Created

Viewing 15 posts - 45,856 through 45,870 (of 59,062 total)

  • RE: Select Where_Min()

    RBarryYoung (1/16/2009)

    It's weird actually. There's no obvious reason why RANK() and ROW_NUMBER() should be faster than MIN(), but they clearly are when you look at the differences in the...

    January 16, 2009 at 7:38 am

    #928137

  • RE: Phone Numbers Table Design

    Jack Corbett (1/16/2009)

    Vikas and Abhijit have offered better solutions. Your original proposal is inflexible as you limit the # of phone numbers to the number of columns in the...

    January 16, 2009 at 7:35 am

    #928128

  • RE: Which SQL would run faster?

    r.hensbergen (1/16/2009)

    Make it a poll instead... 🙂 I think 1 and 2 would be equal in performance (it seems that the same amount of rows are touched, and every row...

    January 16, 2009 at 7:25 am

    #928110

  • RE: Hidden RBAR: Triangular Joins

    robertm (1/16/2009)

    Hey Jeff,

    Good article. It's great that you and others are continuing to drive home the fundamentals of good code practices!!

    Rob.

    Glad you liked it, Robert. It was supposed to...

    January 16, 2009 at 7:18 am

    #928103

  • RE: Hidden RBAR: Triangular Joins

    Hmmm, not sure... on the home page, it's listed as "By Jeff Moden 2009/01/16 (first posted: 2007/12/06)"... not sure why the date of the actual article changed.

    Steve? If you...

    January 16, 2009 at 7:14 am

    #928096

  • RE: Which SQL would run faster?

    Why don't you just run it and tell us? 😉

    January 15, 2009 at 11:28 pm

    #927857

  • RE: Phone Numbers Table Design

    That's a much better design.

    January 15, 2009 at 11:26 pm

    #927856

  • RE: Select from String

    Oh dear... thanks for sharing, but why on Earth did you use a cursor? That's gonna slow it down, alot!

    January 15, 2009 at 11:22 pm

    #927854

  • RE: Calculate pmt in t-sql (like excel)

    Sergiy (1/15/2009)

    Scott T (12/30/2008)

    For any math calculation avoid FLOAT use Decimal you will get Write result.:D

    DECLARE @One decimal, @Three decimal

    SET @One = 1

    SET @Three = 3

    SELECT @One/@Three + @One/@Three +...

    January 15, 2009 at 11:17 pm

    #927851

  • RE: Common Mistakes in T-SQL

    ScottPletcher (1/15/2009)

    DB2 will sometimes even "rewrite" the conditions to something logically equivalent but faster.

    But it was my understanding that SQL Server did not do that, at least thru SQL 2005.

    Is...

    January 15, 2009 at 6:36 pm

    #927822

  • RE: Are the posted questions getting worse?

    Lynn Pettis (1/15/2009)

    This is the first time I've been asked to check due to user complaints.

    One of the main reasons to carry a sword to work... no one asks those...

    January 15, 2009 at 6:24 pm

    #927819

  • RE: concatenating column values in select when there is a null column

    Heh... yeap... that's a doozy. 🙂

    January 15, 2009 at 6:18 pm

    #927818

  • RE: Split large csv

    noeld (1/15/2009)

    FYI: I have successfully Bulk imported 1.3 billion rows files without problems before.

    ORDER BY and TABLOCK hints and No type conversions, were the dominant factors in the matter.

    Do you...

    January 15, 2009 at 6:16 pm

    #927817

  • RE: Split large csv

    RichardB (1/15/2009)

    Thanks jeff.

    Well, the file might be 200gb. Not sure what the ordering is going to be like, but the original table is clustered differently to the final...

    January 15, 2009 at 6:14 pm

    #927816

  • RE: SQL or Oracle

    gints.plivna (1/15/2009)

    Define best.

    Not a problem... Which can someone write the highest performance code in that correctly does the job in the shortest time for the least amount of money with...

    January 15, 2009 at 6:04 pm

    #927814

Viewing 15 posts - 45,856 through 45,870 (of 59,062 total)