Viewing 15 posts - 91 through 105 (of 192 total)
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...
-----
a haiku...
NULL is not zero
NULL is not an empty string
NULL is the unknown
June 25, 2012 at 8:11 am
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...
-----
a haiku...
NULL is not zero
NULL is not an empty string
NULL is the unknown
June 25, 2012 at 7:42 am
L' Eomot Inversé (6/14/2012)
-----
a haiku...
NULL is not zero
NULL is not an empty string
NULL is the unknown
June 14, 2012 at 5:56 am
Steve Jones - SSC Editor (6/1/2012)
The option was supposed to be c) get me out of here ASAP
Ooo! Ooo! Ooo! That one.
ron
-----
a haiku...
NULL is not zero
NULL is not an empty string
NULL is the unknown
June 1, 2012 at 8:26 am
TravisDBA (6/1/2012)
-----
a haiku...
NULL is not zero
NULL is not an empty string
NULL is the unknown
June 1, 2012 at 8:07 am
Megistal (6/1/2012)
Something which is not always look at is:your co-workers.
They can make your job either like heaven or like hell even within the organization rules.
And of course management falls under...
-----
a haiku...
NULL is not zero
NULL is not an empty string
NULL is the unknown
June 1, 2012 at 5:56 am
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...
-----
a haiku...
NULL is not zero
NULL is not an empty string
NULL is the unknown
June 1, 2012 at 5:42 am
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...
-----
a haiku...
NULL is not zero
NULL is not an empty string
NULL is the unknown
May 29, 2012 at 2:33 pm
Thank you Drew, I will start digging into this immediately.
Much obliged!
Ron
-----
a haiku...
NULL is not zero
NULL is not an empty string
NULL is the unknown
May 29, 2012 at 2:18 pm
Okay, hopefully you can contain your laughter before you pass out from oxygen deprivation... 😉
SELECT
( SELECT
( SELECT Company_ID AS id,
...
-----
a haiku...
NULL is not zero
NULL is not an empty string
NULL is the unknown
May 29, 2012 at 2:16 pm
I will try to translate my current failure into the context of this example and post it ASAP.
Thanks!
ron
-----
a haiku...
NULL is not zero
NULL is not an empty string
NULL is the unknown
May 29, 2012 at 1:53 pm
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...
-----
a haiku...
NULL is not zero
NULL is not an empty string
NULL is the unknown
May 24, 2012 at 5:51 am
GilaMonster (3/27/2012)
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...
-----
a haiku...
NULL is not zero
NULL is not an empty string
NULL is the unknown
March 27, 2012 at 6:37 am
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...
-----
a haiku...
NULL is not zero
NULL is not an empty string
NULL is the unknown
March 27, 2012 at 6:20 am
Pradyothana Shastry (3/27/2012)
Any job which dropped and recreated tables?
Nope, nothing like that. Just two databases sitting there unattended, minding their own business.
ron
-----
a haiku...
NULL is not zero
NULL is not an empty string
NULL is the unknown
March 27, 2012 at 6:11 am
Viewing 15 posts - 91 through 105 (of 192 total)