Markus (1/28/2016)

---

In place upgrade is really not something you want to do. If the upgrade fails then you have a unstable system (possibly one that is dead) and no...

No matter what the wording of the explanation is, the point of the question (CHECK constraints) is a good one. It speaks to the topic of good design, which...

Milk Shake

I would start by reading Perry Whittle's stairway at http://www.sqlservercentral.com/stairway/112556/.

I would then chose the option you didn't list:

1. Install OS on new hardware and get the cluster created. Test.

2....

It looks like you have the clicks right, but the best way is to use T-SQL.

If you must use the GUI, be sure to not overwrite the production database.

mw112009 (1/28/2016)

---

3.) My issue is why didn't the sp add the column to the table ? This is my strongest question. Had it done that, I would not have gotten...

Homemade

Delivery

ChrisM@Work (1/28/2016)

---

Ed Wagner (1/27/2016)

---

As a bit of a sidebar, I have to ask about the performance of your procedure. I saw a scalar function, non-SARGable join predicates, non-SARGable where...

It looked so simple that I found myself looking for the trick. Thanks, Steve.

Red Baron

Uh oh. I haven't heard of anything quirky with SQL 2012 SP3 yet, but would be very interested if anything comes up. I haven't installed it yet and...

Charlie Brown

What Michael posted about the calculation on the column (which is called a non-SARGable predicate) is spot on. This is inefficient with a table of any size, but you'll...

Since you said you can send your results if you're sending less than 4000 rows, it sounds like you have database mail set up correctly. I don't think there's...