Sean Lange (9/16/2016)

---

Eirikur Eiriksson (9/16/2016)

---

Sean Lange (9/16/2016)

---

Eirikur Eiriksson (9/16/2016)

---

ThomasRushton (9/16/2016)

---

Thom A (9/16/2016)

---

ThomasRushton (9/16/2016)

---

Sean Lange (9/16/2016)

---

BWFC (9/16/2016)

---

jasona.work (9/16/2016)

---

Thom A (9/16/2016)

---

ThomasRushton (9/16/2016)

---

These posts offering ways to get rid of weight loss? ...

There are at least a couple ways. Your comparison in the CASE expression could check for equality between the values of those columns cast as DATE, or you could just...

Seems like you have time components in the columns you're comparing.

You're wanting it to just compare the date portion, but it's going to compare the full values of both...

Just to throw my $0.02 in, I definitely agree that seeing low PLE does not necessarily mean there's a problem. As Kevin and others have mentioned, if the performance of...

Just another quick note to make sure we don't spend a lot of time barking up the wrong tree: Unless I've gone completely crazy (always a possibility), the query for...

As I recall that usually happens when using the SSMS GUI to create the column under some conditions (bugs, mostly, if memory serves).

Have you tried adding the column with TSQL?

Cheers!

Glad to help!

Yeah, ran a few quick tests, and it seems that pattern happens when two conditions are met: you reference a unique index in the WHERE clause and it's...

My guess would be that at least one of the indexes being affected by the UPDATE is defined as UNIQUE.

I seem to recall that TOP operators show up in...

The Dixie Flatline (9/9/2016)

---

Okay.... although I'm not going back into the divide by zero thread.

Both SET ANSI_WARNINGS OFF and SET ARITHABORT OFF will give him the...

Yeah, this behavior due to the typing has caused quite a bit of grief in the community.

There have been several connect items reported for it, including https://connect.microsoft.com/SQLServer/feedback/details/791155/round-function-returns-arithmetic-overflow-for-literal-values-0-5-and-1, where Paul White...

The behavior you're seeing is by design, and is described here: https://support.microsoft.com/en-us/kb/918346

While it only specifies 2005 and 2008 in the kb, it applies in 2014 as well under the conditions...

There are a couple things to check.

First, the version of SSMS you're using isn't what determines this. It's the version of the instance you're connecting to.

The query Lynn suggested will...

Sean Lange (9/6/2016)

---

Ed Wagner (9/6/2016)

---

Sean Lange (9/6/2016)

---

ChrisM@Work (9/6/2016)

---

Sean Lange (9/6/2016)

---

Luis Cazares (9/6/2016)

---

Sean Lange (9/6/2016)

---

I tried my hand at curing my own bacon for the first time. It came out of...

As with many things in mathematics, this isn't necessarily a question of wrong/right. It's more a question of what is useful,elegant, parsimonious, etc. (sort of like treating the equals sign...

Check Martin Smith's excellent answer at StackExchange about temporary tables vs table variables, particularly the bit about storage location: http://dba.stackexchange.com/questions/16385/whats-the-difference-between-a-temp-table-and-table-variable-in-sql-server

Cheers!