info (3/1/2009)

---

Imagine I have two tables: Manager and Player. This is for a football team, where several players can play for one manager only and a manager manages several (11)...

That's way more information than can be easily answered in a post on a board. Performance tuning has three major areas of concern, the OS & Server, which you usually...

I'd suggest a couple of different things. First, have you checked the execution plans on your select statements to be sure that the indexes on your tables are being used....

I'd suggest getting all the database objects into source control. Then, make all your changes through the scripts, not by editing the database through Management Studio. You should very carefully...

It's in the Books Online, the SQL Server documentation. Just look up sp_recompile and read what's there.

David Sumlin (2/27/2009)

---

I haven't played with SQL 2008 yet. Does anybody know if anything along these lines has been introduced in SQL 2008?

If not, almost makes me want to...

Ah, if you want to collect errors, this won't help at all. It's only going to show completed queries. You'll need to set up a server side trace.

Howerver, a slightly...

Jeff Moden (2/27/2009)

---

Oracle... when code is autogenned, it comes out in all uppercase for things like column names whether you want it to or not. Oracle peeps have gotten...

Profiler doesn't debug queries. It captures performance and behavior. I'm not aware of a third party tool that does everything that it does.

However, just because you don't have Profiler doesn't...

Just to help the newbiezzzzz a bit further, this is an Access bit of code you're writing, not T-SQL inside SQL Server 2005, right?

No, that's probably not a great way to go about it. Instead have a many-to-many join table between the two other tables. So you'll have a ChangeRequest table and a...

I see a loop and I want to eliminate it, if possible. But you're right, of course.

I still think partitioning the data would be a better approach rather than having...

Will they still compile? Leave 'em there. If not, clean 'em out.

Jeff Moden (2/26/2009)

---

Absolutely spot on. And, I'm also amazed that companies don't do a full background check on their DBA's. At the very least, I'd prefer to have...

What? You don't know about Type II? You been living in a cave?