PS: I here to learn and open to learn as much as I can..

No doubt and good attitude! ...

The database has been grown already by either a percentage or a fixed amount and if the new data fits into what was allotted, it will not grow again even if...

No... I'm just shocked that someone who boasts the MCDBA in their signature line is asking such a question.

There is no magic to...

There are, in fact, other ways using correlated subqueries in conjunction with IF EXISTS where, in the presence of correct indexes, can sometimes be made a bit faster than the...

Like what, Andy?  Not challenging you here... I'd really like to know...

I find that most developers are very protective of what they know because of job security and all that......

Thanks, Peter...

>>Lots of companies these days are looking to get their employees to blog...

Why would they enable yet another waste of company time using company resources?

Most of what you say is good except for the 1:1 relationship between the support tables and the PatientRegiestration table... should be a many:1.  Needs separate PK for each support...

Something like this...

 SELECT c.*,z.*

   FROM Customer c

   LEFT OUTER JOIN PostCodeTable z

     ON c.PostCode = z.PostCode

    AND c.Suburb = z.Suburb

  WHERE z.PostCode IS NULL

{} are not parenthesis...

A "simpleton" would not come to the conclusions you have nor ask the intelligent question you have.

Try something like this to eliminate weekends...

SELECT   (DATEDIFF(dd, [Date Received], [1st...

Heh... guess you didn't believe the ol' man when he told you the first time, huh, Shwetha?

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=388319#bm393497

Or any idea why disk usage is so high during querying?

A large amount of disk reads are...

Yep...  lots'o different tools available, but I'm confused... first post shows 2 items each line, follow on shows 1 item each line... I'm just trying to get AM to post about...

Great... thanks for the feedback, Jim.

Just more info on what they wanted us to do at work... they wanted a similar precalculated table of the distance from every NPA/NXX (area...