Performance of "text" versus "image" datatypes (SS2000)

In terms of simple insertion and selection, is there any appreciable performance difference between text and image? (assuming the size of the data in bytes would be roughly equal)

Please also assme we're storing all LOBs out of row.

Thanks!

It would be the same. However, if your lob is nothing more than some very long string, putting it 'text' column would be a better fit.

performance objects for SQLServer disappeared

Using SS2000. I have been several performance monitor counters for SQLServer.
When I tried to start the counters this morning, I received this error:
The database_size log or alert has not started.
When I tried to look at the counter, under performance object there are no
objects for SQLServer.
Does anyone know why or how these could disappear? SQL Server is still
running on the box.
Thanks,
Dan D.
Have a look at this:
http://support.microsoft.com/default...&Product=sql2k
Andrew J. Kelly SQL MVP
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:68581C5F-771A-47D6-8B75-180D4B23D5AF@.microsoft.com...
> Using SS2000. I have been several performance monitor counters for
SQLServer.
> When I tried to start the counters this morning, I received this error:
> The database_size log or alert has not started.
> When I tried to look at the counter, under performance object there are no
> objects for SQLServer.
> Does anyone know why or how these could disappear? SQL Server is still
> running on the box.
> Thanks,
> --
> Dan D.
|||Thanks Andrew. That looks like it may be it.
"Andrew J. Kelly" wrote:

> Have a look at this:
> http://support.microsoft.com/default...&Product=sql2k
> --
> Andrew J. Kelly SQL MVP
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:68581C5F-771A-47D6-8B75-180D4B23D5AF@.microsoft.com...
> SQLServer.
>
>

performance objects for SQLServer disappeared

Using SS2000. I have been several performance monitor counters for SQLServer.
When I tried to start the counters this morning, I received this error:
The database_size log or alert has not started.
When I tried to look at the counter, under performance object there are no
objects for SQLServer.
Does anyone know why or how these could disappear? SQL Server is still
running on the box.
Thanks,
--
Dan D.Have a look at this:
http://support.microsoft.com/default.aspx?scid=kb;en-us;812915&Product=sql2k
--
Andrew J. Kelly SQL MVP
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:68581C5F-771A-47D6-8B75-180D4B23D5AF@.microsoft.com...
> Using SS2000. I have been several performance monitor counters for
SQLServer.
> When I tried to start the counters this morning, I received this error:
> The database_size log or alert has not started.
> When I tried to look at the counter, under performance object there are no
> objects for SQLServer.
> Does anyone know why or how these could disappear? SQL Server is still
> running on the box.
> Thanks,
> --
> Dan D.