For denying updates on column, you can use the DENY statement to set column-level permissions. Check Books Online for the syntax. This might even remove the need for an INSERT...

Please post a repro script. Not with millions of lines - try to create a repro script that is as small as possible, yet shows the same problem you are...

Jeff Moden (3/6/2016)

---

That's one...

In addition to Gianluca's suggestion, here is a link to a good article: https://www.simple-talk.com/sql/backup-and-recovery/sql-server-2014-backup-basics/%5B/url%5D

(Do not worry about the "2014" in the title, the basics are the same in all versions...

If it's a critical server and you are...

Then you should add that trace flag to the query.

Don't worry, it is a...

Yes, you can, and you could use those affinity masks for that (but read the note below). So with your eight cores, you could for instance assign two cores to...

tnpich (3/6/2016)

---

To Hugo’s comment “I agree that having an explicit column to show the step (either as a number or as a code) is probably a much better idea.” ...

SteveD SQL (3/5/2016)

---

the challenge I came across was linking the Department-Team-Role combination to the Services table and other tables that need to link a Department-Team-Role. I wanted a single table...

In the designer, click the cell you want to affect, click the color (or background color) property in the properties window, then enter a formula such as the one below:

=Switch(Fields!City.Value...

Partitioning is not a performance feature. Indexing should help you lots more.

RonKyle (3/5/2016)

---

A blank string does not mean that it is known that there is no value; a blank string means that it is known that there is a value, and...

Define "advantage".

Are you looking for performance benefits? Then partitioning provides little advantage, regardless of single or multiple disks.

Are you looking for easier management with swapping partitions in and out? Then...

Mvs2k11 (3/5/2016)

---

Thanks a lot..

The provided query works fine however when I ran the query against with 1 million records which is failing due to maximum recursion error and I have...

The simplification you made should make the plan a lot simpler, and should help the optimiizer get a good estimate.

Before playing with the trace flags, please try updating statistics first!