Change the port number for your instance to a static port.

1433 is for the default instance (I apologize if my previous post was misleading - just used that as a...

Data

cloak

GilaMonster (1/16/2010)

---

...

I would suggest that you consider removing the blanked 'update all stats' and do targeted updates of the ones that you know need manual updating, the ones where the...

I agree that this seems like an effort in the wrong direction. Consolidating these tables, based on limited information, does not seem to be a good idea.

Either the browser or connectivity on the OPs end.

The question has been updated and does read better now. Unfortunately, Hugo's point is valid - thus making the QOD answers less than accurate.

Maybe a rewording of the question...

True it is that work is prohibiting a lot of thread activity. I wonder also if there is some interference from New Years resolutions and goals too. Everybody...

Typically yes....

The difference I see is that your First Index is using an Index seek. The include columns are pulling in the data for the full query.

The second index is...

I think that knowing the business, trends, data, and database are integral in determining if a less normalized approach is necessary. A fully normalized database is not always the...

Thank you for this article. It is a nice demonstration of another reason why one should avoid the use of

Select *.

Just backing up what Steve said. 1 IP address, multiple ports.

hydbadrose (1/18/2010)

---

Do we need to restart the Sql Server /Agent, when you change the Max memory , Min memory , Min Memory per query , Set the fill factor to...

Is the firewall enabled on the Vista host?

When trying to connect are you trying to use the vista\instance or vista,1433 method?