Viewing 15 posts - 1 through 15 (of 306 total)
Absolutely - anything is possible I was just looking for clean and efficient.
July 23, 2013 at 3:39 pm
GSquared (6/10/2011)
--
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...
June 15, 2011 at 2:14 pm
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...
June 15, 2011 at 2:06 pm
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...
June 10, 2011 at 9:02 am
GSquared (6/10/2011)
My first thought was complex search querying, but it seems to be just two input parameters (start and...
June 10, 2011 at 8:31 am
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...
June 10, 2011 at 7:11 am
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...
June 2, 2011 at 3:28 pm
john 50727 (5/27/2011)
May 28, 2011 at 11:24 am
opc.three (5/25/2011)
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...
May 26, 2011 at 12:16 am
Ninja's_RGR'us (5/25/2011)
May 26, 2011 at 12:12 am
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.
May 25, 2011 at 10:54 pm
opc.three (5/25/2011)
May 25, 2011 at 2:52 pm
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...
May 25, 2011 at 12:12 pm
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 =...
May 25, 2011 at 11:31 am
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...
May 25, 2011 at 11:17 am
Viewing 15 posts - 1 through 15 (of 306 total)