Data Quality

SQL Server Best Practices for Data Quality

  • Article

Accurate data is imperative for an organization to conduct cost effective decision making. Like everything else, change is constant for your data. There is a need to cleanse and validate data when received and on a regular basis. Unfortunately, cleansing and validating data is difficult with the native SQL Server toolset. How do we leverage the SQL Server tool set to achieve these goals?

2020-01-03

Data Degradation

  • Article

The other day at a conference, the subject of data degradation/corrosion arose. The speaker at the conference said that data in a database degraded or corroded over time. The statement was made as if degradation over time applied to all databases. I found this blanket statement to be misguided. Indeed, I think that data does degrade in some databases, but not all.

2009-05-14

2,180 reads

Blogs

Cleaning Up Stats Data for Volleyball

By

One of the things I’ve done the last few years is collect statistics as...

Day One, the Journaling App, Joins Automattic

By

We’re excited to welcome Day One to the Automattic team. Day One is a...

Find Queries Using a Key Lookup Operator

By

While teaching about Extended Events and Execution Plans last week, Jason, one of the...

Read the latest Blogs

Forums

Tracking, Privacy, and Lots of Data

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Tracking, Privacy, and Lots of...

Database File Growth

By lkennedy76

I have a question for the seasoned DBA's on here. I have come across...

Help query to select part of string

By imranazam

Hi Guys Hope everyone is well, i have a field called NAME with some...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers