Wednesday, March 7, 2012

chained rows

Hi ,
How to find changed rows in sql server
Thanks
Ajay
You cannot by default, unless you have some kind of auditing in place.
Auditing can be implemented using triggers.
If you have a datetime column in your table, and if you make sure that gets
updated with every change, then you can find the updated rows based on that
column as well.
Another option is to use a tool like Lumigent Log Explorer to look at the
transaction log of SQL Server database.
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Aju" <ajuonline@.yahoo.com> wrote in message
news:%23vzexOvaEHA.4032@.TK2MSFTNGP11.phx.gbl...
> Hi ,
> How to find changed rows in sql server
>
> Thanks
> Ajay
>
|||Hi ,
Thanks for the reply sir ,
I learned many good things from your website .
One more doubt please is forwarded row count is similar to the chained rows
& which is not good for performance .
Please give some more details
Thanks & Regards
Ajay
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:uxjXu7vaEHA.212@.TK2MSFTNGP12.phx.gbl...
> You cannot by default, unless you have some kind of auditing in place.
> Auditing can be implemented using triggers.
> If you have a datetime column in your table, and if you make sure that
gets
> updated with every change, then you can find the updated rows based on
that
> column as well.
> Another option is to use a tool like Lumigent Log Explorer to look at the
> transaction log of SQL Server database.
> --
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "Aju" <ajuonline@.yahoo.com> wrote in message
> news:%23vzexOvaEHA.4032@.TK2MSFTNGP11.phx.gbl...
>
|||I am not sure I understand your question.
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Aju" <ajuonline@.yahoo.com> wrote in message
news:%23orAyFwaEHA.3332@.TK2MSFTNGP09.phx.gbl...
> Hi ,
> Thanks for the reply sir ,
> I learned many good things from your website .
> One more doubt please is forwarded row count is similar to the chained
rows[vbcol=seagreen]
> & which is not good for performance .
> Please give some more details
> Thanks & Regards
> Ajay
>
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:uxjXu7vaEHA.212@.TK2MSFTNGP12.phx.gbl...
> gets
> that
the
>
|||Hi ,
Since my previous experience is into oracle I used the word chained rows
here . My question when a row doesn't get space in a page it may migrate to
some other leaving pointer in older one , that way for small no. of rows
query has to access many pages . So how to avoid this row migration if any
in the database .
Thanks
R. Ajay
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:O2MVwTwaEHA.2812@.tk2msftngp13.phx.gbl...
> I am not sure I understand your question.
> --
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "Aju" <ajuonline@.yahoo.com> wrote in message
> news:%23orAyFwaEHA.3332@.TK2MSFTNGP09.phx.gbl...
> rows
> the
>
|||SQL Server will allow a maximum row size of 8,060 bytes only.
If you are talking abut fragmented tables, see DBCC DBREINDEX, DBCC
INDEXDEFRAG, and DBCC SHOWCONTIG in SQL Sercer 2000 Books Online.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Aju" <ajuonline@.yahoo.com> wrote in message
news:ujOlOXxaEHA.2932@.TK2MSFTNGP10.phx.gbl...
Hi ,
Since my previous experience is into oracle I used the word chained rows
here . My question when a row doesn't get space in a page it may migrate to
some other leaving pointer in older one , that way for small no. of rows
query has to access many pages . So how to avoid this row migration if any
in the database .
Thanks
R. Ajay
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:O2MVwTwaEHA.2812@.tk2msftngp13.phx.gbl...
> I am not sure I understand your question.
> --
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "Aju" <ajuonline@.yahoo.com> wrote in message
> news:%23orAyFwaEHA.3332@.TK2MSFTNGP09.phx.gbl...
> rows
> the
>
|||SQL server will only leave forwarding pointers on tables which have no
clustered index. These forwarding pointers will only be indirected one
level, even if the row changes pages multiple times.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Aju" <ajuonline@.yahoo.com> wrote in message
news:%23vzexOvaEHA.4032@.TK2MSFTNGP11.phx.gbl...
> Hi ,
> How to find changed rows in sql server
>
> Thanks
> Ajay
>

No comments:

Post a Comment