Normalization

Hi all,

I am still confuse in normalization. (1st, 2nd, 3rd, and more.)

Any body have a detail idea abt that ?
Pls explain with example.

Thxs.

Regards,
Shailesh PatelThis question should be in the data forum...

a non normalized data table for a Company might have columns thus
tblCompany
company
address
city
state
firstname
lastname
telephone
fax
email

now imagine that the same company has 2 employees. the company info gets repeated for each employee. this wastes disk space and create the potential for data to also be incorrect. It also requires a lot of extra tdata entry to keep inputting the same company data.

so lets normalize it by splitting it into 2 tables. A company table and an employee table.

tblCompany
CompanyID
company
address
city
state

tblEmployee
CompanyID
firstname
lastname
telephone
fax
email

These 2 tables are linked on the CompanyID and you can now have many Employees for any single Company. Now one of those pesky employees decided to have 3 different email addresses. So lets normalize the Employee table

tblEmployee
EmployeeID
CompanyID
firstname
lastname

tblEmployeeContactInfo
EmployeeID
telephone
fax
email

These two tables are linked on EmployeeID. Now any single employee can have multiple contact records for an unlimited number of phone, fax or email data.|||Check out this page:

http://www.bkent.net/Doc/simple5.htmsql

Normalization

can i get little idea about normalization?
where i will found all levels of normalization along with
example?
Thanks and regards
hrishikeshPerhaps you should read some books about Datadase design (also included
clustered and non clustered indexes) :))
http://www.amazon.de/exec/obidos/ASIN/0735619603/sqlserver-21
Or
http://www.amazon.de/exec/obidos/ASIN/1861004761/sqlserver-21
(Wrox press books are very good)
These are sql server specific books, but also capable for other RDBMS (eg.
Oracle)
HTH, Jens Süßmeyer.|||look at this site.
http://www.sqlserversite.com/content/articles/20020418.asp --Normalizat
ion database
"hrishikesh musale" <musaleh@.mahindrabt.com> wrote in message
news:03f901c36d55$af8395f0$a001280a@.phx.gbl...
> can i get little idea about normalization?
> where i will found all levels of normalization along with
> example?
>
> Thanks and regards
> hrishikesh|||Can look at http://www.extremeexperts.com/sql/articles/Normalizing.aspx
--
HTH,
Vinod Kumar
MCSE, DBA, MCAD
http://www.extremeexperts.com
"hrishikesh musale" <musaleh@.mahindrabt.com> wrote in message
news:03f901c36d55$af8395f0$a001280a@.phx.gbl...
> can i get little idea about normalization?
> where i will found all levels of normalization along with
> example?
>
> Thanks and regards
> hrishikesh

non paged pool is empty error

I have received the following error
The server was unable to allocate from the system nonpaged pool because the
pool was empty.
Any idea on how to trap which process is causing the memory to leak or be
used up. This has caused SQL Server to be unavailable. I had to reboot as a
fix
I would like to trap it before it happens again. Any way to do so ?
Using Win2K3 and SQL 2KHi Hassan
I would expect this to be a gradual therefore monitoring the memory usage
over time would possibly indicate which process is not releasing memory.
Check out
http://www.microsoft.com/technet/prodtechnol/exchange/Guides/TrblshtE2k3Perf/7a44b064-8872-4edf-aac7-36b2a17f662a.mspx?mfr=true
and the perfmon counters in http://ask.support.microsoft.com/kb/133384
Also see if this applies:
http://support.microsoft.com/default.aspx?scid=kb;en-us;272568&sd=ee
John
"Hassan" wrote:
> I have received the following error
> The server was unable to allocate from the system nonpaged pool because the
> pool was empty.
> Any idea on how to trap which process is causing the memory to leak or be
> used up. This has caused SQL Server to be unavailable. I had to reboot as a
> fix
> I would like to trap it before it happens again. Any way to do so ?
>
> Using Win2K3 and SQL 2K
>
>
>

non paged pool is empty error

I have received the following error
The server was unable to allocate from the system nonpaged pool because the
pool was empty.
Any idea on how to trap which process is causing the memory to leak or be
used up. This has caused SQL Server to be unavailable. I had to reboot as a
fix
I would like to trap it before it happens again. Any way to do so ?
Using Win2K3 and SQL 2KHi Hassan
I would expect this to be a gradual therefore monitoring the memory usage
over time would possibly indicate which process is not releasing memory.
Check out
http://www.microsoft.com/technet/pr...a.mspx?mfr=true
and the perfmon counters in http://ask.support.microsoft.com/kb/133384
Also see if this applies:
http://support.microsoft.com/defaul...us;272568&sd=ee
John
"Hassan" wrote:

> I have received the following error
> The server was unable to allocate from the system nonpaged pool because th
e
> pool was empty.
> Any idea on how to trap which process is causing the memory to leak or be
> used up. This has caused SQL Server to be unavailable. I had to reboot as
a
> fix
> I would like to trap it before it happens again. Any way to do so ?
>
> Using Win2K3 and SQL 2K
>
>
>

non paged pool is empty error

I have received the following error
The server was unable to allocate from the system nonpaged pool because the
pool was empty.
Any idea on how to trap which process is causing the memory to leak or be
used up. This has caused SQL Server to be unavailable. I had to reboot as a
fix
I would like to trap it before it happens again. Any way to do so ?
Using Win2K3 and SQL 2K
Hi Hassan
I would expect this to be a gradual therefore monitoring the memory usage
over time would possibly indicate which process is not releasing memory.
Check out
http://www.microsoft.com/technet/prodtechnol/exchange/Guides/TrblshtE2k3Perf/7a44b064-8872-4edf-aac7-36b2a17f662a.mspx?mfr=true
and the perfmon counters in http://ask.support.microsoft.com/kb/133384
Also see if this applies:
http://support.microsoft.com/default.aspx?scid=kb;en-us;272568&sd=ee
John
"Hassan" wrote:

> I have received the following error
> The server was unable to allocate from the system nonpaged pool because the
> pool was empty.
> Any idea on how to trap which process is causing the memory to leak or be
> used up. This has caused SQL Server to be unavailable. I had to reboot as a
> fix
> I would like to trap it before it happens again. Any way to do so ?
>
> Using Win2K3 and SQL 2K
>
>
>