I guess I'm a lucky Man... I don't have that type of problem at work and this is the 3rd company in a row I've worked for that actually embraces...

I agree with both Andy and Steve (thanks for the feedback, guys).  A blog at work could certainly be useful to the company as well as allowing the individual to...

Heh!  More than 6000 posts and you still haven't got it down to {Ctrl-A}{Ctrl-C} before you hit the Submit button?

Heh... doesn't matter, Rudy... folks can always buy hardware to make up for the lack of knowledge

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