This will be ringing alarm bells among seasoned users of the site, who will be wondering why you...

Don't use nvarchar. Use nvarchar(size).

DanMcClain (6/12/2015)

---

I think its great that Microsft does the early (not always perfect) for us early adopters. We have SQL 2014 in production utilizing Column store index, filetables, and In-memory....

Paul Sims-405749 (6/11/2015)

---

Phil, not sure I understand the question. When I branch and then open the branched solution the reference are there, however they are invalid. It's almost like these...

JOIN the tables.

Continuing with your theme of minimal information:

Select Name, Surname

NOT EXISTS is generally the more performant, because of the short-circuiting built into that construction.

But you should verify it for yourself by testing and examining execution plans.

Sioban Krzywicki (6/11/2015)

---

Microsoft has always, always released what they had and then improved it later. Every product they have has gone through this. The initial products were frequently derided, but...

vipin_jha123 (6/11/2015)

---

Hi,

I have created one variable name migration_start datetime

which give me default format of 6/11/2015 1:26 AM

But I expecting to get in 2015-06-11 01:26:22.813 format.

kindly suggest me the...

terry_stjean (6/10/2015)

---

I'm importing text data and using the Data Conversion task to convert some of the olumns.

I have the task set to redirect the row if the conversion fails so...

Are the referenced items part of the branch?

Something...

Phillip.Putzback (6/9/2015)

---

I was wondering what the pros and cons to alter the variables in a script task or expression editor are. I have been changing values in the Script task...

Paul Sims-405749 (6/9/2015)

---

I've imported a database schema into VS2013 from a Prod database. After a little bit of cleaning I want to create a test deployment script to confirm there...

Execution plan,...