data

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.

2015-01-26

8,731 reads

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.

2012-04-11

4,244 reads

Blogs

SQLSaturday Automatic Messages

By

For those who haven’t used the admin tools for SQLSaturday when an event is...

Using the Announcement/News Part of SQLSaturday

By

One of the interesting but not often used features of the SQLSaturday tools is...

SQLSaturday Orlando 2019 Begins

By

We’ll be event number 911, set for September 28th at our usual location at...

Read the latest Blogs

Forums

Statistics Profile Results

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Statistics Profile Results

Transaction was deadlocked on lock | communication buffer resources with another

By sridharkannan7

I have a table that contains case numbers. The following stored procedure assigns a...

Microsoft and Oracle Cloud Partnership

By Kathi Kellenberger

Comments posted to this topic are about the item Microsoft and Oracle Cloud Partnership

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers