Fair enough, so no modification of the table structures, but you should still be able to write an SSMS job, no? Or, technically speaking, you could even just use a...

Well, actually, I should have mentioned something - SSIS can only be used as a scheduled task if you have the Enterprise version (or maybe the Developer one as well,...

Well, you should ask yourself whether it's important that this process occurs instantaneously.

If it doesn't, then what I'd suggest is that you write an SSIS package which will analyze your...

Yeah, the execution plans were all identical. So, you're saying that the read-ahead reads are something that could change even if I were to re-run the exact same query? 'Cause...

Hm - nope, never even heard of that command. What's it do? I'll try it out and see if the results change any.

Well, I agree there should be no difference 😛 but there is a difference, at least in the IO statistics, which is what confuses me. What's the reason for the...

Might want to try using SSIS.

I had one application where I needed to import around 15 million records into three separate tables. Originally I had it set up through a...

You'll have to provide more than that if you want help, since like i said, just a quick test which i pasted above, shows that it works fine.

There must be...

There must be something you're not mentioning, because this works fine:

CREATE TABLE #Test

(

CounterID INT,

RecordIndex INT,

CounterDateTime CHAR(24)

)

INSERT INTO #Test (CounterID, RecordIndex, CounterDateTime)

VALUES (2, 2, '2009-08-24 10:44:14.048')

SELECT CAST(CounterDateTime AS DATETIME) FROM #Test...

SQAPro (8/25/2009)

---

Glad to see this get covered. I know this tripped me up early on in the process of learning SQL..

A more experienced person (our DBA) explained it...

well, personally never used GOTO in a stored proc, so i can't comment on that, but try this. Note that it requires SQL Server 2005+, as the TRY-CATCH blocks don't...

Okay, another question on the same note:

Is there any difference between:

SELECT Columns

FROM TableB

JOIN TableA ON SomeColumnA = SomeColumnB

AND SomeClauseFromTableA

WHERE SomeClauseFromTableB

and

SELECT Columns

FROM TableA

JOIN TableB ON SomeColumnA = SomeColumnB

AND SomeClauseFromTableB

WHERE SomeClauseFromTableA

Perfect - that's what I figured, just wanted to make sure there wasn't any hidden workings going on behind the scenes that I didn't know about.

Personally, I always put the...

Yeah, I know that for Outer Joins they will, for my purposes I'm only looking at Inner Joins though.

Fair enough - thanks for the help, I'll go with the approach of accessing the other database for the view directly.