SQL Server 2008 offers two options for collecting change tracking information within the database engine, using built-in features that offer reliability and performance advantages over tracking tables ...

Code Focused Deleting All Data from a SQL Server Database There are times as a developer that you will want to be able to delete all the data from a database as efficiently as possible. Unfortunately, ...

SQL JOINs make it easy to find and fix missing data Your email has been sent Many people are confused by various JOIN operations supported by SQL. Learn to master the SQL command line with this ...

Naïve approaches to business intelligence will occasionally trap designers as they juggle operational data stores and data warehouses. The trap results from an honest endeavor to simplify designs and ...

Use temp tables to improve cursor performance Use table-valued functions over scalar functions Use partitioning to avoid large data moves Use stored procedures for performance, use ORMs for ...

The functionality is also standardized in ISO/IEC 13249 SQL/MM. This paper presents part 3 of the standard and discusses it critically. The spatial data types and methods on these types are explained.