You need to find the rows that don't convert. Try this out to find the offending rows:

CREATE TABLE #validdatesasints ( date INT PRIMARY KEY )

DECLARE @ValidDateStartValue DATE= '19000101' , --technically...

Nothing wrong with the syntax, so you must have values in the column that aren't a valid date value.

Look at the following examples:

DECLARE @lastrundate INT='20130228'

SELECT CONVERT(date, CONVERT(VARchar(18), @lastrundate))

--success

DECLARE @lastrundate...

Well, you need to check, but if you have case-insensitive collation in the database/columns, then the function is doing nothing other than preventing index seeks.

You can check the database collation...

The devil's in the detail.

A predicate/join that wraps a function around a column will indeed become un-SARGable (cannot seek on an index), so, this would cause a table/index scan, regardless...

Most internal operations (spills into TempDB in execution plans etc.) either log very little, or nothing at all, but explicitly created temporary objects (table variable, temp tables etc.) do. Are...

What do you mean by "file type specific"? The file with the ldf extension is the log file and it's used for exactly what I explained above. Perhaps if you...

Although crash recovery is never required for TempDB, transactions can be rolled back, just like in any other database. Therefore, although the logging is optimised for never requiring a roll...

Are the extensions visible in the output of the following:

SELECT * FROM sys.fulltext_document_types

If not, the filters need installing.

The physical insert will start occurring as soon as the Insert Operator in the plan has rows.

In some cases that will be pretty much immediate, but it needs to...

The Dixie Flatline (6/18/2013)

---

You can do the conversions on the fly in a single query by using expressions in your joins and where clauses. It may be...

Are you running the latest version of the MySQL Driver? There are a few closed bugs for this sort of error in the MySQL dev site.

Shared storage is not required for Availability Groups, and nor should any dependency of your replicas be shared.

I believe this network location is just requested by the wizard to do...

Nope, exactly the same. The first thing the optimiser will do when you execute the query against the view is expand the underlying definition and run that.

You can however create...

HowardW (6/17/2013)

---

It slipped my attention that it was in London this week and...

aaron.reese (6/17/2013)

---

I know you said that the VBA was writing dynamic SQL. This will have a number of performance impacts (one being that SQL will probably not be able...