Viewing 15 posts - 2,851 through 2,865 (of 3,061 total)
Any particular reason why you expected it to shrink?
Have you set your database to autoshrink?
On the other hand, it will never shrink to a size smaller than the original allocation...
October 13, 2008 at 10:46 am
That's the beauty of it Robert, that's why ice cream comes in dozens of flavors 😀
In regards to your position about relational theory, best practices and staging tables being as...
October 13, 2008 at 8:37 am
Open Management Studio, New Query...
use your_database
go
execute your query
Right-click on result grid... Save as
October 13, 2008 at 5:50 am
Just to clarify the point, you still have to choose a Collation -Page Code - for your non-Unicode data.
The Collation you choose does not affects data stored in Unicode datatypes...
October 12, 2008 at 5:38 am
:doze:
Gents... poster just asked for a list or questions, unfortunately poster ignored wildh follow-up question which was spot-on. The answer -to wildh - would actually define how to answer the...
October 12, 2008 at 4:34 am
GilaMonster (10/12/2008)
October 12, 2008 at 4:21 am
Mike (10/11/2008)
October 12, 2008 at 2:47 am
By the way... may I point at another -less sensitive - kind of tables doesn't make sense at all to have a PK?
How about Monitoring, Auditing and Error logs?
Either if...
October 12, 2008 at 2:44 am
Jeff Moden (10/11/2008)
Heh... and by the way... this...T - you do whatever transformation or massaging is needed...
... sometimes means deleting duplicated data. 😉
Nope. We do not delete on Staging. Period....
October 12, 2008 at 2:35 am
Jeff Moden (10/11/2008)Nope... for a decent size company, that's about what I'd expect except it might be missing the "Project Management" layer.
For some of the small companies I've worked for,...
October 12, 2008 at 2:01 am
GilaMonster (10/11/2008)I don't see why I would want to fail the entire load if I know there's dups in the source data that, for whatever reason, cannot be removed from...
October 11, 2008 at 1:06 pm
Gail -- you are not reading my posting, let me quote myself once again 🙂
L - you attempt to populated FACT and DIM tables -reporting failures.
October 11, 2008 at 12:37 pm
Jeff Moden (10/11/2008)I'll add an IDENTITY column as PK even on staging tables. Being stuck in the world of SQL Server 2000 means I don't have slick tools line...
October 11, 2008 at 12:16 pm
:w00t:
CIO
|___ PMO
|
|___ Infrastructure
| |
| ...
October 11, 2008 at 12:07 pm
Just script them as Greg said in reply #1!!! :crazy:
October 11, 2008 at 11:41 am
Viewing 15 posts - 2,851 through 2,865 (of 3,061 total)