alter database <YourDatabaseName>

modify file(name='<YourDatabaseName>',size=<MinimumSizeWanted in MB>,filegrowth=<Growth in MB or num% for percent growth>)

From what you've mentioned - it sounds like you would in fact need 1 server+30 CAL's. should be quite a bit cheaper than any of the processor licenses....

Antares686 (10/29/2007)

---

Matt Miller (10/29/2007)

---

For what it's worth - according to several MS case studies - the best performance during a big ETL load like that is achieved when all indexes...

you should be also skipping the quotes in the main select part, i.e.

SELECT SCHOOLID, [Elementary] As Elementary, [SBA] As SBA, [Secondary] As Secondary FROM

...

That must be because the value ce_individual_license_ext.ixl_expire_date_ext

is a DATETIME field. So - convert it to a varchar(50) so that you can get your error message in there.

i.e.

select

custid,

Case

when ce_individual_license_ext.ixl_expire_date_ext

is not...

Stephen - unless you override the ANSI NULLS setting (which is not recommended), any arithmetic comparison to NULL is false. so

a=NULL ---> FALSE

A<>NULL --->FALSE

A>NULL --->FALSE, etc....

Just about the...

If you're doing both installs as "default" instances - it's inferring from the name that you're asking it to upgrade. Meaning you can only have one default instance of...

It looks to me that it's stuck thinking it's an evaluation copy. It that's the case, this needs to be reinstalled/upgraded with a non-evaluation copy of the software.

..Which you can achieve by NOT specifying the reseed value.

In other words -

DBCC CHECKIDENT ('dbo.mytable', RESEED,1) --first, reset to 1

DBCC CHECKIDENT ('dbo.mytable', RESEED) --then, reset to max...

Greg Snidow (10/29/2007)

---

Could someone, maybe in laymens terms, explain how you are testing these queries. This is something with which I have never been concercned because my tables are...

...except that you haven't defined an actual join criteria. This is a full CROSS join, or cartesian product as it's called. Every row of table1 is joined to...

For what it's worth - according to several MS case studies - the best performance during a big ETL load like that is achieved when all indexes EXCEPT the clustered...

Well - you could start with pointing out that they are running WAY under the recommended amounts (of RAM in particular) for 2003 + SQL 2000.

Just to "keep the lights...

Look to me that they're looking to extract 5 year's worth of info?

Loner (10/26/2007)

---

The data structure, the primary key, the index are all belonged to the database side. Of course if you put in foreign key, trigger to enforce data integrity,...