The short answer is Yes, you can do this.

At my old place we had two sites, each with a Windows cluster. Each Windows cluster had a SQL cluster installed with...

The size of a Windows event log is configurable. If the log is cycling too quickly, then one solution is to make it larger.

All queries (should) only exist to solve a business problem. If the only way to answer this business problem is to sort on column-encrypted data then maybe the business problem...

• This reply was modified 3 years, 5 months ago by EdVassie.

You started by saying you were experimenting with full text search and some alternatives. You seem to have ended in a rabbit hole wondering why some queries run in parallel.

Jeff...

You started by saying you were experimenting with full text search and some alternatives. You seem to have ended in a rabbit hole wondering why some queries run in parallel.

Jeff...

You are right in saying you will need one network adaptor for each IP address. However, they can all be on the same subnet, they just need unique IP address.

For...

• This reply was modified 3 years, 5 months ago by EdVassie. Reason: Remove blank lines

I have not tested your exact situation, but I think you have done the best you can with your current setup.

The crucial point is that both your aliases resolve to...

Do you have any SQL Server install logs. An internet search will show you where to find them.

If you have no logs then the problem may be permissions as already...

This sounds more like a learning exercise than a real world situation.

If it is a real situation you will have existing table structures and indexes. These will have usage stats...

Jeff has pointed out some things and posted much the same query as I have used.

You definitely need a left join on sys.dm_db_index_usage_stats if you want to find all unused...

I took this to be a trick question, and picked the wrong end of the trick.

From the DDL viewpoint I think the authorisation is either nothing or read-only.  This means...

They say you should treat your servers as cattle, not as pets. When a pet gets poorly you take it to the vet and spend a lot of money treating...

My old place used two levels of DNS aliases. We called them Application Aliases and Failover Aliases.

Each of our applications used its own alias to connect to its DBs. Therefore...

For me, I would start by asking 'How can I reduce the pain for the future'.  Two parts of the answer to this are given below. They can be done...

• This reply was modified 3 years, 6 months ago by EdVassie.

The setup was done with two clusters, to allow patches etc to be applied at each site independantly of the other. One requirement was that failover for maintenance should not...