Forum Replies Created

Viewing 15 posts - 61 through 75 (of 83 total)

  • RE: Bookmark Lookup Options...

    If possible, one thing that may help is to do the sorting in the application.

    Creating an index on the view sounds like it will probably be your best bet, but...

    Puto me cogitare, ergo puto me esse.
    I think that I think, therefore I think that I am.

    April 10, 2008 at 7:37 am

    #800977

  • RE: Largest Unit

    Derek Dongray (4/4/2008)

    No, there is only one type of person in the world: those who count.

    Except of course for Democrat primary voters in MI and FL. :hehe:

    Puto me cogitare, ergo puto me esse.
    I think that I think, therefore I think that I am.

    April 4, 2008 at 10:00 am

    #798555

  • RE: Largest Unit

    Shaun McGuile (4/4/2008)

    Aleksandr Furman:

    How is that funny?

    Is that not the truth? 😉

    Like the one told to me by an accountant;

    "There are three types of accountant in this world, those...

    Puto me cogitare, ergo puto me esse.
    I think that I think, therefore I think that I am.

    April 4, 2008 at 9:20 am

    #798522

  • RE: Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5

    Ridiculously late addendum, but Cute-PDF is free and has worked wonderfully for me so far, at least with things that are properly formatted for printing, it chokes a bit on...

    Puto me cogitare, ergo puto me esse.
    I think that I think, therefore I think that I am.

    April 1, 2008 at 11:16 am

    #796723

  • RE: Writing Faster T-SQL

    Jeff Moden (3/31/2008)

    On the "Persists" disadvantage, I kinda of agree if the sproc is big and the Temp table is used only at the beginning. I just want everyone...

    Puto me cogitare, ergo puto me esse.
    I think that I think, therefore I think that I am.

    April 1, 2008 at 6:57 am

    #796434

  • RE: SQL Sleep

    If only the fact that my hands weren't on the keyboard wouldn't give me away...

    Puto me cogitare, ergo puto me esse.
    I think that I think, therefore I think that I am.

    April 1, 2008 at 6:38 am

    #796419

  • RE: Writing Faster T-SQL

    Daniel Wilson (5/22/2007)

    thanks for the intro to CTE's! I know I've written the same SELECT statement into 2 parts of a query before. No more ... ah ......

    Puto me cogitare, ergo puto me esse.
    I think that I think, therefore I think that I am.

    March 31, 2008 at 7:22 am

    #795915

  • RE: Query Cost v. Execution Time

    I'm having a hard time grasping the significance and nature of cost. Would it be accurate to say that the cost is representative of the extent to which it...

    Puto me cogitare, ergo puto me esse.
    I think that I think, therefore I think that I am.

    March 19, 2008 at 6:48 am

    #791407

  • RE: Common Table Expressions

    Jeff Moden (3/18/2008)

    And then you better make sure you run the code more than once, even on a quiet system...

    I did three runs in one order, and two runs with...

    Puto me cogitare, ergo puto me esse.
    I think that I think, therefore I think that I am.

    March 18, 2008 at 3:03 pm

    #791143

  • RE: Common Table Expressions

    69.5% of the total batch cost for the derived table method according to the execution plan, but only 31.8% of the runtime (according to the getdate() queries I inserted at...

    Puto me cogitare, ergo puto me esse.
    I think that I think, therefore I think that I am.

    March 18, 2008 at 12:18 pm

    #791043

  • RE: Common Table Expressions

    Jeff Moden (3/18/2008)

    If the underlying tables are correctly indexed, the CTE or Derived Table will use it... creation of the index on the temp table may take longer than...

    Puto me cogitare, ergo puto me esse.
    I think that I think, therefore I think that I am.

    March 18, 2008 at 10:40 am

    #790977

  • RE: Common Table Expressions

    I'll stick to indexed temp tables for self-links then. (The base table used in this process has around 300k rows)

    Puto me cogitare, ergo puto me esse.
    I think that I think, therefore I think that I am.

    March 18, 2008 at 10:05 am

    #790950

  • RE: Common Table Expressions

    Is it possible to put an index on the CTE? I ask because we're moving to SQL Server 2005 in 4Q 08, and I have more than a few...

    Puto me cogitare, ergo puto me esse.
    I think that I think, therefore I think that I am.

    March 18, 2008 at 9:54 am

    #790937

  • RE: Why Object Qualification is important.

    sjsubscribe (3/10/2008)

    Do you have difference lookup tables in the same database with different owners, or are they owned by dbo but in different databases/on different servers?

    Yes.

    Are you saying that...

    Puto me cogitare, ergo puto me esse.
    I think that I think, therefore I think that I am.

    March 10, 2008 at 12:23 pm

    #787532

  • RE: Why Object Qualification is important.

    sjsubscribe (3/10/2008)

    Well, good advice if you're dealing with one server and single schemas or need to optimize for in specific instances. But if you're writing procedures that need to run...

    Puto me cogitare, ergo puto me esse.
    I think that I think, therefore I think that I am.

    March 10, 2008 at 11:28 am

    #787516

Viewing 15 posts - 61 through 75 (of 83 total)