Forum Replies Created

Viewing 15 posts - 1 through 15 (of 306 total)

  • RE: Looking for clean way to aggregate the same column multiple times in my query

    Absolutely - anything is possible I was just looking for clean and efficient.

  • RE: How do you avoid dynamic SQL with this code?

    GSquared (6/10/2011)


    It would look something like this:

    --

    You could add more error handling to the SET statements for @SDate and @EDate if you expect non-date values to be assigned to those...

  • RE: How do you avoid dynamic SQL with this code?

    CELKO (6/10/2011)


    This is awful non-SQL. This is what OO programmers do to fake pointer chains, and not learn SQL. I would throw the whole damn thing out.

    Thank you...

  • RE: How do you avoid dynamic SQL with this code?

    Crispin Proctor (6/10/2011)


    GSquared (6/10/2011)


    I don't see any reason for this to be dynamic at all.

    What he said -

    I've not often seen a valid reason for dynamic sql. If yours...

  • RE: How do you avoid dynamic SQL with this code?

    GSquared (6/10/2011)


    I don't see any reason for this to be dynamic at all.

    My first thought was complex search querying, but it seems to be just two input parameters (start and...

  • RE: 16 disks Best config design!>

    What SAN are you using?

    What are the size / speed of the drives you are using?

    What Win/SQL platform are you building this for?

    What is business need of...

  • RE: Fragmented index

    opc.three (6/2/2011)


    Ever get to the bottom of it?

    I've been working with the client to cleanup the schema. Short answer is no, but I've reduced my work load so the reindexing...

  • RE: Fragmented index

    john 50727 (5/27/2011)


    Can you modify the table? Where I work, I have complete control of the database. I would separate the key out to three different fields and use a...

  • RE: Fragmented index

    opc.three (5/25/2011)


    Hmm...running out of ideas...

    Are the 3-byte "table prefix char(15)" always used in a sequential order? i.e. Could you possibly load a batch with a prefix of "xyz" before a...

  • RE: Fragmented index

    Ninja's_RGR'us (5/25/2011)


    I'm no SSIS guru but I know this for sure, you can commit the whole process in batches and unless you specifically ask for an ordered insert you won't...

  • RE: Fragmented index

    opc.three (5/25/2011)


    OK...so much for that...

    What about Ninja's thought...are the rows being updated in the table after they are initially inserted?

    No they're loaded in directly as is.

  • RE: Fragmented index

    opc.three (5/25/2011)


    <mini_rant>The use of GUID for this entity is a misnomer in the context of Microsoft SQL Server so I am calling them IDs from now on because the terminology...

  • RE: Fragmented index

    Okay - I have an update on how this GUID column is generated.

    On a seperate database we have a table with columns

    1) table prefix char(15)

    2) Sequence_no...

  • RE: Fragmented index

    There's only one index the cluster index on the table.

    PRIMARY KEY CLUSTERED

    ([Guid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE =...

  • RE: Fragmented index

    The data commits after every 5K records each record populates 5 tables. I have other tables in using a similiar ID but along with a date as a PK and...

Viewing 15 posts - 1 through 15 (of 306 total)