I thought your name was Carpal Tunnel? Now I'm so confused.

Heck yeah.

I mean, did you ever see this before:

http://support.microsoft.com/kb/931279

Great. Something else to worry about.

And make sure you have enough space on the disk.

You might have problems with the query you're running as well.

Is it the query that's slow or the insert? Can you post an execution plan?

User tables, as has already been stated, are your tables. This is opposed to system tables (and views) which are the management tables (and views) for SQL Server itself.

Gail beat me to it. You're in a brave new world. Use the DMV's and DMF's liberally. They're great and provide a lot more information in a much clearer fashion...

That's a huge topic. I posted an article [/url]on it that just barely scratches the surface. It can at least get you started so that you can begin to ask...

Why on earth would you need millions of records in a front-end app? People won't even read thousands of records. Most people don't go past the first screen, except to...

I would really want to see the common access paths of the queries prior to trying to decide the cluster. Honestly, if SITE_ID is the most frequently used query mechanism,...

Good luck. I assume you're not getting paged on the deadlock events? I would be, so I'd sure as heck get a resolution in place prior to Christmas.

In addition to the help file, you should consider picking up a copy of Itzik Ben-Gan's new book, T-SQL Fundamentals. It'll get you pretty far down the track pretty quickly.

I was doing a bunch of research on this because it was making me crazy that I didn't know the answer. I finally posted, what I think is the answer,...

I was just reading up on this again last night. According to the BOL, there is a queue and then the SMO or FileReader takes stuff from the queue. I...

Are they sure Oracle provides enforced (key word) referential integrity on partial keys? I'll have to ask some of our local Oranuts.

Oh you DBA's and your precision. It was more fun when it was kind of vague and mysterious.