Latch documentation?

Does anybody know of any good documentation on latches? I remember somebody
mentioning in this group that microsoft were going to release a white paper
on them. Has it been released yet?
Gav :o)
No it hasn't been released yet and there's no plan to release one in the
near future.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Gav" <gavin.metcalfe@.nospam.portakabin.com> wrote in message
news:cl5csv$6r8$1@.sparta.btinternet.com...
> Does anybody know of any good documentation on latches? I remember
somebody
> mentioning in this group that microsoft were going to release a white
paper
> on them. Has it been released yet?
> Gav :o)
>
sql

Latch documentation?

Does anybody know of any good documentation on latches? I remember somebody
mentioning in this group that microsoft were going to release a white paper
on them. Has it been released yet?
Gav :o)No it hasn't been released yet and there's no plan to release one in the
near future.
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Gav" <gavin.metcalfe@.nospam.portakabin.com> wrote in message
news:cl5csv$6r8$1@.sparta.btinternet.com...
> Does anybody know of any good documentation on latches? I remember
somebody
> mentioning in this group that microsoft were going to release a white
paper
> on them. Has it been released yet?
> Gav :o)
>

Latch documentation?

Does anybody know of any good documentation on latches? I remember somebody
mentioning in this group that microsoft were going to release a white paper
on them. Has it been released yet?
Gav :o)No it hasn't been released yet and there's no plan to release one in the
near future.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Gav" <gavin.metcalfe@.nospam.portakabin.com> wrote in message
news:cl5csv$6r8$1@.sparta.btinternet.com...
> Does anybody know of any good documentation on latches? I remember
somebody
> mentioning in this group that microsoft were going to release a white
paper
> on them. Has it been released yet?
> Gav :o)
>

Last Query Statement fired into the MSSQL Engine

Hi,

How can you get the Query Statement of the last executed SQL command.

I am not quite sure but I do remember coming across such a command ( maybe an undocumented one).

Thanks for your help and pointers.

My Best wishes for the new year to all the folks in the forum. Wishing you greater days ahead.

Warm Regards,
Ranjit S Hans.

---------------------
Everywhere is a walking distance if you have the time - Steven Wrightdbcc inputbuffer(@.spid)|||You can also use fn_get_sql, but it is a little more awkward.|||Hi Matt/ Jezemine,

Thanks so much for the help .. You have been wonderful all along.

I am looking forward to try out using fn_get_sql sometime soon.

Thanks once again !!

Warm Regards,
Ranjit S Hans
----------------------
Everywhere is a walking distance if you have the time - Steven Wright|||fn_get_sql has a number of benefits over dbcc inputbuffer actually. dbcc cuts off the query returned at 255 chars as I recall. Usually thats enough, unless you have apps out there making ad-hoc sql calls doing a 10-way join. :)