I agree with Jack. In most circumstances, the cost of the FK is well worth the benefits of the FK. In exceedingly rare circumstances you can have the kind of...

Largely... What Gail said.

The only way you can get the actual execution plan on the fly is to use a trace.

I've looked through the query, but I haven't read all of it (there's a lot going on there). In general, your queries seem to be structured generally OK (the one's...

Sounds like a one to many relationship.

Use the primary key of the main table that links to X number of rows in the second table. So for your array sitation:

MainTable

MainTableId...

To my knowledge... No, this won't change performance. Let's also add a clustered index to the table. Assuming it's the same clustered index before and after the alter, all the...

How long since the last execution did you query the dmv's? If it's hours or minutes, you may have a serious memory issue. If it's days or weeks... not at...

Just hit the microsoft documentation. There's tons of information available there.

The error is very straight forward. You've got duplicate data. The key is to identify what constraints you have and then break down the procedure and capture the data output...

To eliminate the key lookups you need to make the non-clustered indexes into covering indexes by either adding columns needed to the key or as included columns. But you need...

Only use nvarchar if you are absolutely going to be using the extended character sets. If you're just using some of the ascii characters with umlauts or whatever, you just...

One word. Cursors.

I'm 46 and I think I'm going to try being a geek forever. I'm just not the management type and I really like playing with toys. I know an MS...

Whoa! I didn't notice that guy had 1200 posts. What the heck is up with that? You take that much time and you still don't get silly fundamentals? And I'm...

What about good?

What about evil?

What about right?

What about wrong?

Is there a Vorlon in the building?

Profiler would be my first choice.

Second wouldn't be sp_who2. It'd be sys.dm_exec_requests. With that you can link to other dmv's to get query text, execution plans... whatever you need. But,...