Good call!...

Lowell (5/26/2016)

---

your original six part WHERE finds everything that is "OK", ie does not match the double spaced indexes.

this might work as w to find your exceptions and outliers:

select p_code

from...

That was my thinking tbh, I like best practice but sometimes you just have to think whether it's worth following especially on a DB this small that doesn't appear to...

Sorry forgot to mention, recovery model is full and t-log backups are taken 5 times daily at 08:00, 11:00, 15:00, 18:00 & 22:00. I restructured the T-log backups a added...

That's perfect, many thanks. Time to get my bully on! 😀

I know it's comparatively small and I feel like the school bully but from the point of view of best practice (and a little anal retentiveness as well) I'd prefer...

sqlnaive (10/22/2013)

---

Since I'm not much into ETL and going through learning curve, i had to check out for answer from web and in the meantime was glad to learn about...

Many thanks all. 🙂

Improving things is always a good plan! 😀

I can sympathise with you as I'm the sole DBA for my company and with no mentor or guidance I had to map...

Beatrix Kiddo (8/16/2013)

---

WWDMark (8/15/2013)

---

My 2008 MCTS and MCITP Certs don't have 'expiration' dates on them, basically it's a case that technology moves on and if you've got a MCITP cert...

Beatrix Kiddo (8/15/2013)

---

Thanks for replying; that's very interesting. I do see the sense in what you're saying. Miraculously I've just had the go-ahead for a full MCSA programme (should have...

Beatrix Kiddo (8/15/2013)

---

WWDMark, do you decide what to do in the end?

I have a related question, so I hope it's ok to put it here My manager is about to...

FYI: If anyone didn't know, this also a deprecated feature, see http://technet.microsoft.com/en-us/library/ms151149.aspx

Duncan Pryde (8/8/2013)

---

Hi Mark

This article has some useful information on collations. In their recommendations at the end, it says:

If you are considering a SQL collation based only on the performance...

Bump