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

A Memory-Optimized Roundup – T-SQL Tuesday #117

By

The summary from my fourth T-SQL Tuesday hosting for #117. This time I was...

How do you debug your spark-dotnet app in visual studio?

By

When you run an application using spark-dotnet, to launch the application you need to...

More PowerShell Remoting coverage in dbatools

By

Starting on dbatools version 1.0.31 we introduced better coverage for commands that make use...

Read the latest Blogs

Forums

Official Site (Buy Now) :-http://www.smoreworld.com/ketobliss-australia/

By FrancisPucke

In any case, this pill might be for you on the off chance that...

Export to CSV

By Jenny77

Hi,   i am trying to export a table into csv, and it should...

CHECKDB

By VastSQL

My user database drive have about 100GB free space now and the database is...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers