Actually that's a distribution I would expect. this is a trivia question/answer, and unless you'd read Henrik's article the other day, it would be easy to have 1024, a logical...

First thing I do, and used to require in dev teams, is to set tools to replace tabs with spaces. Creates all kinds of issues.

Need a KillAllTabs task in SSIS...

Nice one Jeff, you should write those down. I'm not convinced, but that's a good quote.

No raise then, but it did make me look good.

And when the company was bought 4 or 5 months later I didn't get laid off and got offered a job...

Could you or someone have installed this database on one of the individual instances and not the virtual?

Hey, I can't cause trouble every day.

Please start your own thread for a question, post table DDL and query code.

This almost sounds like homework or an interview question.

You should write some code, make an attempt, and if you don't understand what works or doesn't, we'll help. But we don't...

I'm not sure what you're doing here, but this isn't the appropriate forum. I am moving to the T-SQL forum, but if you are using SSIS, then please state that...

You might want to call MS support and work through this, checking to see if you might have hardware issues.

Were you asked to create a presentation for how to do this? We don't do your work for you. There are some good links above to help you learn how...

Moved to T-SQL

You should trace and see how the application is inserting data. There might be something else.

Are there also instead of triggers on the table?

You need to provide some...

Lynn, that's down the road, thanks for the recommendation.

And remind me to drive when we get to go out for a beer.

Depending on how you implement search, it might work well. I wouldn't be afraid of EV, I'd think about or look for good search code.

Maybe you should mock up a...

What do you mean the data is XML? How are you exporting it?