Unless you change the hardware, a database server will always run at the same speed. However, individual process typically sprint, stop and wait, sprint, stop and wait, etc. It stops...

I'm not a fan of Test Driven Development, as John is. Usually this is because I'm not always 100% sure of the results I want or have been given. I've...

kim / data detection group (9/17/2015)

---

Of course, SQL Server could certainly benefit by implementing the Package concept that Oracle provides.

You can bundle all your related procedures and functions into a...

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