Anders Pedersen (3/4/2009)

Actually as a consultant I came accross a site that had software compression turned on, back in the days of Pentium Pro 180s.... Lord was I a...

The indexing should just fetch file names, right? I don't think it's altogether that bad, but yeah I'd probably shut it off.

Ask them to turn compression on as well...

use SPACE(2)... or is this a trick question :ermm:

The cursory approach is to only delete a row or a few rows at a time. In theory you would rarely if ever have a problem with this method given...

I was at a client with a similar situation. For their application, constantly searching for data across tables such as this in the OLTP environment resulted in poor performance; they...

I did a blog once on something like this - would this help any?

http://www.texastoo.com/post/TSQL-UNPIVOT.aspx

Absolutely correct - you will have a few things to rewrite, and this is one of them. Macros, DLOOKUP, etc. are other things that you might run into...there won't be...

This is a good question...someone probably has an answer but I don't. If I may, I'd respond with a comment. First, I've never seen one like this, stoked that I...

Theoretically the opposite should occur. I have no idea, but this can probably be answered if you start looking at profiler and dmvs/dmfs to see exactly what's going. Give us...

Great ideas, but neither will work. The SQL 2008 express ms isn't an option, thats a different tool altogether. As far as red gate goes, it's pretty decent once you...

For memory, your best bet (in my opinion) is page life expectancy. Look at this and see actually how long pages are able to be kept in memory. If it's...

Great job - dig it!

The answer is "it depends". I've done both migrations and upgrades to SQL 2005/2008 and each one of them was a bit different. Are you going to a new box,...

Sweet script. Yours or one you found?

Exactly. And it doesn't need to be just limited to one clr function...just an idea.