RalphWilson (4/7/2010)

---

Whil;e I agree that data should not be changed without careful consideration, I also have to deal with the very problem discussed in the editorial and yet I am...

You know, the people that help out here are all un-paid volunteers. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables affected, and INSERT statements to put...

You know, the people that help out here are all un-paid volunteers. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables affected, and INSERT statements to put...

Grant Fritchey (4/7/2010)

---

(1MC): "ELT's... spill in RC"

Was it all on the boots? Sounds like a potential hours-long...

Grant Fritchey (4/7/2010)

---

Steve Jones - Editor (4/7/2010)

---

SL-1 was brave, some big, shiny (now) glowing, brass ones on those guys.

I went in the reactor containment once and was nervous the entire...

CirquedeSQLeil (4/7/2010)

---

That is two areas where we could use the local PASS chapters to assist with this certification. They could help serve as the review board as well as...

Does anyone else around here feel like a rocket scientist?[/u]

I agree... Good question. Made me sit back and think about this a bit.

Must be nice. Really nice. 🙂

This will get you the system tables. I'll leave it up to you to do the reindexing / updating of stats.

select *

from sys.objects

where type = 'U'

and...

CirquedeSQLeil (4/6/2010)

---

I could make a case for it needing to be both the board and an exam. Without a board review, it makes it easier to game those emphasis...

Your question didn't mention what to do if there are two entries with the same value. There are two options:

1. All values that tie have the same rank, and the...

Self-join not necessary, just use one of the new (to sql 2005) ranking functions:

-- See how this starts off with a table and data in it?

-- If you had provided...

CirquedeSQLeil (4/5/2010)

---

I like the idea of not having a lot of tracks that correlate well with the MCM and MCITP.

I also like the ability to provide specialization in key areas....

(Well, when I don't clearly state what I really want, then what I get is what I asked for!)

I was meaning to edit your previous message... but thanks for...