Are you trying to shrink this down to 150MB? You want to keep free space in the file in general.

The shrinking can be slow or fast, depending on the load...

I tend to agree with the views expressed above. It can be a useful tool, if you consider the load on your system for Ins/Upd/Del

Or

update MyTable

set col = sitename + resource

from inserted i

where i.pk = MyTable.pk

I'm not completely clear what you mean here or need to accomplish?

Are you and the client both loading files separately? Do you need to create a file for them? Or...

Are you using a FQDN in there for the alias?

Are you trying to build up the select statement with IFs? Can a CASE work

CASE when @home = home

then a.xxx

Or are you trying to build dynamic SQL? Honestly...

It's good you find some inspiration from Randy, but I wouldn't pity yourself. Move forward, look to make changes, and look to make life better where and when you can.

Take...

Protein bar, coffee and water here. Had to take a large supply of bars to the UK last year. Had a hard time finding them.

I struggled with breakfast. Lots of...

As an FYI, I'm not upset about the complaints. I completely understand how it looks from your side and I apologize.

The QOD is a hard place to get a good...

I think my brain has lots of little tables, very little DRI, and way too many cross joins occurring on a regular basis.

If you monitored the mpg, was that not at least interesting?

I think that you have to make the choice about fun v economical and bear the costs. When I got...

OK, this is more my fault than Kevin's.

To start, "is" changed to "are" and "select all that apply" added. I should have done that.

The engine is built to show...

Scott,

Thanks for the editorial and it's provoked an interesting debate.

I wasn't sure what people would say, and I don't completely disagree with Scott's arguments, but I don't think they're great....

"Enjoy driving", OK to be fair it's not enjoyable. It's like a bus around here moving kids, but it's not really any different than a lot of cars. The 911,...

Closing the thread on this one. I don't see anyone being rude except the OP and no racism.