How are you looking to "utilize" memory?

Are you wanting something...

http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/62424d3b-3c67-4044-ab72-6ba155750175/

Although I had removed and reconfigured previously from what was seen above, now after manually clicking the exe and once again deleting everything in configuration ON THE LOCAL...

Additional information (still no resolution found in searches):

There are two instances on the box.

There was a third instance on the box for 32 bit version (others are 64 bit)...

Take a look at DBCC UPDATEUSAGE in case it can assist. I don't recall right off if the DMV's you are using are ones that need to be kicked a...

By any chance, are there any triggers on the subscriber database tables that are part of the subscription?

When you say NEED, and then look for resources of what indicates how much is used - your returned results might be a bit confusing. SQL server will use pretty...

Also... might want to check select * from sys.objects where modify_date > '' << where you put in the time things started going slow. It could be someone put new...

I don't know how much a waitfor command would really slow your system. Unless you see blocking with the waitfor SPID as the blocker, I would look somewhere else.

The database...

Are there any further details about the login failure in either the SQL error log or the system or application event logs?

I have seen something "similar", but it did not...

We had been looking at Team foundation for a few other reasons and went the path of Subversion.

I will definitely see what was missed in my review for 2008 for...

The "sloppy" part is the centralization location having spun up so many instances and the need for instance regulation. Having one backup file to create several points that can connect...

I see this as a good approach and one that we had...

select 1 as tblid,column1,column2 from table1

union all

select 2 as tblid,column1,column2 from table2

order by 1,2,3

Execution plans go bad due to stale statistics. The statistics are then updated (is auto update enabled : http://www.sqlskills.com/blogs/kimberly/post/Auto-update-statistics-and-auto-create-statistics-should-you-leave-them-on-andor-turn-them-on.aspx) during certain moments in table records changes (addition of...

Create a sql agent job on the DR server that does a command for each database not system databases or dr specific to make sure log shipping is disabled, restore...