Jeff Moden (6/26/2008)

The other option was taking each line of the calculation, adding a column to a join table between the two sets, and calculating one column at a time...

I bet you created a table with columns like "Question1", "Answer1", "Question2", "Answer2". Something like:

create table Exams (

ExamID int identity primary key,

Question1 varchar(100),

Answer1 int,

Question2 varchar(100),

Answer2 int,

... and so on...

OpenQuery is what I was going to suggest as well, if you need this to be dynamic.

What I'd do next is fire the thing up and run it like 10-thousand times from 10 connections, and log it. Find out what's in common between the ones...

You might also want to make sure there aren't any tables that are referenced by operational code, but which don't have rows at the moment.

For example, I've seen code that...

The Case statements in the SQL string aren't written correctly.

Change "CASE p.ID_Pessoa" to just "CASE". If you have a variable or column name after Case, you can't do complex...

Yes. Save the script, restore the production database to the dev environment, run the script on it. Up-to-date data, and if the script fails to run correctly, then...

The problem is the Where clause:

"WHERE (dbo.[Prevention Response].Date > CONVERT(DATETIME, '2007-12-31 00:00:00', 102))"

If an employee doesn't have any entries in Prevention Response, the Date column will...

The best way is to check the procedure. That way, you can also check what data types each column is, etc.

I don't think replication will work if you start making changes to the target database. I could be wrong about that, but I'm pretty sure it doesn't really allow...

I'd use ApexSQL Diff for this. I haven't tried the RedGate product, but I'm sure it would do it just as well. (I have a lifetime free-upgrades license...

It sounds like someone came up with the brillant* idea of storing meta-data for other tables in a "master table".

If you're stuck with that database, you're probably stuck with dynamic...

I currently use 2 table-valued functions. With those, it's high-performance, many-reuse code, and neither of them uses any table variables. (Inline select functions) That means they can...

There are a number of ways to do this. The one I find easiest is to go to tempdb in Management Studio (under System Databases), right click and go...

I recommend "SQL Server 2005 Bible" by Paul Nielsen. His SQL 2000 Bible is what got me started as a DBA, and it made the whole thing a LOT...