A deceptively simple question, +1 for me - thanks. Perhaps slightly better wording next time though please. 2,0 is also, technically, correct according to the terms of your...

There's probably a way of modifying this value directly in the system databases, but a quick hack-y method would be to create a new LUN (drive letter) at the OS...

An excellent article that applies a common-sense approach to doing these kinds of changes. It does rely of course on sufficient resources to allow this approach to take place...

Hi Mike, thanks for the links and your comments, I'll check them out tomorrow. Its always nice to learn something new!

A poor question. I answered none of the above simply because DiskIO was a combined figure and the question specifically referenced reads, so my answer is correct.

Also on a...

Good question, thanks, and how annoying that I couldn't spot the twist until it was too late.

Lesson: Never answer QOTW before 7am.

Point taken, it's a join, not processed row-by-row, so not subject to overhead of 'decoding' the date functions then comparing, then doing over again in a loop. So I...

It was just a thought. Running through multiple transformational functions on each iteration seems intuitively wasteful.

Yes, sorry Jeff. Edited post above to reflect this a few moments ago. When I replace the outer ' with " then the 'inject' merely inserts a row....

Jeff/Sean - see edited post above.

Good point. You'd merely get the string inserted into...

Bob - CAST statement in signature...

CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1

The statement on the left is equal to the statement on the right, i.e. 1.

The double-equals is dev-jargon for...

Brilliant, thanks - didn't spot that typo there!

sunny.tjk (9/6/2012)

---

I'm trying to improve the performance of this query which is taking a lot of time to run.In the following query, loanhistory is a very large table. Though I'm...

Surely there's an argument here that string validation (to take one example) should be handled app-side anyway, so that your table only ever receives clean data?

If not, and...