Viewing 13 posts - 1 through 13 (of 13 total)
Dropping indexes does sounds like idea...
drop, shrink, rebuild indexes...
September 13, 2010 at 5:28 pm
Detach/ReAttach won't help without a new drive to work with.
But here's some reasons why detach/reattach can help with new drive:
1 reason: With the file manipulation recommended, you should at least...
September 12, 2010 at 10:30 pm
It sounds as if will need 125GB's * .20 = 25GB's for a new datafile.
If this is too tight of space available. Then I would recommend you add a drive...
September 12, 2010 at 10:09 pm
How much is the free space on drive in GB/MB's?
September 12, 2010 at 9:55 pm
How many datafiles are in this database (not including log files)?
How much free space do you have on drive?
How space is the entire database taking ?
How much space is allocated...
September 12, 2010 at 9:04 pm
Try increasing the allocated size of your 1st datafile.
September 6, 2010 at 11:11 pm
OTHER THOUGHTS:
You may want to try importing the whole file into SQL as 1 field VARCHAR(whateveryourmaxrecordlength).
Or Maybe parse out the first few fields if they can be used as...
January 23, 2008 at 3:35 pm
"WHEN a.order_id not in (select order_id from settlement) THEN"
the correct syntax for this might be:
WHEN (select order_id from settlement where order_id=a.order_id) IS NULL THEN...
keep in mind that this will generate...
March 6, 2007 at 8:20 am
--Without knowing more details, here's a starting point...
--though I agree that VB on front end is probably more straight
--forward...
SELECT
C1,C2,C3
December 28, 2006 at 9:11 am
From the sample data I couldn't figure out why an invoice would have a null transactionID.
But anyways, I ran your script schemas, populated with your data, and
adjusted and ran...
December 19, 2006 at 7:52 am
modified to fix two typos (fieldnames), and show the amount due column:
SELECT
INVOICES.CustomerID,
INVOICES.ARDate,
December 15, 2006 at 8:48 am
If the invoice is for 890 looks like only 190 should be due on this invoice.
(With 300 unapplied credit unless it was applied in its entirety to other...
December 15, 2006 at 8:31 am
Haven't tried it out yet, but just read your article. Cool Concept!
Thanks for sharing, will give it a whirl.
-CG.
July 26, 2006 at 6:19 am
Viewing 13 posts - 1 through 13 (of 13 total)