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...

Careful, when the servers finally do come back online, hopefully the database team won't be slumped face down on their desks snoozing. Or...

If you're looking for distinct members in one that don't exist in the other, or possibly members that exist between the two, then consider the EXCEPT and INTERSECT operations.

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

-- selects...

Are you using distributed queries, that is a select statement that joins between the local and remote server using four part naming convention?

Or are you using pass-through queries, that is...