Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

Getting A Clue About Your Databases Expand / Collapse
Author
Message
Posted Friday, January 9, 2009 8:47 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 15,444, Visits: 9,596
Nice, useful article. Good scripts. Thanks.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #633507
Posted Friday, January 9, 2009 9:11 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, May 15, 2014 12:28 PM
Points: 305, Visits: 565
Great article, I really like your approach. Working in ETL, I too often have to look at unfamiliar data, with guidance that is missing or unreliable, and it's great having a toolkit to examine such data. I wrote some code that will examine a table and determine possible natural keys for it: http://www.sqlservercentral.com/scripts/T-SQL/62086/. You might want to consider adding it to your toolbelt.

Jesse McLain
jesse@jessemclain.com
www.jessemclain.com
www.jessesql.blogspot.com
Post #633542
Posted Friday, January 9, 2009 9:15 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, August 29, 2014 4:30 AM
Points: 5,345, Visits: 1,388
Nice article...:)


Post #633549
Posted Friday, January 9, 2009 9:24 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, July 17, 2014 10:56 AM
Points: 3,924, Visits: 1,607
Anirban Paul (1/9/2009)
Nice article...:)


Just curious ! ! !

Why Anirban always had same response to all articles ?


SQL DBA.
Post #633557
Posted Friday, January 9, 2009 9:28 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 8:01 AM
Points: 1,419, Visits: 2,085
Each time you post on the forum you get a point, could be the reason.

Or it also could be to let a positive feedback for the author. Always feel good to know that you are doing something good even if it's only from few words.
Post #633567
Posted Friday, January 9, 2009 10:13 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, May 6, 2014 5:51 AM
Points: 6,266, Visits: 2,028
Well done!


* Noel
Post #633624
Posted Friday, January 9, 2009 10:33 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 1:19 PM
Points: 471, Visits: 841
Good Article. One thing that we learned the hard way is that size doesn't always matter but often times volume does.

SOmething to keep in mind. Also something that was taken into account with SQL Server 2005's canned reports. Very useful when troubleshooting issues as you can see your index and table usage stat from a hits perspective as well as size.
Post #633649
Posted Sunday, January 11, 2009 11:38 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Friday, January 3, 2014 10:59 AM
Points: 626, Visits: 836
Great idea, great Article. Keep 'em coming!

5 stars!!



~BOT


Craig Outcalt



Tips for new DBAs: http://www.sqlservercentral.com/articles/Career/64632
My other articles: http://www.sqlservercentral.com/Authors/Articles/Craig_Outcalt/560258
Post #634383
Posted Monday, January 12, 2009 3:04 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 29, 2014 2:22 PM
Points: 2,555, Visits: 3,809
I too am asked with some regularity to access data I know nothing about. This code will be very helpful. Poking around is not only tedious but dangerous, too.

Thanks for the code. Nicely done article.
:)
Post #635089
Posted Tuesday, January 13, 2009 4:56 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, August 28, 2014 5:37 PM
Points: 536, Visits: 757
Super! I know I am going to use it someday. Thank you for all the work!


Post #635928
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse