Viewing 15 posts - 106 through 120 (of 192 total)
GilaMonster (2/21/2012)
The clustered index key is present in all nonclustered indexes. That's one of the reasons that the clustered index is recommended to be on a non-changing column.
Hmmm... that makes...
-----
a haiku...
NULL is not zero
NULL is not an empty string
NULL is the unknown
February 21, 2012 at 2:26 pm
AKKK! Yes, that's it. Well this is gonna get ugly, I guess. Thanks for the pointer.
ron
-----
a haiku...
NULL is not zero
NULL is not an empty string
NULL is the unknown
February 21, 2012 at 2:22 pm
Thank you for that link! I will explore it as soon as time permits.
thanks!
ron
-----
a haiku...
NULL is not zero
NULL is not an empty string
NULL is the unknown
February 9, 2012 at 7:18 am
I agree, it sounds pretty hopeless, and the customer realizes it. They're going to pay someone to try and restore the data, and more power to them. If...
-----
a haiku...
NULL is not zero
NULL is not an empty string
NULL is the unknown
February 8, 2012 at 2:44 pm
That's kinda like saying you can have an unlimited number of deer ticks in your underwear. Sure, you can... but why would you want to?
ron
-----
a haiku...
NULL is not zero
NULL is not an empty string
NULL is the unknown
December 22, 2011 at 6:01 am
GilaMonster (12/20/2011)
Dunno, what are you defining as 'logical corruption'? It's not a standard term.
Sorry, I'd been reading >>this article<< this morning.
Thanks for all the help.
ron
-----
a haiku...
NULL is not zero
NULL is not an empty string
NULL is the unknown
December 20, 2011 at 11:50 am
Oh! I almost forgot my original question. So... this would be logical corruption, then? Because the values are screwy? I'm sorry to be such a n00b,...
-----
a haiku...
NULL is not zero
NULL is not an empty string
NULL is the unknown
December 20, 2011 at 11:27 am
GilaMonster (12/20/2011)
What recovery model and what is your backup strategy and frequency?
Recovery model is full, the backup strategy is something I'll need to talk to the customer about. (This...
-----
a haiku...
NULL is not zero
NULL is not an empty string
NULL is the unknown
December 20, 2011 at 11:19 am
GilaMonster (12/20/2011)
As for how to fix, you posted an incomplete checkDB output, there's at least one, hopefully two more lines to the output. Please post them.
Sorry, I was hoping to...
-----
a haiku...
NULL is not zero
NULL is not an empty string
NULL is the unknown
December 20, 2011 at 10:55 am
SQL Kiwi (12/6/2011)
Writing a question to demonstrate the equivalence of SQL expressions is very brave, so well done for that. Small point: in the explanation you say, "the...
-----
a haiku...
NULL is not zero
NULL is not an empty string
NULL is the unknown
December 6, 2011 at 5:51 am
The only thing that tripped me up was:
The amount of space used DOES depend on the fragmentation of the index that supports the FOREIGN KEY constraint.
I took this to...
-----
a haiku...
NULL is not zero
NULL is not an empty string
NULL is the unknown
November 9, 2011 at 6:09 am
Ninja's_RGR'us (10/19/2011)
Glad you're on the "good" side of things!
How could I look at that cute little face and assume there was potential for even a shred of evil behind it?
ron
-----
a haiku...
NULL is not zero
NULL is not an empty string
NULL is the unknown
October 19, 2011 at 8:11 am
Ninja's_RGR'us (10/19/2011)
P.P.S. I never meant to say you were the one executing the 10 t error :-).
Oh I know. I made a conscious decision not to take it that...
-----
a haiku...
NULL is not zero
NULL is not an empty string
NULL is the unknown
October 19, 2011 at 8:06 am
Ninja's_RGR'us (10/19/2011)
Since copying the files doesn't edit them, that just can't happen.
Maybe you...
-----
a haiku...
NULL is not zero
NULL is not an empty string
NULL is the unknown
October 19, 2011 at 6:38 am
Since I'm totally lost and still don't get it after reading this entire thread, I'm just going to stay away from the decimal type for the rest of my career....
-----
a haiku...
NULL is not zero
NULL is not an empty string
NULL is the unknown
October 18, 2011 at 5:47 am
Viewing 15 posts - 106 through 120 (of 192 total)