Viewing 15 posts - 53,881 through 53,895 (of 59,065 total)
Um... no, I don't think so... a Mega byte is a binary million bytes, not a binary thousand.
Convert from Bytes to KBytes by dividing by 1,024.
Convert from Bytes to MBytes...
November 27, 2007 at 9:10 pm
I need this to be a single create statement.
Why?
November 27, 2007 at 8:59 pm
Ananth,
Are you all set with your running total problem? Was the link that Andras provided sufficient or do you need something a bit more specific? Just wanna make...
November 27, 2007 at 8:16 pm
karthikeyan (11/27/2007)
Jeff,Gathering Running total only is not my job. Really i am trying to give answers which comes under my knowledge.
for your reference,;)
----------------------------------------------------------------
http://www.sqlservercentral.com/Forums/Topic425244-169-1.aspx
----------------------------------------------------------------
Sounds a bit arrogant, Karthik... perhaps it's the...
November 27, 2007 at 8:15 pm
No-one has suggested writing a VBS file using ADO to loop through the recordset writing to a file at each iteration
The reason I've not suggested such a thing is that...
November 27, 2007 at 8:09 pm
What does change is I pull a subset of the columns (50-70%) and modify their datatype and/or...
That would be part of the reason why things take so long... why...
November 27, 2007 at 8:07 pm
If it's within the same proc, yes... I'll many times use a temp table with indexes, etc. If there are several procs that require the same process, I'll build...
November 27, 2007 at 8:04 pm
OMG! ROFLMAO! Just when I stopped laughing at this, I laughed again! Way too funny! Lordy, I love dry humor! Thanks for making my day,...
November 27, 2007 at 5:43 pm
What? Oh? OH? OOOOOHHHHH!!! BWAAAA-HAAAAAA-HAAAAA! WHOOOOO-IIIIEEEEEE! SNNOORRRTTT! Now, THAT's funny, David!!!! OMIGOD!!! I CAN'T QUIT LAUGHING!!!! TOO FUNNY,...
November 27, 2007 at 5:32 pm
Karthik,
No... that's what a lot of folks do and it's not database design. For starters, each table should have a primary key (as well as having a clustered index...
November 27, 2007 at 5:24 pm
Actually... I like VSS. No, it won't merge your code for you or handle branches, etc, etc. But guess what? I'm not a Java programmer! 😉
If people...
November 27, 2007 at 4:49 pm
Thanks for the feedback, John! Yeah, same thing here... sometimes the language barrier is a bit difficult to get through, but a well formed Create Table statement cut's through...
November 27, 2007 at 4:42 pm
Jason Selburg (11/27/2007)
Lynn Pettis (11/27/2007)
Actually, more than read the article, take it to heart and follow its example! You know what they say about leading a horse to water...😎
....You're...
November 27, 2007 at 11:27 am
Steve Jones - Editor (11/27/2007)
I think I'll re-run this once a month or so to...
November 27, 2007 at 11:25 am
Wow! So many great comments and ideas... I can't keep up with all the posts! Thank you all for taking the time out of your busy day to...
November 27, 2007 at 11:19 am
Viewing 15 posts - 53,881 through 53,895 (of 59,065 total)