You mention that a lot of customers will use SQL Express with your application.

I think the capabilities of SQL Express should form part of the design limits on your application....

Those data types are still used by some SQL Server internal processes. Until these get rewritten I think they will stay in the product. They could disappear with...

This link gives you an outline of what you need to do to use AWE effectively: http://sqlserverfinebuild.codeplex.com/wikipage?title=SQL%20Server%20Memory%20Management

SQL 2008 Enterprise should handle that workload, but will you be able to manage that server?

I suggest you look at partitioning of tables, and how these would help query performance...

Do you have SQL Browser started? If not then you will need to add a port number to your connection string, eg 10.10.10.10\SQL1:5133

It is worth looking at SQL 2014 column-store and in-memory tables. These should give a similar level of performance to SSAS, but could significantly reduce the amount of ETL...

Column-store, in-memory, and tabular are all about how the data is physically stored. You may also see people talking about shared-nothing and shared-disk, which is also about how...

The future for data warehousing is column-store and in-memory tables. Most organisations with a BI store of under 2TB will not need to bother with complexities such as SSAS...

One of the things you are doing with a large number of physical files is forcing SQL Server to use at least one IO stream per file (assuming all files...

So your organisation has a non-employee installing software on company machines. IMHO not a good situation.

At the very least you can organise a meeting with your manager, the manager...

So you have a database that is saying it is corrupt, you have no certain way of knowing that you are not making the corruption worse because you are still...

SP2 for SQL 2008 R2 went through a CTP stage before it was released. It seems you have got the CTP version of SP2 installed.

If it were my system...

It surprises me that C2 auditing is still being requested. The underlying standard that C2 forms a part of started to become obsolete in 1993 and has been replaced...

This should work.

At my place it is not unusual for the publisher and distributor to be at a lower SQL version than some of the subscribers. We are currently...

Gail's code looks like it might work 🙂

I am out of office until Monday 10 and will check it out then. Thanks for the suggestion!

BTW, Buffer Pool Extension is...