Hi all

I think eric.fung and bakwas28 are correct -

As Eric said:

I just thought that if I can successfully maintain every log backup, say from Mon day to Friday, then...

Don't forget, if you run up against the limitations of the built-in types, you have the option of creating your own user-defined types.

Unfortunately, it does require CLR integration to be...

Hi

Fantastic article and a good detailed look at an important area of functionality. Thanks for your time!

A couple of comments:

- Third paragraph from the end, it says "CURRENT_TIMESTAMP function is...

As noeld says, the key is in minimising the size of your transaction (and therefore the amount of data which must be logged to your transaction log before the data...

Well, with the way most RAID works with more than two disks, the data is split up into "stripes" across all disks in the array, so it doesn't really improve...

Well, it just so happens I'm building a similar tracing mechanism myself at the moment!

As an experiment, I tried both SET @Source = OBJECT_NAME(@@PROCID) and SET @Source = 'String Literal'...

I agree with most of the voters at this time... the non-clustered index option is not only a viable solution, but is in fact probably preferable to changing the existing...

Interesting QOD - knew the answer from the last time round.

I can only find the reference to multiple ports functionality in the SP3 version of SQL Books Online - does...

Well, in the absence of any other information, I assumed that the question was about row counts, and that the SQL UPDATE statement itself would not produce an error.

The red-herring...

I think this question highlights MS's advice that you buy identical machines for a cluster configuration.

Not only is there less chance of configuration problems, but it also means you...

This comment isn't directly related to the question, but it may also be worth noting that if you set a database in single user mode using ROLLBACK and you are...

quote:

---

I was surprised to read you can't use controller cache on clusters.

---

This limitation only applies...

quote:

---

When you use RAID5, isn't some percentage of the total space allocated to the checksum or whatever it's called?

---