Oh, and yes, you should have a clustered index on most of your tables (most being 99.9999999999%) or have a very good reason why not, with testing and good documentation....

All the testing I've done with GUID's as a clustered index have shown some serious performance problems. The one thing that alleviates this somewhat is to use the SEQUENTIALID mechanism....

Yes = Laptop, Desktop, Books, Drivers License

No = everything else.

How on earth do you function as a DBA, let alone post on SSC without a desktop or a laptop? You...

Andrew Watson (9/7/2009)

---

I chose 1 as well.

When faced with a problem like this, my brain automatically went into "performance problem" mode, and since these generally occur with big datasets, I...

Paul White (9/7/2009)

---

Grant Fritchey (9/7/2009)

---

Really? That's a bit of a disappointment. I hadn't picked up the 2008 version, but I was planning to. You might have just saved me a...

Paul White (9/6/2009)

---

Couldn't agree more. The mentioned books are pretty much the only ones you'll need - though T-SQL Programming is less in-depth than the others, and more of...

When you say it failed to update, do you mean that it returned an error or that the query ran fine, but no data was updated?

There has to be an...

crainlee2 (9/5/2009)

---

Grant,

I don't think so. I'm running DTA as a server and dba admin with authority to do anything so I don't think that's it but thanks for asking about...

And just to add to that a bit, shrinking the database is not a method for optimizing performance. It's a little shocking that a vendor is recommending this as a...

Excellent post sudhanva. Very well summarized. I agree, there are few, if any situations where stored procedures should not be used.

Unfortunately, I need to point out one issue:

sudhanva (9/5/2009)

---

...

Not to...

Every time I use the DTA I'm impressed by what it misses. Yes, you could try making adjustments to the template and you will get more suggestions, not necessarily good...

AllenMWhite (9/4/2009)

---

In case I didn't mention it before, you can run scripts using SQL 2008 SMO against SQL 2005 and SQL 2000 servers. SMO doesn't support SQL 7 or...

AllenMWhite (9/4/2009)

---

Ah. Ok. Go to Michiel Wories' blog post here:

http://blogs.msdn.com/mwories/archive/2008/06/14/SQL2008_5F00_Powershell.aspx

Copy out the script in that post. Once you've executed that, you've got the SQL 2008 dlls and...

AllenMWhite (9/4/2009)

---

Thanks, Grant. I really wanted to see yours as well, but I'm at a client site during the day and couldn't.

You can install PowerShell 1.0 on any Windows...

Hey Allen. Great presentation the other day.

So, what about just installing Powershell on a 2000/2005 server, or what if the 2000/2005 is running on a 2008 Server machine? Can you...