We use just 1204. I'm wondering though if we shouldn't switch it over to 1222. The XML output looks easier to read. Anyone using that?

Not stupid, you just needed a nudge.

I've been going around telling all & sundry that the bit data type wouldn't take a null. Then Gail just simply tells me I...

Instead of VARCHAR, if you use NVARCHAR, that might address the issue.

I love the missing index DMV's. They're not a panacea either, but they sure can help you spot something simple quickly.

Just to toss in a contrarian view point, I've never had DTA recommend a single index that was worth the trouble it took to run a series of scripts through...

If you're not already cycling your error log, you should.

Daily seems a bit high. We cycle ours once a week.

Boy. I don't know where I've been. I sure thought it was that way. Maybe I'm channeling some old bit of knowledge from a different system. Damn. I hate being...

You have to start from a concurrency model. It's either pessimistic or optimistic. You seem to be assuming an optimistic model, there are unlikely to be very many or any...

That's about as open ended a question as it's possible to ask.

Obviously, the Books Online would be a great place to start. I'd also suggest perusing Itzik Ben Gan's TSQL...

If it's possible, format the delimited list as XML and use XQuery to retreive it from there. We've started to find this a more optimal approach than the old one...

Not wrong, at all, but with something this large, I'd suggest the possibility of looking at exporting to a file and then using BULK INSERT to move across. It's a...

Great comments. That is one of the most difficult problems we encounter working with development teams. They don't trust us and we certainly don't trust them. It takes a while...

A large part of how the optimizer gets the data out of the tables faster is statistics. When you're creating artificial tables, such as table valued functions, there are no...

Ah, I wasn't aware that changed in 2005. Thanks for letting me know. That'll change decisions in the future.

Personally, I kind of don't care, bit or tinyint, but if something...

I'd say it's because it can, and probably did, put statistics on the columns in the temp table that you did with calculations in the other queries. That would make...