Getting A Clue About Your Databases

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Gregor Borosa » Getting A Clue About Your Databases

23 posts, Page 2 of 3

««1 2 3 »»

Getting A Clue About Your Databases

Rate Topic

Display Mode

Topic Options

Author

Message

GSquared

Posted Friday, January 09, 2009 8:47 AM

SSCoach

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 1:55 PM
Points: 15,442, Visits: 9,571

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

Jesse McLain

Posted Friday, January 09, 2009 9:11 AM

Old Hand

Group: General Forum Members
Last Login: Monday, May 06, 2013 8:47 AM
Points: 304, Visits: 552

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. Smile

Jesse McLain
jesse@jessemclain.com
www.jessemclain.com
www.jessesql.blogspot.com

Post #633542

Anipaul

Posted Friday, January 09, 2009 9:15 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 1:35 AM
Points: 4,789, Visits: 1,336

Nice article...:)

Post #633549

SanjayAttray

Posted Friday, January 09, 2009 9:24 AM

Hall of Fame

Group: General Forum Members
Last Login: Friday, March 15, 2013 2:43 PM
Points: 3,924, Visits: 1,554

Anirban Paul (1/9/2009)

Nice article...:)

Just curious ! ! !

Why Anirban always had same response to all articles ?

SQL DBA.

Post #633557

Megistal

Posted Friday, January 09, 2009 9:28 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 7:15 AM
Points: 1,245, Visits: 1,783

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

noeld

Posted Friday, January 09, 2009 10:13 AM

SSCertifiable

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 4:39 PM
Points: 6,260, Visits: 1,977

Well done!

* Noel

Post #633624

Robert Hermsen

Posted Friday, January 09, 2009 10:33 AM

SSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 1:49 PM
Points: 455, Visits: 752

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

SQLBOT

Posted Sunday, January 11, 2009 11:38 AM

SSChasing Mays

Group: General Forum Members
Last Login: Monday, February 18, 2013 3:22 PM
Points: 626, Visits: 835

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

OCTom

Posted Monday, January 12, 2009 3:04 PM

SSCrazy

Group: General Forum Members
Last Login: Today @ 6:52 AM
Points: 2,018, Visits: 2,852

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

mishaluba

Posted Tuesday, January 13, 2009 4:56 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 5:54 PM
Points: 525, Visits: 617

Super! I know I am going to use it someday. Thank you for all the work!

Post #635928

« Prev Topic | Next Topic »

23 posts, Page 2 of 3

««1 2 3 »»

Permissions