One other caveat to keep in mind is that while rebuilding an index will update the stats for that index, column-level statistics will not get updated by the rebuild. I've...

I might be missing something, but it doesn't seem so mysterious why those don't return the same results.

I'm assuming here that you're actually comparing the second version to this (from...

Jason A. Long (8/19/2015)

---

Jacob Wilkins (8/19/2015)

---

Hmmm...I'm not sure I follow. The results of my original query exactly match the contents of test2, his desired results, with his sample data.

It...

Hmmm...I'm not sure I follow. The results of my original query exactly match the contents of test2, his desired results, with his sample data.

It looks like your sample data...

For a 2008-friendly version (as Jason indicated, his won't work prior to 2012, because ORDER BY was not supported for aggregate window functions yet; it only worked for ranking window...

Yes, if they were both numeric(9,2) then there should not have been any rounding. If either value were real instead of numeric(9,2), then the result would make sense, because the...

I prefer to avoid all that silliness and set DBs offline with rollback immediate prior to restoring on top of them. I'm quite confident no one else is connecting then...

Eirikur Eiriksson (8/13/2015)

---

Jacob Wilkins (8/13/2015)

---

Heh, things like that with names always make me shake my head. I recently ran across a database that had table in the dbo schema that...

SQLRNNR (8/13/2015)

---

Jacob Wilkins (8/13/2015)

---

Just to take a stab at this, it sounds like maybe you're wanting a sort of audit, either of which users/roles have what permissions, or of which...

Just to take a stab at this, it sounds like maybe you're wanting a sort of audit, either of which users/roles have what permissions, or of which users/roles have accessed...

Heh, things like that with names always make me shake my head. I recently ran across a database that had table in the dbo schema that also had 'dbo.' as...

Koen Verbeeck (8/13/2015)

---

OK, I didn't select the option with the in-memory table, because the sentence ends with only.

This made me believe the answer suggested that you could only create columnstore...

I'm glad I could help 🙂

Cheers!

I know that's how you're assigning the variable a value. What I'm saying is that the behavior you're describing indicates the value is NULL, not 0.

I'm suggesting running a...

That sounds more like @p1 is NULL. Have you confirmed that the value of @p1 is actually zero and not null in these cases?

I'd suggest adding the following SELECT after...