Viewing 15 posts - 50,986 through 51,000 (of 59,078 total)
Never mind... I got it from one of the posts above... just to make sure, you're using this from one of Gus' posts?
create table NumberClean (
Number bigint,
Clean varchar(100))
go
set nocount on
set...
April 22, 2008 at 8:17 pm
So, in the million and 4 million row tests, what does your table and data look like? Are you just making a table with a Primary Key and a...
April 22, 2008 at 7:43 pm
Thank you for the compliment, Chirag... but you're giving me too much credit. The key phrase was "consumes the larger part of a 60 GB drive. There are...
April 22, 2008 at 7:30 pm
Sorry Martin, I'm going to have to bow out... I don't know much about the reporting tools.
April 22, 2008 at 7:17 pm
Ok, so just write the function and use it in that...
April 22, 2008 at 7:11 pm
mailsar (4/22/2008)
When i logged on to SQL server central, there were different groups. I was confused into which group shud i post this question. I found 2 groups which...
April 22, 2008 at 7:08 pm
mailsar (4/21/2008)
GSquared,U really made me think. Yep i do agree with you on storing the entire record in XML is a good idea.
Think a bit more... if...
April 22, 2008 at 7:00 pm
Then, you need to trace the source to the root cause.
April 22, 2008 at 6:49 pm
GSquared (4/22/2008)
I would definitely avoid that "speed at all cost" methodology.
Heh... then why have you posted so much on this thread about speed? 😉 The real answer is that...
April 22, 2008 at 6:41 pm
Yes, you can include the last ELSE with a function. I wanted you to post the CREATE TABLE statement so I could build something to it to show you...
April 22, 2008 at 6:41 am
DB2 date/times are much different than SQL Server (if memory serves me)... I believe they're based on something like the number of seconds since midnight 1970-01-01. You will need...
April 21, 2008 at 6:55 pm
It's really a PITA when folks double post... have a little forum courtesy, please.
http://www.sqlservercentral.com/Forums/Topic487503-338-1.aspx
April 21, 2008 at 6:41 pm
mailsar (4/21/2008)
Yep i do agree with you on storing the entire record in XML is a good idea
Gooed! Hope you don't mind your audit table being 16 times the...
April 21, 2008 at 6:39 pm
Sure... post the CREATE TABLE command where you want the calculated column.
April 21, 2008 at 6:18 pm
Viewing 15 posts - 50,986 through 51,000 (of 59,078 total)