You slow down data modifications, increase the size of the database,...

Did you look online for that?

http://msdn.microsoft.com/en-us/library/bb500435%28v=sql.100%29.aspx (SQL 2008)

http://msdn.microsoft.com/en-us/library/bb500435.aspx (SQL 2012)

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/

Depends what you mean by 'current execution plan', as that's not a common term

2) on which...

To expand on that, I've seen a database's performance dramatically decrease after an upgrade from a single processor server to an 8-core with lots more memory. The code was riddled...

Could simply be that the hardware wasn't the bottleneck in the query performance.

IgorMi (4/15/2013)

---

So, what is the difference between a query with missing index on a column in its WHERE clause executed as exec sp_prepexec @sql_stmt or exec sp_executesql @sql_stmt, and the...

You would be correct, option 2 is prone to bad plans

http://sqlinthewild.co.za/index.php/2009/09/15/multiple-execution-paths/

Please note: 7 year old thread

What link for Visual Studio 2005? MS site? Something else?

The windows logs showing a loss of connectivity to the drives certainly indicates some problem with the storage, specifically that the drives went away temporarily. If SQL's system databases were...

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1442104-1550-1.aspx

Right, that's a good hint.

SQL's system databases are on one of those drives? If so, with connectivity lost to a drive, SQL will fail immediately, no way around that.

Can...

Windows event logs?

Without some log of something it's going to be near-impossible to even tell what happened, let alone why.

Except that would also match entries such as 'Jet...