It deserializes (and possibly re-serializes) itself every time you access any method or property. -- Adam Machanic Pro SQL Server 2005, available now http://www.apress.com/book/bookDisplay.html?bID=457 -- "Leila" <Leilas@hotpop.com> wrote in message news:egNPeUyLGHA.4052@TK2MSFTNGP15.phx.gbl...
"Leila" <Leilas@hotpop.com> wrote in news:egNPeUyLGHA.4052@TK2MSFTNGP15.phx.gbl: An UDA does write to disk. Each "group" will after accumulation be written to disk and then re-read from disk before the Terminate call. Niels -- ************************************************** * Niels Berglund * http://staff.develop.com/nielsb * nielsb@no-spam.develop.com * "A First Look at SQL Server 2005 for Developers" * http://www.awprofessional.com/title/0321180593 **************************************************
Hi, Why does a UDA with Format.UserDefined need implementation of Write and Read methods? UDA does not write anything on disk. Thanks in advance, Leila
"Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote in news:e23wySMMGHA.2316@TK2MSFTNGP11.phx.gbl: Well, the few tests I have done with Format.UserDefined does a write and a read for each group. Under what cicumstances would a physical worktable have to be chosen? Niels -- ************************************************** * Niels Berglund * http://staff.develop.com/nielsb * nielsb@no-spam.develop.com * "A First Look at SQL Server 2005 for Developers" * http://www.awprofessional.com/title/0321180593 **************************************************
"Niels Berglund" <nielsb@develop.com> wrote in message news:Xns9769B492061B7nielsbdevelopcom@207.46.248.16... Hi Niels, I assume you mean a call to Write and Read, rather than an actual I/O? How do you know that the bytes aren't stored in memory? -- Adam Machanic Pro SQL Server 2005, available now http://www.apress.com/book/bookDisplay.html?bID=457 --
I thought this only happen in the case a plan is chosen that means that a physical worktable has to be used? -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ Blog: http://solidqualitylearning.com/blogs/tibor/ "Niels Berglund" <nielsb@develop.com> wrote in message news:Xns9767D9E95FFA0nielsbdevelopcom@207.46.248.16...