I don't think that's what the error's saying. If you tried to create a foreign key constraint that already existed (their names have to be unique, you can have multiple...

Ideally, formatting for display done where and when the data is displayed, not in the database. The database should care about the data, not it's visual representation.

chrisn-585491 (1/11/2017)

---

Although it's a good technical achievement, I'm not sure what the business case for SQL Server on Linux is, outside a large customer(s) insisting that it run on Linux....

Although FORMAT is extremely slow compared to CONVERT.

https://sqlperformance.com/2015/06/t-sql-queries/format-is-nice-and-all-but

Yes, if the clustered index is changed, all nonclustered indexes are rebuilt with the new clustered index key in them.

I really would like to attend Bits this year (hint, hint)

Backup the DB on 2005, copy the backup to the 2012 server, restore it.

Put the part that has the column that may not exist in dynamic SQL

EXEC ('<sql statement here>')

That error is indeed a parse-time error, the entire batch gets parsed before anything...

http://sqlinthewild.co.za/index.php/2010/09/14/one-wide-index-or-multiple-narrow-indexes/

Hidden indexes?

Set it up once (selecting all tables is a...

That'll work about as well as trying to...

???

Also if i explicitly specify the cluster key in a nonclustered index...

No.

SQL 2012 had a 32-bit version, so did SQL 2014. The only version that doesn't...

Rechana Rajan (1/10/2017)

---

My doubt is when we create a Non clustered index the clustering key is already a part of it and then why adding PK column as included help...

4-part naming requires a linked server, the first part being the linked server name.

Without linked servers, you're not going to be able to directly query another server from this one.