If any of the application or user accounts have sysadmin membership, then that complicates the issue. However, another option to mitigate that is to alter login status to disabled for...

Ideally you will never have invalid column values inserted in the first place, because once the bad data is in the table, then all the downstream applications have to tiptoe...

Did you look into using TRY_PARSE() ?

Rather than telling you True or False if value is "numeric", it will tell you if the value will cast as a specific data...

null

How long has the command been running when the timeout occurs?

In your client, have you set connection timeout and command timeout to 0 or some reasonably long duration?

mitzyturbo (9/25/2015)

---

Thanks Eric, I'll try that the next time the problem arises

Unfortunately I can't reproduce it all the time to test this, but if I can get it running slowly...

I'd expect the 2nd execution of the query to be faster, even with the same plan and number of logical reads, because it's re-using pages from the buffer cache that...

Regardless of industry, whether it's healthcare or adultery, table columns containing personal identifiers should be encrypted and then downstream applications, ETL processes, and backups should decrypt only as needed and...

There are hints that can force joins to occur locally or remotely, but the way I've worked around this issue in the past is to pull the data I need...

Starting with v2012, we have the TRY_PARSE() function. It works very similar to CAST(), except instead of 'Conversion failed...' error, it will simply return NULL.

https://msdn.microsoft.com/en-us/library/hh213126.aspx

print cast('123'+char(160) as int);

Msg 245,...

Steak, 20oz margaritas, and Mexican sombreros should help take the edge off.

If page compression is enabled, the raw data won't look like clean fixed width records when viewed with something like a Hex editor. My understanding is that recurring strings and...

Jeff Moden (8/19/2015)

---

Jacob Wilkins (8/19/2015)

---

I prefer to avoid all that silliness and set DBs offline with rollback immediate prior to restoring on top of them. I'm quite confident no one...

EricHansen,

What you're proposing is edgy, and perhaps you're earnestly advocating this use of MS Jet database, because that's the database and set of API you're most familiar with. However, it...

There are 3rd party applications that can read SQL Server backups, so the file format must be published in public domain. It may not contain all the data necessary to...