Viewing 15 posts - 106 through 120 (of 191 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...
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
February 21, 2012 at 2:22 pm
Thank you for that link! I will explore it as soon as time permits.
thanks!
ron
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...
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
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
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,...
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...
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...
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...
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...
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
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...
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...
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....
October 18, 2011 at 5:47 am
Viewing 15 posts - 106 through 120 (of 191 total)