MysteryJimbo (2/9/2012)

---

Interesting fact: Historically, it used to be in the UK that people drank more beer than water as it was sterile and the water was contaminated. 😀 ...

craig-962225 (2/8/2012)

---

Is there any way to force creation to fail if references are made to missing / invalid columns or permanent tables OR is there a way to globally check...

SSIS is the way to go if you want to speed this up. I find non-MS linked server connections to be really slow.

It's pretty bad looking code, but it's straight forward. It's adding and substracting numerical values.

E.g. the first select statement is returning a scalar value (a number), to which the other...

Also, what exact version of SQL Server are you running? There are a few bugs related to this error. You need to get your DBA's involved (if you have them!)...

Run a DBCC CheckDB on the database. If it's bombing out with a severe error, it could well be database corruption.

Is this what you're after?

SELECT ROW_NUMBER() OVER(ORDER BY columnA desc)

rn, columnB, columnC

FROM (SELECT TOP 10 * FROM #tableA ORDER BY columnA DESC) a

The key is that you need to...

Can you give the DDL for the mySQL table you're querying against? Any odd types?

Linked Server isn't perfect and there isn't always a one to one mapping between types,...

I'm pretty much in the opposite camp now, but that's mainly because...

Use the DMV sys.dm_db_partition_stats instead, then it's much easier to tweak.

If you want a complete solution, already built, I quite like this one:

http://www.rmjcs.com/SQLServer/DMVs/sysdm_db_partition_stats/tabid/55/Default.aspx

It's hard to get my head around the logic without really digging into it, but I'm pretty sure that you could get the effect you're after without the join to...

Why do you need to run the whole thing in BIDS? After you've debugged it with a smaller number of files, couldn't you just execute the package outside of the...

This one's particularly amusing in that not only does it have nothing at all to do with the topic, but it's not even T-SQL, it seems to be for Firebird!

I'd...

Have a look at the BOL article on TRUNCATE:

http://msdn.microsoft.com/en-us/library/ms177570.aspx

It works very differently to DELETE in that it is not selective at all, it literally wipes the table clean by deallocating...

No, or the database wouldn't be recoverable if it crashed during your transaction.

You can minimally log a TRUNCATE, but you need to have no FK's on the table and clear...