I'm assuming the scenario is that you have two clients in separate SQL Server instances, each having overlapping sequential integer identifiers, and so you need to assign new identifiers as...

TheSQLGuru (12/28/2015)

---

Ooh, another thing I will chime in with. Some of the WORST things I see done on SQL Server have nothing to do with the databases/applications they run -...

In addition to what's already been mentioned above:

On the fly data type conversion and transformations, both explicit and implicit

Distributed queries (ie: joining tables between multiple instances via linked server...

To balance out the concerns regarding taxes and health insurance, consider a long term contract ostensibly means less time sitting on the bench between gigs. For that reason, your rate...

.. One of the primary reference data points in the article is that 34% of US workers engage in freelance work. There's a reference to a study that says 41million...

Well, im still not sure about RegEx in a data warehouse. Parsing text columns suggests things like product descriptions were not identified by category in a way thats useful to...

Phil Parkin (12/26/2015)

---

Solomon Rutzky (12/26/2015)

---

Just out of curiosity,...

The easiest thing to do would be to disable trigger, insert in one shot, and then re-enable trigger.

I cant believe they've got you doing this b.s. on Christmas Eve....

This should work.

- You didn't need the full name of the tblcall table in the WHERE clause, only the alias + column name.

- Also, in the JOIN clause,...

phonetictalk (12/24/2015)

---

It would be fascinating to hear from the developers in stories like this (at least anonymously).

Was it due to pressure, or was it due to a lack of experience/knowledge?...

Since it's .XLSX, make sure the connection is using the provider that supports Excel 2007+ instead of the provider for the older .XLS format.

My kids had (and still use occasionally today) a VTech Leapster handheld game console. However, we never registered it; they simply play the games. It's not neccessary for comanies to...

Yeah, but could you reproduce the non-blocking behaviour?

With the exception of secure document storage, I don't see the point in containing BLOBs in a relational database. With what you're suggesting, the website would hit your database whenever...

I actually can't reproduce this. I'm using SQL Server 2014, and Session 2 WILL wait for Session 1 to commit on the 2nd run, which is what we'd normally expect...