Viewing 15 posts - 1 through 15 (of 307 total)
Absolutely - anything is possible I was just looking for clean and efficient.
John Zacharkan
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...
John Zacharkan
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...
John Zacharkan
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...
John Zacharkan
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...
John Zacharkan
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...
John Zacharkan
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...
John Zacharkan
June 2, 2011 at 3:28 pm
john 50727 (5/27/2011)
John Zacharkan
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...
John Zacharkan
May 26, 2011 at 12:16 am
Ninja's_RGR'us (5/25/2011)
John Zacharkan
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.
John Zacharkan
May 25, 2011 at 10:54 pm
opc.three (5/25/2011)
John Zacharkan
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...
John Zacharkan
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 =...
John Zacharkan
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...
John Zacharkan
May 25, 2011 at 11:17 am
Viewing 15 posts - 1 through 15 (of 307 total)