Not necessarily - update statistics does not block user processes because it is run in read uncommitted transation isolation.

If you don't have a lot of memory and/or you have a...

There is a new option that will help - it is the Auto Update Stats Asynchronous. Turn that on and if a request to auto update stats occurs, it...

Since you are on shared storage, performance issues are going to harder to track down because you won't know who else is actually hitting those spindles.

If your SAN guys are...

MysteryJimbo (2/24/2011)

---

There is only one way of getting rid of a killed/rollback spid that wont go and that is to restart the service.

I've had this once before and found the...

More likely it is their way of trying to reduce log usage during index rebuilds. They probably have code written that switches to simple recovery, rebuilds the index and...

danschl (2/24/2011)

---

in my enviroment where i have 50 state databases that talk to each other alot I use db.dbo. alot to get to the right database

And in development, so of...

Yes, that is correct - you cannot change the default trace.

I am a bit surprised that you don't have data any further back. I just checked one of my...

There is a standard report that you can use to see these changes. The report is the schema change history report - just run that and you will see...

hemul (2/21/2011)

---

Hi, thanks for your input. If this is the expected behavior of the shrink command, then the documentation is wrong or misleading:

http://msdn.microsoft.com/en-us/library/ms190488(v=SQL.90).aspx

The database cannot be made smaller than the...

There really is no way to tell SQL Server to load a database into memory. SQL Server loads data into the buffer cache when it is accessed the first...

If you truly think this is a bug (it isn't), then put in your issue at Connect and let Microsoft know.

Now, the reason this is not a bug is because...

Which is exactly what COALESCE or ISNULL will do for you. Sorry, mis-quoted and it should be:

SELECT coalesce(2.resellername, 'Other')

The above can be re-written using a case expression, if you...

Lookup COALESCE and ISNUL in Books Online:

SELECT coalesce(1.resellername, 'Other') As resellername, ...

FROM ...

Thought of another thing to check - verify that you have enabled both TCP/IP and named pipes in SQL Server Surface Area configuration.

That is definitely weird - there must be something with that instances configuration.

Some other things I would check, but honestly I don't know if any of these would cause this...