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
Showing posts with label regards. Show all posts
Showing posts with label regards. Show all posts
Monday, March 26, 2012
Wednesday, March 21, 2012
non-leaf-level pages and leaf-level pages?
Hi
What is de diferents beetwen non-leaf-level pages and leaf-level pages?
Thanks
Best Regards
CesarThe 'non-leaf level pages are key-value pairs used to navigate down to the
'leaf-level' pages desired.
For a clustered index, the 'leaf-level' pages are where the table data is
actually stored.
For non-clustered indexes, the 'leaf-level' pages contain key-value pairs
directing the search to either the key used in a clustered index, or to a
pointer to the heap where data is stored since it is not clustered.
For a more detailed description, check Books on Line.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Cesar" <hgfdhfg@.jksjn.com> wrote in message
news:%23G8R4l$uGHA.1372@.TK2MSFTNGP04.phx.gbl...
> Hi
> What is de diferents beetwen non-leaf-level pages and leaf-level pages?
> Thanks
> Best Regards
> Cesar
>|||Cesar wrote:
> Hi
> What is de diferents beetwen non-leaf-level pages and leaf-level pages?
> Thanks
> Best Regards
> Cesar
>
Imagine a tree growing in your back yard. Your data (or pointers to
your data) is stored in the leaves of the tree, or at the "leaf level".
To reach those leaves, you have to climb the tree, moving from branch
to branch until you reach the desired leaf. Every time you reach a fork
in the tree, you have to make a decision as to which branch of the fork
you should follow.
The database engine has to do the same thing, only with a binary data
tree. When it reaches a fork in the tree, it has to decide which branch
to take. It makes that decision by looking at data stored at the
"non-leaf level".
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Thanks Tracy ..
"Tracy McKibben" <tracy@.realsqlguy.com> ha scritto nel messaggio
news:u0w214HvGHA.1372@.TK2MSFTNGP04.phx.gbl...
> Cesar wrote:
> > Hi
> > What is de diferents beetwen non-leaf-level pages and leaf-level pages?
> > Thanks
> >
> > Best Regards
> >
> > Cesar
> >
> >
> Imagine a tree growing in your back yard. Your data (or pointers to
> your data) is stored in the leaves of the tree, or at the "leaf level".
> To reach those leaves, you have to climb the tree, moving from branch
> to branch until you reach the desired leaf. Every time you reach a fork
> in the tree, you have to make a decision as to which branch of the fork
> you should follow.
> The database engine has to do the same thing, only with a binary data
> tree. When it reaches a fork in the tree, it has to decide which branch
> to take. It makes that decision by looking at data stored at the
> "non-leaf level".
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||Thanks Arnie.
"Arnie Rowland" <arnie@.1568.com> ha scritto nel messaggio
news:eVkyoSAvGHA.3500@.TK2MSFTNGP06.phx.gbl...
> The 'non-leaf level pages are key-value pairs used to navigate down to the
> 'leaf-level' pages desired.
> For a clustered index, the 'leaf-level' pages are where the table data is
> actually stored.
> For non-clustered indexes, the 'leaf-level' pages contain key-value pairs
> directing the search to either the key used in a clustered index, or to a
> pointer to the heap where data is stored since it is not clustered.
> For a more detailed description, check Books on Line.
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "Cesar" <hgfdhfg@.jksjn.com> wrote in message
> news:%23G8R4l$uGHA.1372@.TK2MSFTNGP04.phx.gbl...
> > Hi
> > What is de diferents beetwen non-leaf-level pages and leaf-level pages?
> > Thanks
> >
> > Best Regards
> >
> > Cesar
> >
> >
>
What is de diferents beetwen non-leaf-level pages and leaf-level pages?
Thanks
Best Regards
CesarThe 'non-leaf level pages are key-value pairs used to navigate down to the
'leaf-level' pages desired.
For a clustered index, the 'leaf-level' pages are where the table data is
actually stored.
For non-clustered indexes, the 'leaf-level' pages contain key-value pairs
directing the search to either the key used in a clustered index, or to a
pointer to the heap where data is stored since it is not clustered.
For a more detailed description, check Books on Line.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Cesar" <hgfdhfg@.jksjn.com> wrote in message
news:%23G8R4l$uGHA.1372@.TK2MSFTNGP04.phx.gbl...
> Hi
> What is de diferents beetwen non-leaf-level pages and leaf-level pages?
> Thanks
> Best Regards
> Cesar
>|||Cesar wrote:
> Hi
> What is de diferents beetwen non-leaf-level pages and leaf-level pages?
> Thanks
> Best Regards
> Cesar
>
Imagine a tree growing in your back yard. Your data (or pointers to
your data) is stored in the leaves of the tree, or at the "leaf level".
To reach those leaves, you have to climb the tree, moving from branch
to branch until you reach the desired leaf. Every time you reach a fork
in the tree, you have to make a decision as to which branch of the fork
you should follow.
The database engine has to do the same thing, only with a binary data
tree. When it reaches a fork in the tree, it has to decide which branch
to take. It makes that decision by looking at data stored at the
"non-leaf level".
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Thanks Tracy ..
"Tracy McKibben" <tracy@.realsqlguy.com> ha scritto nel messaggio
news:u0w214HvGHA.1372@.TK2MSFTNGP04.phx.gbl...
> Cesar wrote:
> > Hi
> > What is de diferents beetwen non-leaf-level pages and leaf-level pages?
> > Thanks
> >
> > Best Regards
> >
> > Cesar
> >
> >
> Imagine a tree growing in your back yard. Your data (or pointers to
> your data) is stored in the leaves of the tree, or at the "leaf level".
> To reach those leaves, you have to climb the tree, moving from branch
> to branch until you reach the desired leaf. Every time you reach a fork
> in the tree, you have to make a decision as to which branch of the fork
> you should follow.
> The database engine has to do the same thing, only with a binary data
> tree. When it reaches a fork in the tree, it has to decide which branch
> to take. It makes that decision by looking at data stored at the
> "non-leaf level".
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||Thanks Arnie.
"Arnie Rowland" <arnie@.1568.com> ha scritto nel messaggio
news:eVkyoSAvGHA.3500@.TK2MSFTNGP06.phx.gbl...
> The 'non-leaf level pages are key-value pairs used to navigate down to the
> 'leaf-level' pages desired.
> For a clustered index, the 'leaf-level' pages are where the table data is
> actually stored.
> For non-clustered indexes, the 'leaf-level' pages contain key-value pairs
> directing the search to either the key used in a clustered index, or to a
> pointer to the heap where data is stored since it is not clustered.
> For a more detailed description, check Books on Line.
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "Cesar" <hgfdhfg@.jksjn.com> wrote in message
> news:%23G8R4l$uGHA.1372@.TK2MSFTNGP04.phx.gbl...
> > Hi
> > What is de diferents beetwen non-leaf-level pages and leaf-level pages?
> > Thanks
> >
> > Best Regards
> >
> > Cesar
> >
> >
>
Friday, March 9, 2012
non domain log shipping
According to KB article 314515 in regards to having log
shipping set up outside of a domain:
Q3: Do I have to start SQL Server related services under a
domain account as opposed to a local Windows NT account?
A3: It is possible to configure SQL Server services to
start under a local Windows NT account, unless SQL Server
is configured to run as a virtual server in conjunction
with Microsoft Cluster Service. You can use Windows NT
pass-through security for this purpose. Follow these steps
to configure pass-through security:
Create a Windows NT account on the primary, secondary and
monitor computers with the same name and passwords.
Configure SQL Server related services to start under these
Windows NT accounts on all computers.
So what if one of the computers is in a domain and one
isnt. The logins are set up like this:
Source
domain\administrator
Destination
local\administrator
Same passwords on both but Im still having problems.What problem are you having?
Rand
This posting is provided "as is" with no warranties and confers no rights.
shipping set up outside of a domain:
Q3: Do I have to start SQL Server related services under a
domain account as opposed to a local Windows NT account?
A3: It is possible to configure SQL Server services to
start under a local Windows NT account, unless SQL Server
is configured to run as a virtual server in conjunction
with Microsoft Cluster Service. You can use Windows NT
pass-through security for this purpose. Follow these steps
to configure pass-through security:
Create a Windows NT account on the primary, secondary and
monitor computers with the same name and passwords.
Configure SQL Server related services to start under these
Windows NT accounts on all computers.
So what if one of the computers is in a domain and one
isnt. The logins are set up like this:
Source
domain\administrator
Destination
local\administrator
Same passwords on both but Im still having problems.What problem are you having?
Rand
This posting is provided "as is" with no warranties and confers no rights.
Monday, February 20, 2012
No transparency used by report using PNG Image?
Hi,
I used some transparent png images in my reports, but it seems that they are rendered using a white background.
Why is this?
Best Regards.
Luis Simoes
Luis,
There is a known issue with PNG Transparency in Internet Explorer, which may be what your experiencing. This link may help http://support.microsoft.com/?scid=kb;en-us;265221
Regards,
Kevin
Subscribe to:
Posts (Atom)