I live about 1/2 mile from here.

Lynn Pettis (5/14/2009)

---

The sun has set in the deep desert and lone figure sits quietly meditating next to a small camp fire. While sitting there, he simply cannot believe...

Oh, you don't have to be Klingon to do...

Just chiming in as someone getting started with PowerShell. Well done. Thanks for the work. I'm still just digging through it all & figuring it out.

2 Big boxes?

Jacob Pressures (5/13/2009)

---

You know I developed a whole database of about 20 tables using DDL, but unless you use it all the time, it seems that its easy to forget....

PaulB (5/14/2009)

---

MS SQL Server != Sybase

They departed ways...

You should probably try generating the database as a script, recreate it, empty, and then migrate the data over. You could continue using SELECT statements or you might want to...

That's a huge topic. If you're expected to deliver all this stuff NOW and you don't know how, you really are over your head. However, this is a high level...

It really depends on the query being run. Most of the time, a JOIN is the preferred methodology. However, there are queries where the IN statement will work just as...

The the vast and overwhelming majority of systems, you should do both.

The algorythm that decides whether or not to update statistics is pretty good, but it's not perfect. Most people...

Sounds like a good problem to have.

Buy a big box, with lots of memory... Sorry, but no one can help much past that without a lot more definition of the...

I think this one will require application of the Mk1 Eyeball and the 19xx release of Brain.

There are too many variables possible for a script to automate the process. For...

I agree, it depends.

A large majority of our applications have transaction control from the code, not within the procedures, so while we use TRY/CATCH error handling, we don't have a...

No index is automatically created when you create foreign keys.