Viewing 15 posts - 48,556 through 48,570 (of 59,065 total)
Haven't done a performance comparison, but I wouldn't be surprised if your all math solution were faster than just about any string solution including the one I posted.
August 26, 2008 at 6:39 pm
Instead of using EXEC... use PRINT(@Query) and post the result, please.
August 26, 2008 at 6:36 pm
Thanks for the code and the write up... it's exactly what I was afraid of though. In your example just for layer #1, if you have a million rows...
August 26, 2008 at 6:33 pm
gan (8/26/2008)
Jeff Moden (8/25/2008)
August 26, 2008 at 6:21 pm
MrBaseball34 (8/26/2008)
I make a copy to a tempfilename passed into the procedure and then if there is an...
August 26, 2008 at 6:09 pm
All those are well and good, but the OP still hasn't provided an answer to the question of which numeric field (or both) to sort on for some of the...
August 26, 2008 at 6:04 pm
sg (8/26/2008)
Thanks for ur reply. I am an asp.net developer, not a dba :rolleyes: but still i have a good knowledge on db.
I have used joins on...
August 26, 2008 at 6:01 pm
Sorry... new job has kept me busy... I think I may have a solution soon. Yep, I know you already have one using REPLACE on the quotes... there's just...
August 26, 2008 at 5:56 pm
developer6 (8/26/2008)
August 26, 2008 at 5:50 pm
swtrans (8/19/2008)
C1 C2 C3 C4
110 99...
August 26, 2008 at 12:47 pm
Start with using Visio to reverse engineer a diagram of the database... hopefully, they actually used Foreign Keys...
August 26, 2008 at 12:42 pm
Hi Jim,
Indexes also count towards the size of the mdf. If you have wide indexes and a clustered index along with "fk" indexes, the size of your indexes can...
August 26, 2008 at 12:39 pm
Even if you concatenate and convert to text using something like...
[font="Courier New"]SELECT CAST('1'+'2'+'3' AS TEXT)[/font]
...you still won't be able to see more than 8192 characters in a single column, view...
August 26, 2008 at 9:53 am
Robert...
I know it's been over a year since this article came out, but want to say what an outstanding article you've written... very easy to read and great examples!...
August 26, 2008 at 9:42 am
Viewing 15 posts - 48,556 through 48,570 (of 59,065 total)