Forum Replies Created

Viewing 15 posts - 796 through 810 (of 8,731 total)

  • RE: Alternative to a table valued function in SQL Server

    It's hard to believe that changing it to an inline table-valued function won't improve performance. You could check the fact that you're using UNION that sorts and eliminate duplicates instead...

    December 6, 2017 at 1:47 pm

    #1971057

  • RE: Order of the columns while creating an index

    Lynn Pettis - Wednesday, December 6, 2017 11:48 AM

    Determining whether I need a non-clustered index or a clustered index (there can be...

    December 6, 2017 at 11:59 am

    #1971008

  • RE: FAST_FORWARD cursor slow for simple SELECT COUNT(*) because sp_cursorfetch() re-scans all index

    sf 49675 - Tuesday, December 5, 2017 11:57 AM

    Maybe there is some option in sp_cursorprepexec() to force to fetch the first...

    December 5, 2017 at 12:06 pm

    #1970774

  • RE: FAST_FORWARD cursor slow for simple SELECT COUNT(*) because sp_cursorfetch() re-scans all index

    sf 49675 - Tuesday, December 5, 2017 10:41 AM

    Hi all,

    We are using MS ODBC 13 (on Linux) to execute a simple SELECT...

    December 5, 2017 at 11:25 am

    #1970767

  • RE: Query Help -

    Lynn Pettis - Tuesday, December 5, 2017 9:43 AM

    Luis Cazares - Tuesday, December 5, 2017 9:34 AM

    December 5, 2017 at 9:54 am

    #1970761

  • RE: Query Help -

    Lynn Pettis - Tuesday, December 5, 2017 9:17 AM

    That would have to be one hell of a long piece of dynamic...

    December 5, 2017 at 9:34 am

    #1970753

  • RE: Query Help -

    Thom A - Tuesday, December 5, 2017 1:54 AM

    Lynn Pettis - Monday, December 4, 2017 4:33 PM

    December 5, 2017 at 8:48 am

    #1970734

  • RE: Problem with SQL Stored Procedure

    MarkW.Rhythm1 - Tuesday, December 5, 2017 7:06 AM

    Sue_H - Monday, December 4, 2017 5:12 PM

    December 5, 2017 at 7:25 am

    #1970710

  • RE: what should i do to become a DBA

    afmatix - Tuesday, December 5, 2017 3:14 AM

    Sorry to resurrect this old thread but I have the same questions as raviveesha...

    December 5, 2017 at 6:27 am

    #1970694

  • RE: "CASE" function on t sql

    You're declaring variables instead of parameters. You'll simply insert null values.

    December 4, 2017 at 9:36 am

    #1970556

  • RE: Sorting after records deleted

    webskater - Monday, December 4, 2017 6:08 AM


    CREATE