Could you post your 2008 problem in a new thread (in the 2008 forum) and include the last portion of the error log from before an abrupt restart?

You probably can, same process, identify the poorly performing areas, fix...

Yes.

I...

amy26 (4/2/2013)

---

GilaMonster (4/2/2013)

---

Why not?

Comparability level doesn't disable new features, it just...

All operations that change the database in any way are logged, no exceptions.

Why not?

Comparability level doesn't disable new features, it just changes how...

ShrinkFile with the EmptyFile option the ndf then drop it. Then just shrink the remaining data file to a reasonable size and rebuild your indexes afterwards.

With the exception of different set options, a procedure will only have a single plan in cache at a time, so measured more likely in kB than GB.

Query sys.dm_exec_cached_plans, cross...

Master because you can never restore log backups of the master database (it can't be restored WITH NORECOVERY)

Model set to whatever you want new databases to have, default is full,...

invisibleduncan (4/2/2013)

---

So although it could be argued that I was correct, any query that uses the view would create a cached execution plan in the same way that it would...

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/

There was another full backup taken (without the copy_only option) sometime between the full that you took and the diff that you took.

Views don't have stored execution plans, because they're just saved SQL statements and are replaced by their definition early in the parsing phase of a query. They're not executed in...

theashishtrivedi (4/2/2013)

---

If I define VARCHAR(8000) and store 10-20 characters in it, there should be some performance issue in long run (i.e. SQL Server will reserve the space for 8000 characters...

Shrinking with EmptyFile will give you just as much fragmentation as shrinking without that option. It's not a magic good shrink.

If all you're trying to do is remove empty space...