Jack Corbett (8/24/2011)

---

Well, still working on it. Added an index and that took 15% off.

The real winner is disabling and then re-enabling the FK's. There are 48 FK's...

Keeping data forever?

There are a few challenges:

Physical locations fail.

Media fails catastrophically (crashes). Try to keep it on two _different_ forms of media, at least one of which should not...

I meant 16GB/s RAM bandwidth (2 million pages/sec * 8KB/page).

Take a look at the Intel E7-4870 and E7-8837, both of which have a "turbo" frequency of 2.8Ghz when the workload...

If you're only having issues after 16GB/s of throughput, you're in rarefied air already. You'll need to focus on RAM architecture, memory timings (critical), and bandwidth settings more than...

GilaMonster (8/17/2011)

---

DBCC UpdateUsage fixes page space information, nothing else. There were bugs in the the page space tracking algorithms on SQL 2000 and before, hence it was necessary to run...

thepotplants (8/16/2011)

---

Hi, thanks for your answer 🙂

Nadrek (8/16/2011)

---

The cleanest install is always starting with a fresh OS and working up from there. I like Windows Server 2008 R2, even...

The cleanest install is always starting with a fresh OS and working up from there. I like Windows Server 2008 R2, even as a host of SQL Server 2005.

clubbavich (8/16/2011)

---

I hate to nitpick but I don't believe that many are using SSD's for their logfiles. The main performance advantage of an SSD is IOPS. 15k RPM drives aren't...

From what I've heard, Virtual Restore is probably the easiest way to go.

Aside from backups, there's archiving.

I feel obligated to point out that for some situations, particularly where detailed change...

stebennettsjb (8/1/2011)

---

Manufacturer replied..

When i created the vols for the RAID 10s (1 with 6 disks and 1 with 8 disks) and RAID with the default max vol size.

They have...

It's the trivial case of "exclude each row...

Eric M Russell (7/27/2011)

---

Nadrek (7/27/2011)

---

I'd say stick with the simple; something very like a BIGINT IDENTITY on the table, not preserved after a table drop or truncate. Preferably one...

Go back to SQLIO, particularly using...

Eric M Russell (7/27/2011)

---

When a table is edited in SSMS, say to add a column or alter it's datatype, the operation will often times be scripted out in the form...

Steve Jones - SSC Editor (7/27/2011)

---

Eric M Russell (7/27/2011)

---

I'm just thinking that, if the page size is 256K or 1MB, then how would that impact page splits and logical fragmentation...