Forum Replies Created

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

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

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

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

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

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

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

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

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

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

  • RE: A quick query puzzle:

    Hello all,

    Because I goofed a bit in my previous solution here the worked out code.

    It's a solution which only used simple replaces, not efficient (lots of updates).

    ben brugman

    -- Ben Brugman

    --...

  • RE: Database to hold/keep scripts.

    bitbucket-25253 (10/5/2012)


    I have what I call a sandbox DB to hold scripts, some T-SQL and have it set up so as to be able to search by key words, for...

  • RE: Database to hold/keep scripts.

    Sqlfrenzy (10/5/2012)


    you can use a version control tool for it.

    Thanks for your anwser.

    To my knowledge (I know VSS and TFS) version control tools can only store versions of files. At...

  • RE: A quick query puzzle:

    With a large amount of replaces this can be done.

    Problem is that the number of replaces is very large.

    So I'll show the concept but not the code, because the code...

  • RE: A quick query puzzle:

    With a large amount of replaces this can be done.

    Problem is that the number of replaces is very large.

    So I'll show the concept but not the code, because the code...

  • RE: Puzzle : Generating two unique numbers from an array of numbers (repetation not allowed)

    ScottPletcher (9/17/2012)


    Yes, but not unfairly so; the values I used are always inherent in the problem. In order to solve the problem, you must know at least one of...

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