Viewing 15 posts - 13,126 through 13,140 (of 14,953 total)
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...
June 27, 2008 at 9:05 am
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...
June 27, 2008 at 8:42 am
OpenQuery is what I was going to suggest as well, if you need this to be dynamic.
June 27, 2008 at 8:32 am
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...
June 27, 2008 at 8:29 am
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...
June 26, 2008 at 2:37 pm
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...
June 26, 2008 at 2:21 pm
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...
June 26, 2008 at 2:19 pm
The best way is to check the procedure. That way, you can also check what data types each column is, etc.
June 26, 2008 at 1:59 pm
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...
June 26, 2008 at 12:59 pm
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...
June 26, 2008 at 12:56 pm
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...
June 26, 2008 at 12:53 pm
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...
June 26, 2008 at 12:48 pm
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...
June 26, 2008 at 12:31 pm
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...
June 26, 2008 at 12:26 pm
Viewing 15 posts - 13,126 through 13,140 (of 14,953 total)