I coudn't find anywhere in that docs references to licenses for training and non development QA environments.

Thank you very much for this article, it helped me a lot few years ago when I had to install my first cluster.

I think it would be also interesting to...

I will start doing some testing once I will get the test server and see how many SPs are touched by users, maybe it would be indeed a small number...

Thanks, your suggestion to not use under any circumstance SQL instances make me start reconsidering the entire SQL architecture that I had in mind.

I was kind of assuming that...

Thanks man, this is really helpfull.

From what I understand, you haven't used several instances to hold these number of database, just the default one, right?

Microsoft Dynamics, all databases have the same set of SPs.

There is a benchmark done by MS for 4000 DBs on the same box. It seems to point to a max...

Thanks, I am working to implement a software package that creates a database per client, with a target of more then 1500 clients.

From what I found so far the...

Thanks Janet

I am running

select * from sysindexes order by rowcnt desc

and the rowcnt (number of data rows in the tables) is

11158707 syscolumns

10191652 sysobjects

10191511...

Hi Luke,

Thanks for reply, I can take a look and see what users are doing, but regardless of what they are doing once a transaction is ended the checkpoint process...

Was your question in regards to the size of the log file not shrinking and the database log_reuse_wait_desc been REPLICATION?

Check Inside Microsoft SQL Server 2005 T-SQL Querying by Itzik Ben-Gan - there are a few solution for this issue, some for 2000, some for 2005.

Have you guys tried to debug the issue with the software vendor?

Have you run the DBCC CheckDB in Query Analyzer and see the output?

In my opinion 5 years should be a good interval.

-it takes about 6 months after the release to get the first service pack, after that I start thinking of installing or upgrading...