Viewing 15 posts - 18,046 through 18,060 (of 19,564 total)
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...
January 19, 2010 at 10:46 am
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...
January 19, 2010 at 9:38 am
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.
January 19, 2010 at 9:33 am
Either the browser or connectivity on the OPs end.
January 19, 2010 at 8:43 am
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...
January 19, 2010 at 8:41 am
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...
January 19, 2010 at 8:29 am
suan (1/19/2010)
thanks for the prompt reply.few more questions
1) my organisation is implementing firewall, will the default dynamic port assigned to the named instance will be block as well?
Typically yes....
January 19, 2010 at 8:23 am
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...
January 19, 2010 at 12:37 am
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...
January 19, 2010 at 12:20 am
Thank you for this article. It is a nice demonstration of another reason why one should avoid the use of
Select *.
January 18, 2010 at 11:52 pm
Just backing up what Steve said. 1 IP address, multiple ports.
January 18, 2010 at 10:39 pm
hydbadrose (1/18/2010)
January 18, 2010 at 10:16 pm
Is the firewall enabled on the Vista host?
When trying to connect are you trying to use the vista\instance or vista,1433 method?
January 18, 2010 at 9:45 pm
Viewing 15 posts - 18,046 through 18,060 (of 19,564 total)