Confio

Technical Article

RE: Indexes

  • Reply

dbcc showcontig will show you all the indexes, and even which ones should be rebuilt.  Based on the results of showcontig, you can then use dbcc dbreindex or dbcc indexdefrag to rebuild the indexes.  Steve

You rated this post out of 5. Change rating

2004-06-23

Technical Article

RE: Relplace all but a-zA-Z0-9

  • Reply

Just wondering... Instead of deleting those "undesirable" characters, could we replace with a character of our choice?  Hum.... how about replacing each undesirable character with another one (if defined) otherwise replaced with a common character ('') 

You rated this post out of 5. Change rating

2004-03-16

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