Take a look at the information availabe on SQL Server Agent in the Books Online. You can do exactly what you want through there.

As far as "when" to create a clustered or nonclustered index, I'd strongly suggest creating the cluster first, then the noncluster. Since a clustered index key defines the storage for...

My absolute favorite is Embarcadero ERSTudio. Fantastic set of functionality.

CA offers another that's extremely popular ERWin. There are a couple of others available, but those are the two big ones.

OK. While I'm in absolute, bowel voiding fear from this...

I have to...

So that's confirmation, she's filthy rich AND a consultant. Just like the rest of those consultants, milking...

I've said it before and I'll say it again, you do great work here. Thank you.

Congratulations! Well done Steve! And a hearty thank you to all the regulars. Here's to the next million.

KB (1/28/2009)

---

Hi Grant,

I tried using a subquery as well as CTE, the results for ColA3 are not right.

Suppose Table B has 4 rows that need to be inserted into Table...

Ah, the life of a fithy rich consultant...

We've given it way too much knowledge....

GilaMonster (1/28/2009)

---

Steve Jones - Editor (1/28/2009)[hr "whether its transaction log backups, and XML indexes or whizbang fiber-optic laser beam assemblers." that were copied word for word, and these aren't phrases...

Cover your ears...

An execution plan is an execution plan. They all age and when the cache cleanup process comes along, they get removed from cache. No differences for stored procedures.

The...

Steve Jones - Editor (1/28/2009)

---

I'll admit to using Whizbang at some point in my life, but not regularly. At least I hope not.

I thought about posting a diff of the...

Unfortunately my company cut corners and we had to make due with the standard fiber-optic laser beam assemblers. They just wouldn't spring for the whizbang model. Stinks.

We're beginning a project to ASSESS the upgrade from 2000 to 2008 this year. I wouldn't sweat your skills being out of date. SQL Server 2000 is still going very...