http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

DMVs can miss queries because of plan removal or plans never cached.

32767, the system resource database.

Shrink to X GB (where X is the size the log needs to be for normal operation)

As the error message says, the network path does not exist. Nor would I expect it...

haiao2000 (4/22/2013)

---

Thanks Sean,

So after restored on a SQL 2008 R2 engine, the database being upgrated to 2008 R2 or is it still considered sort of SQL 2005 database running on...

aayushmail007 (4/22/2013)

---

My data gets updated daily once.

I need more space in disk and historical data changes is not necessary because i can use backup to create them back again (...

I'm just going to leave this one here http://www.sqlservercentral.com/Forums/Topic1445111-357-1.aspx, have mercy on him. 🙂

Please read through this - Managing Transaction Logs[/url] and http://www.sqlservercentral.com/articles/Transaction+Log/72488/

Other than...

Please note: 4 year old thread.

Why are you joining on a hash of several columns in the first place?

Just a warning, discussing what's in the exam is a violation of the NDA that you accepted when writing that exam, so watch what you say about the contents of...

SELECT @@NestLevel

Let's see... what happens when we have a 6-hour full backup duration and a 15 minute data loss SLA and log backups don't run during that full backup?

IgorMi (4/21/2013)

---

Just had similar scenario yesterday, without locks but with high cpu. Some update scripts were running for 'forever'. We stopped them, rebuilt the indexes and run again and they...