Quick thought, be careful when implementing a trigger with a single value logic and a transaction rollback, chances are that this will cause problems down the line. A more robust...

Probably one of the most important factors here is the index maintenance, as the "health" of the index can greatly affect the performance, even in some not so exceptional cases....

Quick thought, check the file system permissions for the account on the folder specified (<path>)

😎

Digging slightly deeper into this in order to explain this behaviour:

1) Without the parenthesis, this is a simple select query and the server scans the table for all matching entries....

dcarter 43846 (10/11/2014)

---

Hi

I have a source table with an xml column that I need to query on the nodes and then depending on what data is in the node then...

Quick thought, the former returns an empty set and no assignment takes place, the latter returns a set with a empty (null) column whitch is assigned to the variable.

😎

Junglee_George (10/10/2014)

---

I am now using a SELECT DISTINCT to avoid the duplicate records from retrieving.

I can remove this DISTINCT keyword from the query once the OUTER APLLY is changed to...

It is a separate download, SQL Server Data Tools for SQL Server 2014.

😎

The SSDT 2014 is an additional download (last time I checked). To run the 2012 jobs/packages on the 2014 system there are two options, install the 2012 SSIS components on...

ramana3327 (10/11/2014)

---

Hi,

The job is running in Sql 2012 succefully.

I migrated that job in to Sql 2014 instance that is running in seperate box.

The job is running the ssis package. That...

Jeff Moden (10/11/2014)

---

This kind of information is available in a tool called "Books Online". It's the "Help"...

Just for fun, here is a union alternative, certain that this is not the most efficient solution but it is simple to write and fun to play with, uses XML...

Eric M Russell (10/11/2014)

---

There are...

ramana3327 (10/10/2014)

---

Hi,

I installed sql 2014 enterprise edition. I didn't see any visual studio installation by the selection of Integration Service. Where we can develop the Packages?

I am giving the attachment...

Worked for a national statistics office a while back, seen some "interesting" interpretations especially when politics get thrown in the works, very CREATIVE business:-P

😎