Fuzzy Match

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


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 ('') 


Technical Article

RE: QOD Jan 6 2004

  • Reply

From BOL:<Quote>The WHERE and HAVING clauses in a SELECT statement control the rows from the source tables that are used to build the result set. WHERE and HAVING are filters. They specify a series of search conditions, and only those rows that meet the terms of the search conditions are used to build the result […]



Speaking at SQLSaturday MN 2022


Thanks all for joining me for two sessions at SQLSaturday Minnesota 2023, and for...

Goal Progress for Nov 2022


I set goals at the beginning of the year, and I’m tracking my progress...

PGSQL PHRIDAY #3: What is the PostgreSQL Community To You?


Very excited to take part in my third #PGSQLPhriday blogging event, even more so...

Read the latest Blogs


Windows login Token-based server access validation failed with an infrastructure

By Raja mssql

Hi All, One of our windows login is not working which is been configured...

Subtract calculated columns

By pedroccamara

Hello all I am sorry to bother but I really can't find the solution...

Help Parsing String

By Tav29

I can do the Last Name, First Name; my problem is Middle Initial. I...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers