Thanks Jonathon, that's one more thing to figure out how to make work!!! 

When you install SQL2K on a cluster of two nodes (say NodeA and NodeB), you install it onto a virtual server. If you are in Active/Active mode, you will have...

I am about to get a new server with 5Gb RAM. It will be a dedicated SQL box with W2K-AS and SQL2K-EE installed. I have used the /3GB switch before...

Where do I start???

VFP has superb (and blindingly fast) native handling of data with its in-built data engine, so you can do a lot of post-processing on the client, taking...

Been there, done that... in my case way back in the days of VFP3, and I still find VFP (now VFP8) the best front...

From my recollection, the crash dump files are put in the same folder as the SQL Error logs (ie ..\Program Files\Microsoft SQL Server\MSSQL$instancename\LOG

or ..\Program Files\Microsoft SQL Server\LOG...

Just as well you pointed out the difference between Bytes and bits or I wouldn't have been leaving much memory free!!! 

Thanks Jonathon, that's really helpful

Checking in BOL suggests that restarting SQL with the default -g switch will make it reserve 256Mb, giving me another 150Mb for the memory pool. But...

I have a W2K-Advanced Server/SP3 machine (in an active/passive cluster) with 3584Mb RAM with the /3Gb switch set. The SQL2KEE/SP3 only uses 2.6Gb, and the OS is only using another...

It is refreshing and really encouraging to lesser mortals to see SQL Gurus using this forum to ask for help as well as dishing it out!

Tony Bater

I have run this on both development and production databases, and allowed it check all of the available 'best practices'. It was good to see the db's passed on many...

<...adding the Date field to the "many" table would not be an effective solution, as that data would be redundant, not to mention irrelevant, in that table...>

I can't see why...

quote:

---

quote:

---

Looking for some good input here 🙂

---

You...

MAybe there is no error. Perhaps it is going to take a long time!

Try noting the time it takes to run just a small part of the update (perhaps 1%)...

You need to embed the quoted constants within another pair of single quotes:

CREATE VIEW dbo.vw_test

AS

SELECT * FROM OPENQUERY(TEST,'Select * from customer where state = ''AL'' ')

GO

Tony Bater