sys.indexes has the data_space_id, which is the ID for the filegroup. The clustered index is where the table data is.

Just keep in mind that it only takes one try for a valid user who knows...

I see mandatory password changes on a fixed interval as a sop to security without any actual value, and with the potential of negative value.

Changing passwords on a fixed interval...

Oh, he went WAY beyond that!

He actually insisted that dressing...

Test a loop join from one table with two...

Jeff Moden (8/27/2009)

---

GSquared (8/27/2009)

---

That's why I mentioned...

I'm not sure what would cause that outside of the public role having those rights.

andersonrj18 (8/27/2009)

---

What do you want done if there are multiple gaps? If, for example, A had 1, 5, and 100, instead of 1, 2, and 100. That would mean a...

LOL! I'd forgotten about that one! That was amusing!

Lynn Pettis (8/27/2009)

---

I may agree to a point.

Asking this:

tells me you haven't even tried to find an answer yourself and want...

dma (8/27/2009)

---

🙂 I enjoyed reading your post thank you, and agree very much with the fact that IT would benefit from a formal structure. It is not mature enough for...

hickshugh (8/27/2009)

---

Man, did this discussion take a bad turn or what. I just wanted a FRIENDLY discussion on mentoring. One thing you all should remember is that you...

K. Brian Kelley (8/27/2009)

---

Bob Hovious (8/27/2009)

---

You all do realize that in some cases SSC is the automatic transmission compared to the manual-shift F1 key? All the volunteers enable...

What do you want done if there are multiple gaps? If, for example, A had 1, 5, and 100, instead of 1, 2, and 100. That would mean...

dma (8/27/2009)

---

I think the discussion is going way out of the point. But to clarify this is completely false that education system in India was designed the way this person...