External Article

Discrete and Continuous Data in SQL

  • Article

Not all data is discrete; some data types represent a continuum. In SQL, we have to approximate them and live with the special problems of handling continuous data. We need to understand the problems associated with continuous data types, when these will happen, and how it affects constraints and the results of queries. Joe Celko explains.


8,731 reads

External Article

Generating Data for Database Tests

  • Article

It is more and more essential for developers to work on development databases that have realistic data in both type and quantity, but without using real data. It isn't exactly easy, even with third-party tools to hand. Phil Factor shows how it can be done, taking the classic PUBS database and giving it a more realistic set of data.


4,244 reads


VMware & SQL Server 823-824 alerts


We’ve been tracking a weird state with SQL Server virtual machines on VMware and...

Daily Coping 18 May 2022


I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Storage Field Day 23 – SIOS


I am thrilled to have been a part of this year’s Storage Field Day...

Read the latest Blogs


Strange Issue With Data Corruption

By planetmatt

Our Reporting process works like this 00:00 - SQL Takes it's daily Full backup...

How do we populate missing values from last available data?

By T.Ashish

Hi There, I am working on a query where I need to convert some...

need some help in tweaking a query

By bobrooney.81

Hi All, I am looking for some tsql help. I am from Oracle background....

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers