We’ve all done it. We needed to pull data out of an SQL database, and the query we needed to pull out data was a complex query with multiple table joins, complex filter criteria, and ...

If screaming speed in data access is the most important thing in your life, SQL Server's durable in-memory, memory-optimized tables are your answer. They were good in SQL Server 2014 and they're even ...

Use Word 2010's Numbering feature in tables and make it automatically number multiple table columns vertically. This way, each cell in each column will be placed under the correct number.

Learn how Data Transformation Services (DTS) can help you import, export, and/or transform data from various sources to single or multiple locations in Microsoft SQL Server 2000.

SQL Server 2016 and Azure SQL Database both give you tables that automatically keep track of the history of your data. Here's how to retrieve that historical data. In an earlier column, I showed how ...

Orders Table - holds information on when an order was placed including Customer ID, date of order, order shipping date, etc. Order Details Table - holds information on each product ordered on one ...