Err.. what? Shrinking a database doesn't lose data.

writearjun53 (7/29/2013)

---

I want to know that can we shrink database file with EMPTYFILE option while currently accepting data or we just need to do some other thing to shrink database...

http://msdn.microsoft.com/en-us/library/cc280372%28v=sql.100%29.aspx

If the app's pulling enough data to make Management Studio run out of memory, I'm not particularly surprised that it's timing out. That'll be a lot of data.

Oh, and don't run Management Studio on the server and run queries that return huge resultsets....

That's a client error. not a server error. Sql server isn't written in .Net and yet that's a .net error.

You'll get that if you're pulling a huge resultset into Management...

All that compatibility level does is change the way that the query processor executes some specific SQL statements, ones that changed behaviour between 2000 and 2005 (and whether or not...

L' Eomot Inversé (7/29/2013)

---

I think this is about the first time I've disagreed with Gail about anything. She's better at most SQL Server things than me, but here...

You don't need it, unless you're planning on creating an index on that view (creating an indexed view)

Copy daily backup from production, restore. Will be faster than the copy database wizard and far less impact on production since you'll be leverageing the daily backups already being...

If you do that to the system databases,...

Yes.

The Statman query is what's run internally for statistics updates.

What exactly is the problem here?

Either that or the automatic stats updates, or both.

It's a statistics update, probably auto-stats.