Put them in a role that doesn't have access to anything they shouldn't have access to.

Edit: That's the most effective way to do it that I know.

Bob Hovious (8/5/2009)

---

(1) ...

sjsubscribe (8/6/2009)

---

GSquared (8/6/2009)

---

That faith or lack of faith has no bearing on maturity or being a DBA. Hope...

This would all be possible with dynamic SQL and querying the schema tables.

Querying sys.tables and sys.columns, you could pretty easily generate create scripts for tables missing from the target database....

sjsubscribe (8/6/2009)

---

Linda_2006711 (8/6/2009)

---

I think it's like what came first the chicken or the egg? I think that DBA's personality is such as you described, but when they start out...

sjsubscribe (8/6/2009)

---

camassey (8/6/2009)

---

Somehow, I don't think it's particularly fair to compare the development of stereotypical DBA personality traits and the rise of the Nazi party... perhaps this needs to be...

Yep.

If you have a Numbers table:

select dateadd(month, number-1, '1/1/2000'), dateadd(month, number, '1/1/2000')-1

from dbo.Numbers;

That will give you the first and last date of every month. You can join data to...

You can do that a few different ways.

Try this:

;with CTE as

(select

Row_Number() over (partition by ID order by Attr1) as...

I used to work for a bookstore that had a loyalty card program.

When I was working there, to get the card all you had to do was pay $10 for...

You're welcome.

Actually, that kind of makes sense. It might be the difference between join mechanics. Hash Match can be quite fast, and might end up being used on large...

It looks like that's the expected behavior.

Take a look at: http://jtds.sourceforge.net/apiCursors.html

That has some data on the use of those system procs and what they're for. Google/Bing/whatever for more.

I'm not...

If the database is in Compatibility 90, you can check the Schema Changes report. You might also find what you're looking for in the default trace.

I'll see your edged...