select *, OBJECT_NAME(fkeyid)

from sys.sysforeignkeys

where OBJECT_NAME(rkeyid) = 'YourMainTableHere'

DOH! Still using the deprecated version above....disregard and instead use this:

select *, OBJECT_NAME(parent_object_id)

from sys.foreign_key_columns

where OBJECT_NAME(referenced_object_id) = 'YourMainTableHere'

L' Eomot Inversé (7/20/2012)

---

sestell1 (6/25/2012)

---

I was always under the impression that there was no reason to create indexes on table variables because they exist only in memory.

Does anyone know what...

Probably looks like their indexes...fragmented all over the place....

Duplicate post. Please direct all replies here. http://www.sqlservercentral.com/Forums/Topic1332970-291-1.aspx

But where is the data coming from? It is very likely that the...

That's because the best we could do is pseudocode, we never got any ddl to work with. I...

Steve Jones - SSC Editor (7/20/2012)

---

Ugh, shooting in CO last night, just north of here if you haven't heard. Crazy. My son wanted to go see Batman last night (not...

Mountain Steve (7/20/2012)

---

My Senior DBA who reviews my code. I just wanted to know if it was true or not. I need to follow the sr. DBA standard...

Where did you hear that? There is no truth to that at all. It doesn't even make sense. Why would the optimizer care which order they are in? It is...

Nope, you typed it wrong. 😛 The very last query is a UNION and you have UNION ALL

select @@VERSION

create table #t1 (col...

I don't quite get what you are doing but doing inserts into a hierarchy like this is pretty straight forward.

http://msdn.microsoft.com/en-us/library/bb677174.aspx

To take a little different approach to the discussion, you should NEVER design your tables based on what you want in a report. Design your tables in such a way...

Here is a link to Paul's article about APPLY.

Understanding and Using APPLY (Part 1)[/url]

Understanding and Using APPLY (Part 2)[/url]

This a great set of articles and totally opened my eyes on...

No worries. It will fall off the radar soon enough. 🙂

Lynn Pettis (7/19/2012)

---

Sean Lange (7/19/2012)

---

I think you just...