Viewing 15 posts - 1,681 through 1,695 (of 2,171 total)
It depends on your business rules of which records to remove.
April 10, 2007 at 8:31 am
If you only are trying to remove the TIME PART information, try this
SELECT DATEADD(DAY, DATEDIFF(DAY, 0, YourDateTimeColumnHere), 0)
April 10, 2007 at 7:34 am
10% of 500GB is still 50GB, which MS Access is not designed for.
Even only 1% of the records would still be 5 GB, which is still too much for MS...
April 10, 2007 at 7:30 am
This will get you an start
-- Prepare sample data
declare
@DataTable table (UniqueKeyColumn1 varchar(20
April 10, 2007 at 5:52 am
select left (cast(M.[School Type] as varchar(55)), 1)...
April 10, 2007 at 1:25 am
Yikes! You can't rely on BINARY_CHECKSUM because it is not that unique you can expect!
See http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=70832
April 9, 2007 at 10:59 pm
It is 2 times.
I average about 1.1 seconds for 11,000 test values with my suggestion and average about 2.3 seconds for you original code.
Strange, I can't calculate simple percentage
April 9, 2007 at 6:26 pm
Thank you!
I think we had the same discussion for the Luhn algorithm, right?
With the @Multiple variable...
April 9, 2007 at 5:47 pm
Collation is set per DATABASE default, or that particular column?
April 9, 2007 at 5:31 pm
I found the error!!!
Replace RETURN line of
RETURN SIGN(@BigValue) * @Mantissa *...
April 9, 2007 at 5:26 pm
I took my old VB function and adapted according to your code (11-bit exponent and all), and it performs 3 times faster than your original code.
BUT (drawback here)... There seems to be...
April 9, 2007 at 4:56 pm
Great work Jeff!
An excellent candidate for the Script Library!
April 9, 2007 at 2:38 am
Which account did you supply to start the services?
Has that account permissions to start a service?
April 9, 2007 at 2:20 am
You can CAST a BINARY(8) to BIGINT, if that helps out with bit checking later...
April 8, 2007 at 1:45 pm
Viewing 15 posts - 1,681 through 1,695 (of 2,171 total)