>>>>Hi,
>>>>
>>>>Do you (collective you) know if the method CursorFill() of class CursorAdapter performs SQL Select (under the hood)?
>>>
>>>It does. Keep a profiler open and see for yourself what it sends.
>>
>>Thank you. This is not the first time that I am suggested to use the profiler. I need to learn how to use it. Guilty.
>
>I prefer the express profiler (yup, that's the name), which is quite limited - seems to work on only one instance of SQL, I think the local one - but is very lightweight, below 200K is the exe, and is order of magnitude easier to use. The profiler which comes with the server is an admin tool, designed to do everything; this express profiler is just a handy programmer's tool, clean and simple.
Thank you. The only profiler I see is the one is SSMS is Tools -> SQL Server Profiler. This is not the Express Profiler, no?
UPDATE. My understanding is that the Express Profiler is a separate tool that can be downloaded. I will look for it.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
