Forum Replies Created

Viewing 15 posts - 511 through 525 (of 562 total)

  • RE: Index usage and RID lookup.

    GilaMonster (1/7/2013)

    No. It reads all rows from the index where A=6, filters them as it reads for C =7. Once it has all rows that match all conditions that have...

    January 7, 2013 at 8:10 am

    #1574330

  • RE: Index usage and RID lookup.

    Lynn Pettis (1/7/2013)

    Your code still only runs the test code for one of the indexes not both. If I want the execution plans for the queries using the clustered...

    January 7, 2013 at 8:08 am

    #1574328

  • RE: Index usage and RID lookup.

    Lynn Pettis (1/7/2013)

    Taking a closer look at your code I see that now. You tell us to run your code from further below. Sorry, I missed that. ...

    January 7, 2013 at 7:24 am

    #1574300

  • RE: Index usage and RID lookup.

    Lynn Pettis (1/7/2013)

    You index is a clustered index meaning that both queries use the clustered index.

    The code for a Heap situation is included in the code as wel.

    I should have...

    January 7, 2013 at 6:50 am

    #1574286

  • RE: Cluster design comment wanted.

    I wouldn't worry too much about it. While all a client's rows may be logically located together, after these page splits they'll be physically dispersed on disk and in less-than-full...

    January 4, 2013 at 7:11 am

    #1573735

  • RE: Cluster design comment wanted.

    opc.three (1/3/2013)

    Please post the table definitions including all indexes and constraints.

    I have been working on the table definitions.

    I do not wish to post the complete definition,

    1 because of the...

    January 4, 2013 at 4:17 am

    #1573677

  • RE: Cluster design comment wanted.

    opc.three (1/3/2013)

    The clustered indexes you chose for ClientOrder and ClientLine are not ever-increasing

    I am sorry I was not clear with my description. I meant that the indexes are ever increasing...

    January 3, 2013 at 11:23 am

    #1573420

  • RE: Progress of a maintenance action?

    sanket kokane (12/7/2012)

    Do you mean Clustered Index ?

    http://www.sqlservercentral.com/stairway/72399/

    Yes,

    (Yes 'adding' or 'removing' a clustered index).

    (Or even doing a simple update off one field over the whole table).

    Ben

    At this moment I...

    December 7, 2012 at 5:27 am

    #1566569

  • RE: Removing constraints for performance.

    David Benoit (10/26/2012)

    Also may want to check out THIS ARTICLE[/url] from this site.

    Thank you for the reference to this article. This is what I was looking for.

    With google I did...

    October 29, 2012 at 11:22 am

    #1553834

  • RE: Removing constraints for performance.

    GilaMonster (10/26/2012)

    Constraints can and do help performance. Unique constraints may allow SQL to ignore DISTINCT operations or reduce group by statements to simpler forms or know absolutely for sure how...

    October 26, 2012 at 6:59 am

    #1553143

  • RE: Searching in stored procedures.

    Thanks Michael L.John,

    I saved that script, it's usefull.

    (For my purpose, it only gives the first occurencen of a string and I want the occurence where the field is compared. So...

    October 11, 2012 at 9:35 am

    #1548209

  • RE: Searching in stored procedures.

    deepkt (10/11/2012)

    Hi ,

    You can also use below queries :

    SELECT DISTINCT OBJECT_NAME(id) FROM SYSCOMMENTS WHERE text like '%search key%'

    SELECT ROUTINE_NAME, ROUTINE_TYPE FROM INFORMATION_SCHEMA.ROUTINES where ROUTINE_DEFINITION like'%search key%'

    I did not use Routines,...

    October 11, 2012 at 7:53 am

    #1548126

  • RE: A quick query puzzle:

    A small change See in the code.

    (My reason for this change change is: The essential part of the code is only written once, so it is smaller, clearer and with...

    October 8, 2012 at 2:02 pm

    #1546907

  • RE: The maximum length of strings. (Varchar(max)).

    Thanks Artoo22 and GSquared,

    Tried the XML but this result in error, as described by GSquared. (this looked promising to me).

    If there are no problems with functions and operations like REPLACE,...

    October 8, 2012 at 8:52 am

    #1546769

  • RE: The maximum length of strings. (Varchar(max)).

    GSquared (10/8/2012)

    The problem will be the UI, not varchar(max) nor replace().

    SSMS, for example, will cut off at 8k characters, when it's displaying the data.

    Thanks,

    Now I only have to build...

    October 8, 2012 at 8:01 am

    #1546737

Viewing 15 posts - 511 through 525 (of 562 total)