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 2 years, 10 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 2 years, 11 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...

Having done both log shipping for DR and availability groups for DR, I would always go for availability groups.

Setup, administration and troubleshooting for AGs is much simpler than log shipping,...

Personally I would start with a new Windows install. This makes sure that the server can be reproduced in the future if it fails.

Also in the past a place where...

Hearding cats is easy compared to managing application development.

Computing has to deal with constant change: business requirements, priorities, costs, budget, available hardware and software, skills, etc. The applications that get...

For me there are two main aspects to this.

The first one is that in computing the only constant is change. A skill that would give top pay in year 1...