gert.j.kruger (5/2/2012)

---

However, I have been advised that on SSD one "loses" only one of the drives (ie if there are 6 x 150GB disks in the array, the total storage...

I understand the concept of requiring fast write response for SQL log writes.

However, what is the performance case for fast data writes; provided you have enough buffers does the...

btd (5/1/2012)

---

I do agree a well put together document BUT I wish we could get away from the interpretation of RAID. 'inexpensive discs'... The 'I' certainly did not...

Have a bunch of MS Dynamics GP databases. The tables typically are substantially de-normalised (very "wide" tables of partially redundant data), have long fixed length character columns, and large numbers...

Three comments come to mind, which do not invalidate your point, but does put it in perspective for some of us

MCM is not really open to us in the third-world,...

In debating RAID 5 against RAID 10 performance for SQL we need, in my view, to distinguish between read and write performance

For read performance:

SQL read page requests (except for SQL...

Paul,

Thanks for your response 🙂

Tony

Thanks for the clarification, I stand corrected

As I understand the section in BOL,...

As I understand the original article, and please correct me if I am wrong

* It addresses a particular paging model, where the number of items in the paging set is...

Ninja's_RGR'us (10/3/2007)

---

One general hint for the clustered index is when you need to a range scan (Select all data between those 2 dates). One other great candidate is when...

You may also be able to use an AFTER trigger on table B to update the relevant data in table A. Still two UPDATE statements internally, but it appears to...

At the Windows level, rather than the SQL level, it is possible to do auditing by file. You would be able to track Open/Close, and view the results in your...

eric_russell 13013 (5/6/2010)

---

Note that because it gets this info from database management views, the history only goes back to the last time the SQL Server service was last started. If...

Try DMV sys.dm_db_index_usage_stats. If there are no rows for a particular database_id, then the database has not been used since the database last came online

The advantage of the above approach,...