How can I delete records from a table when there are foreign keys that depend on these records? Read more at Stackoverflow …
Suppose I have a query where I want everything in table A that is not in table B. For example, I want all the customers in table A who have not placed an order in table B. There are a surprising number of ways to build a select statement that returns the correct answer. Some of those queries may also give you an incorrect answer if one of the target fields has nullable data.
Aaron Bertrand’s article will walk you through each of the examples to show you why Not Exists is the best option for this type of query.
When using BIDS to create an SSIS package in a 64-bit environment it was easy to create the connection to a 32-bit Access Database. You can view and select columns from the database, modify them in the data flow, then map them to the destination table.
But when you execute the package you get an error 0xC0209303 which says the Access DB couldn’t be opened.
The quick fix: Under the Project menu pick the project Properties (bottom choice), pick Debugging under Configuration Properties, and set the Run64BitRuntime property to false.
Oracle Announces an In-Memory Technology, At an Ungodly Speed…And Cost. This article is from MemSQL so there is some bias towards Oracle, but they succinctly state how Oracle comes last to the table, then misses the ocean liner.
Apache Derby is a Java relational database management system that can be embedded in Java programs and used for online transaction processing. It has a 2 MB disk-space footprint. Apache Derby is developed as an open source project under the Apache 2.0. (Excerpt from Wikipedia)
Query Spatial Data for Nearest Neighbor. Query the seven closest cities to a given location.
STDistance (geography Data Type). Calculate the distance between two geographic points.
OGC Methods on Geography Instances. More spatial query parameters for SQL Server.