The SQL Server install will always add about 3.5GB of files to the system drive. Most of these go into the GAC, which can only exist on the system...

Undoubtedly the most accurate prediction of the lot!

The main thing that slows down index-related performance is fragmentation. You should do some research around this issue to understand more about fragmentation and what an index rebuild does.

The...

The main benefit of doing an unattended installation is you can guarantee repeatability.

It is too easy with a manual install to forget to select a given option or...

There are a few tools that can help with unattended installs.

You have the basic config file edit that comes with SQL Server, and you can wrap this up in a...

If you are setting up a lot of SQL Express instances it may be worth looking at SQL FineBuild.

The latest 3.2.0 release detects if Express Edition is being installed and...

My preferred approach is to install SQL Server on each node separately.

It is possible to run the SQL install and get it to install the database engine and...

By default the Domain Admins group is part of the local Administrators group. This is the normal security model and you should not change this unless you have an...

In your position I would also not want to re-install SQL Server.

I would want to reformat the system drive and re-install Windows.

Removing and re-installing .Net is a bit like doing...

If you start talking about SQL Server Service Packs, Cumulative Updates and Hotfixes, then you need authorities in both Windows and SQL Server. This also applies to Security Updates...

Your organisation should have a Group Policy Object (GPO) in place to force correct clock synchronisation and frequency of synchronisation. This is something you can raise with your Windows...

The most obvious cause is that both instances are sharing a resource that should not be shared. The advice about using File Monitor and Process Monitor to help detect...

Elliott has a good point. Regardless of the 'expiry date' on your current license, it is always worth putting some pressure on Microsoft, via your license reseller, to get...

This might depend on the legal jurisdiction that currently applies in the country where the licences were purchased.

Within the EU, my understanding is that if you have purchased a perpetual...

The Web Assistant functionality in SQL Server was removed for SQL 2008 and above. You need to find an alternative approach that gives the results you need. For...