quote:

---

I don't think there's much difference between the two, because SQL Server actually creates a clustered index to enforce a clustered unique...

You said the server has 3.6 GB RAM.If SQL uses 1.6 GB then Windows would have 2 GB, or am I missing something? I would advice you to stick with...

Although there are ways to simulate arrays in SQL Server, the best advice and solution imho would be to think about whether you really need an array. Often you are...

create view mostrecent

as

select shipmentid, status, date

from shipments a

inner join (

select shipmentid, max(date) as maxdate from shipments

group by shipmentid

) b

on a.shipmentid = b.shipmentid

and...

The solution you describe sounds good. If you want to avoid the join you could of course use a column "prodCondition" with a check constraint to make sure that only...

select * from sysobjects where uid <> 1

--

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

http://www.sql.nu

select @a = a, @b-2 = b from table

--

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

http://www.sql.nu

quote:

---

well Oracle runs on UNIX ... that's the major difference.

MS SQL Server doesn't.

If only they had been ordered to be split from...

Aha, you only installed the client tools? Then you need the database engine as well, and you are quite right about Enterprise Edition, you must use Devleoper Edition on XP...

Why do you not want to change it? The float data type is for storing approximations and uses scientific notation to store the values. You will never be able to...

Then you should not use float, use something like decimal(9,2) instead.

--

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

http://www.sql.nu

Tom, very nice. Didn't think of that at all. Remember though that sp_addalias is only there for backward-compatibility so it might be removed.

--

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

http://www.sql.nu

quote:

---

It is already explicitly sorted 🙂

---

Just to continue this interesting thread, here is what Dr...

quote:

---

You could make the developers owners of your development DB and eliminate this maintenance need for the future.

---

--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/