Some tips for working with big data models

Question

Some tips for working with big data models

Viewing 7 posts - 16 through 21 (of 21 total)

You must be logged in to reply to this topic. Login to reply

Ian Scarlett SSC-Insane Points: 23197 More actions · Answer 1

Brandie Tarvin (3/4/2011)
I couldn't help myself. I posted a comment on Alok's blog:

I can't see your blog comment Brandie, but look at the other articles in his blog... virtually every one of them is a cut and paste job.

Brandie Tarvin SSC Guru Points: 173080 More actions · Answer 2

He has moderation set on his blog comments. I'm betting he won't allow anyone to see it.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 3

Brandie Tarvin (3/4/2011)
He has moderation set on his blog comments. I'm betting he won't allow anyone to see it.

To the law-mobile!

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 4

Steve Jones - SSC Editor

SSC Guru

Points: 736478

March 4, 2011 at 9:38 am

#1294755

I have submitted a note to WordPress to remove this.

wagner crivelini SSC Eights! Points: 922 More actions · Answer 5

Steve Jones - SSC Editor (3/4/2011)
I have submitted a note to WordPress to remove this.

Steve

I wasn't aware of this kind of problem, but I am surprised to see how frequent it is.

I made a quick search on GOOGLE this morning and found 3 "clones" of my articles at blogpost.com

http://softwarekira.blogspot.com/2009/05/modeling-and-diagrams-with-sql-server.html

http://gowdhamanr.blogspot.com/2010/10/do-you-really-need-surrogate-keys-part.html#more

http://techtipsbysatish.blogspot.com/2010/08/sql-server-joins.html

And the original articles:

http://www.sqlservercentral.com/Authors/Articles/Wagner_Crivelini/293928/

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 6

You can submit DCMAs here:

Blogger: http://www.google.com/support/bin/request.py?contact_type=lr_dmca&product=blogger

Wordpress: http://automattic.com/dmca/

I'll do those.

Misha_SQL SSCertifiable Points: 5407 More actions · Answer 7

Thank you very much for the article! This is a great set of tips. I am currently working on just this kind of scenario -- researching a large database and figuring out functionality. I would like to recommend one more tool -- it's "SQL Dependency Tracker" from Red-Gate, which I found very helpful. I enables you to visualize dependencies between various database objects and perform analysis.