lmu92 (5/13/2010)

---

Excellent job, Grant!

The only question that remains open is: Where to draw the line?

But I guess it's almost impossible to answer...

Interview questions, test/homework, almost complete projects, several hundred lines...

Thanks to all the comments. Steve posted this on a day I was going out into the woods, so I'm just now getting back to begin the process of responding....

Well a view wouldn't make a good staging table since no data is actually stored. If you must stage the data, I'd use a temporary table unless there were only...

Just a follow-up on this. My favorite software to do this is also Red Gate SQL Compare.

However, you should know that there are others out there, Apex, Idera, Atlantis Interactive......

Not knowing the precise structure, I can't supply you with precise SQL code, but you can do this a few different ways. Let's assume that you have three tables, the...

GilaMonster (5/12/2010)

---

However getting it from the plan cache is not reliable, as the...

eric_russell 13013 (5/12/2010)

---

Grant Fritchey (5/11/2010)

---

Whether the DBA knows it or not, that data can get changed by circumstances. It's best that you know that fact in order to gauge best...

Running data definition language (DDL) statements are generally not a performance tuning consideration, but then, they normally aren't run from within procedures like that. As a matter of fact, it's...

Ah, OK.

I have to ask, why do you want to create a view from within a stored procedure? What's the point?

You can backup & restore msdb between servers. Assuming the drives are the same, your Agent jobs should be ok. If the drives & whatnot are different, you'll need to...

Satya,

I'd strongly recommend you pick up a couple of books and read, a lot. If you've never done this before, it's very simple to make lots of big mistakes. Be...

eric_russell 13013 (5/11/2010)

---

GilaMonster (5/11/2010)

---

...

As for the index usage, it's flushed when the DB is closed. Shutdown, restore, detach, offline. There's no way I know of to manually flush it. Eric,...

lkean66 (5/11/2010)

---

Thanks for the reply. I usually noticed that the CPU spikes when Task Manager is started. So I am always a bit leery seeing 2 people running Task Manager...

I guess the answer depends on what they're monitoring with. For example, I'd hate to see two or more copies of Quest Spotlight connected to my production server. But two...