Rune Bivrin (6/25/2012)

---

I beg to differ. You can't define indexes on table variables. You can define constraints that will cause SQL Server to create indexes under the hood, but that's...

I see no problem with the wording. Can a table variable have indexes defined, yes or no? Yes, it can. That's all that was asked - what...

L' Eomot Inversé (6/14/2012)

---

Most of those errors were the same wrong answer, there appears to a widely distributed myth that any primary index is clustered unless it is declared as...

Ooo! Ooo! Ooo! That one.

ron

TravisDBA (6/1/2012)

---

I absolutely understand your pain. Personally, I never let any company "pigeonhole" me into a job that is contrary to my career goals. That is where you have to...

And of course management falls under...

I took c to be "miserable in my job, and I'd take a greeter's job at Walmart if they'd pay me enough to cover my mortgage." I'm in the...

Wow, within minutes I'm pretty sure I'm just about there. Thank you so much for that, extremely helpful. (I went with PATH... I completely get it now.)

Thanks so...

Thank you Drew, I will start digging into this immediately.

Much obliged!

Ron

Okay, hopefully you can contain your laughter before you pass out from oxygen deprivation... 😉

SELECT

( SELECT

( SELECT Company_ID AS id,

...

I will try to translate my current failure into the context of this example and post it ASAP.

Thanks!

ron

The only reason I had to think about it a while is that I would never combine AND and OR without parentheses, so that fact was a bit dusty in...

GilaMonster (3/27/2012)

---

Ok, terminology problem here...

Statistics in SQL Server are objects that are stored in the database, you;'ll see them listed in sys.stats. So when you said 'statistics getting dropped', people...

I have more information. I launched our application against the db that lost its stats. I opened SSMS, opened a new query connected to that database, and queried...

Nope, nothing like that. Just two databases sitting there unattended, minding their own business.

ron