Viewing 15 posts - 631 through 645 (of 1,353 total)
You have not provided any information on how big this table is
As has been said, you have not said anything about this. If the table is so small that...
May 13, 2015 at 7:17 am
The latest issue to arise is that if people query a datamart (the fact and dim tables, not the cube) while a refresh is in progress they'll get the wrong...
May 13, 2015 at 7:13 am
Thanks for the clarification. Good stuff.
May 6, 2015 at 7:55 am
Interesting. I'll have to do more investigation.
@Gail--I've normally used #temptables to load objects (e.g. offices, jobsites etc) to which someone had access. This table would then connect with...
May 6, 2015 at 7:41 am
Can't this be overcome by explicitly dropping the temp tables in the connection. Yes, in theory it goes away, but my understanding is that it doesn't go away in...
May 6, 2015 at 7:31 am
Heck, many of the dbs I've managed were < 1GB, so complexity doesn't matter. In those cases, striping doesn't help. It hampers restores when I need remote hands.
I agree....
May 5, 2015 at 9:13 am
It is definitely not so.
Good to know. Thanks. I would have had a false sense of security.
May 5, 2015 at 8:58 am
I'm with Gail, somewhat on this. It's not that I think it's harder for me to restore or recover, but it is slightly less readable and confusing. That's the concern...
May 5, 2015 at 8:49 am
Gah! No, don't do that.
Corruption is 99% of the time an IO subsystem problem. A misbehaving IO subsystem isn't going to check how often a table is updated before it...
May 5, 2015 at 8:40 am
You should also generally expect a 20% reduction in SELECT performance and a 20% growth in the size of the index and a 20% increase in the memory usage of...
May 5, 2015 at 8:22 am
Yes, you can do that. Has it achieved anything?
I'm not fond of making decisions because 'that's the way it's done'. I make design decisions based on expected usage or measured...
May 5, 2015 at 8:16 am
RonKyle (5/4/2015)
--------------------------------------------------------------------------------
But if the filegroup would become corrupt, I've made it harder to recover.
Not necessarily. Depends on the type of corruption. If the system tables get hit, that's a full...
May 5, 2015 at 7:47 am
Just a really simple idea.
Try setting PAD_INDEX = ON and FILLFACTOR = 80 as an initial step.
I recently did something like this in a situation you describe and it worked...
May 5, 2015 at 6:38 am
My experience is that lots of times I run into databases or I leave them and others struggle to deal with DR situations because they're confused by something that isn't...
May 4, 2015 at 11:17 am
Actually, when given the opportunity I would also create a separate file group for the data and make it the default file group. I would go even further if it...
May 4, 2015 at 9:35 am
Viewing 15 posts - 631 through 645 (of 1,353 total)