smitty-1088185 (4/19/2013)

---

I have a database with one 110g mdf file. I would like to stripe the I/O across five 25g files and purge the data out of the 110g file...

1 and 7 - google "performance monitor"

2 and 3, google "query plan cache stats" or "SQL profiler"

4 google "catalog views"

5 google "index fragmentation DMV"

What's New (SQL Server 2008 R2) - http://msdn.microsoft.com/en-us/library/bb500435%28v=sql.105%29.aspx

As for how you install it, buy a licence, get the DVD or iso, run the installer. Same way you'd install SQL 2008.

No.

Give someone a database and you're giving them full and complete control over the schema and data.

Chapter 3: http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

Same answer. Those queries do the same number of reads because they're doing table scans, there's no useful indexes. SQL has to read every single row of every page in...

Firstly, are those waits a problem? Do you have excessively high CPU usage that is hindering performance.

Lock request timeout will not be caused by a deadlock.

You can look in the system health extended events session to see if you have had any deadlocks, but I suspect...

Please post new questions in a new thread. Thanks

No, SQL Server does not do reliable position-based short circuiting of expressions. The order things will be evaluated in depends on indexes, data distribution, estimated row counts and whatever plan...

Developer edition is exactly the same as Enterprise, just with restricted licensing.

wolfkillj (4/18/2013)

---

GilaMonster (4/15/2013)

---

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...

Eric M Russell (4/18/2013)

---

GilaMonster (4/18/2013)

---

Where I live, even asking a candidate to sign an at-will contract can get the company hauled up before the labour board and fined heavily, severance...

http://www.sqlservercentral.com/articles/Indexing/68439/

http://www.sqlservercentral.com/articles/Indexing/68563/

http://www.sqlservercentral.com/articles/Indexing/68636/

Where I live, even asking a candidate to sign an at-will contract can get the company hauled up before the labour board and fined heavily, severance pay or no severance...