This is roughly what to do. There is some overhead, but once you get to millions of rows, it doesn't matter.

Don't forget that the clustering key is in all...

The short answer is "no" you cannot easily recover this.

If you want to spend money on a tool like ApexSQL Log, they can read the transaction log and give you...

That is the maximum number. They are saying that the performance of your workload, based on hardware, will determine this.

There is no rule that says xx users can be connected...

The general list I've looked at are the CPU%, memory pages/sec, page life expectenency, buffer cache hit ratio, disk Qs, % disk time.

You don't care if someone runs resource intensive...

If you run the import wizard from SSMS, it runs on your desktop, not the server. You can use that to import this into SQL Server.

I sent this on to the mail guys.

Thanks

Congrats! Are you going?

The timing for that one is bad for me, but I am going to...

So, you're confusing active/passive with nodes. On a cluster, all three instances are on both nodes.

If you have one node active and taking clients, then you need one license for...

Alexander Kuznetsov (1/26/2011)

---

Steve,

While I completely agree with " You can't trust stuff you download", why are you singling out only open source: "no matter what the Open Source crowd...

I would also be sure that in my mirror sets

(1, 2)

that these were not two drives from the same batch. Maybe not the same company.

If you move to SS2K8, then the Filestream can help you, but it depends on what the size of the files. What's the average MP3 size?

If they are small, <...

That reminds me. I enjoyed Mission Earth. Should turn my son onto that one.

Stefan Krzywicki (1/26/2011)

---

Trey Staker (1/26/2011)

---

Stefan Krzywicki (1/26/2011)

---

Elliott Whitlow (1/26/2011)

---

I...

Note that disks still fail. It's why when data is really critical, you can't necessarily wait on a rebuild. A disk failure from the same batch of drives, could be...

boulang (1/26/2011)

---

Assuming all things are equal then, wouldn't you go where the money was best? Of course most people think their companies ofter their employees a better deal than...