SQL XML

Technical Article

RE: Optimization Job

  • Reply

I'm also having this problem. (See my slightly earlier post "Maintenance plan/DBCC problem"). It might be worth having a look at a MS knowledgebase article: http://support.microsoft.com/?kbid=301292 Although this hasn't helped me! Anyone got any other ideas? Thanks

You rated this post out of 5. Change rating

2003-05-19

2 reads

Technical Article

RE: Testing text field for content

  • Reply

Hi David, quote: p.s. I disagree with 'You cannot use CHARINDEX on textfields', I can on SQL7 SP4. From BOL (SQL2k) ... These functions and statements can be used with ntext, text, or image data. Functions DATALENGTH PATINDEX SUBSTRING TEXTPTR TEXTVALID ... ...but it seems to work in some cases?!? Anyway, using DATALENGTH is a […]

You rated this post out of 5. Change rating

2003-05-19

Blogs

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Snowflake + Azure blob

By

Let’s go back to data platforms today and I want to talk about a...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers