T-SQL Programming Monica Rathbun in T-SQL Programming What Are Columnstore Indexes in SQL Server? Explained Learn what columnstore indexes are in SQL Server, how they store data by column instead of row, and why they... 22 July 2019 16 min read
T-SQL Programming Joe Celko in T-SQL Programming Modeling Time There are those who argue that time doesn’t really exist; it’s just an illusion. That debate won’t keep you from... 15 July 2019 16 min read
T-SQL Programming Rodney Landrum in T-SQL Programming A MongoDB to SQL Server Migration: Data Typing and Un-nesting Importing data from one system to another is a common task for database professionals. It’s possible to spend a lot... 20 June 2019 15 min read
T-SQL Programming Mala Mahadevan in T-SQL Programming Converting a History Table into a System-Versioned Temporal Table Temporal tables were introduced with SQL Server 2016. To take advantage of this feature, you might start fresh with a... 13 March 2019 15 min read
Editorials Kendra Little in Editorials Why You Shouldn’t Hardcode the Current Database Name in Your Views, Functions, and Stored Procedures “There are only two hard things in Computer Science: cache invalidation and naming things” Phil Karlton I’m terrible at naming... 12 March 2019 4 min read
T-SQL Programming Phil Factor in T-SQL Programming SQL Server Inline Indexes: Add Indexes to Table Variables and UDTTs SQL Server inline indexes let you define clustered, nonclustered, and filtered indexes directly in CREATE TABLE syntax for table variables,... 26 February 2019 13 min read
Databases Robert Sheldon in Databases SQL Server Contained Databases: Users & Portability How SQL Server's partially contained databases work — creating contained users, duplicating them across databases, and unlinking users from logins.… 25 February 2019 15 min read
T-SQL Programming Kathi Kellenberger in T-SQL Programming SQL Server 2019 Window Aggregate Performance: Batch Mode on Rowstore SQL Server 2019 Batch Mode on Rowstore dramatically improves window aggregate performance - running totals, moving averages, and accumulating SUM... 11 February 2019 12 min read
T-SQL Programming Joe Celko in T-SQL Programming Empty Thoughts: Working with NULL Whether or not to have NULLable columns in a table can be a religious debate, and how missing data is... 10 January 2019 12 min read
T-SQL Programming Phil Factor in T-SQL Programming SQL Server Export Formats Compared: BCP, XML, CSV, Tab-Delimited Performance and Gotchas Benchmarked comparison of SQL Server export formats - native BCP, XML via BCP, CSV, tab-delimited - for performance and handling... 24 December 2018 13 min read
T-SQL Programming Joe Celko in T-SQL Programming Data Quality Problems with data quality are easier and cheaper to prevent than to solve later. In this article, Joe Celko talks... 05 December 2018 11 min read
T-SQL Programming Greg Larsen in T-SQL Programming There is a New COUNT in Town Now that SQL Server 2019 is on the way, it’s time to start learning about the new capabilities. In this... 29 November 2018 14 min read
T-SQL Programming Phil Factor in T-SQL Programming SQL Server JSON: Transferring Data with FOR JSON, OPENJSON, and JSON Schema Validation Transfer data between SQL Server databases using JSON - exporting tables with FOR JSON, importing with OPENJSON, validating file contents... 25 November 2018 31 min read
T-SQL Programming Phil Factor in T-SQL Programming Getting Started with MongoDB and PowerShell: A Real-World Data Walkthrough Learn MongoDB with PowerShell using a real 6.5 million record dataset: install MongoDB, import CSV data, create indexes, run aggregation... 03 August 2018 26 min read
T-SQL Programming Kathi Kellenberger in T-SQL Programming T-SQL Window Functions: Performance, NTILE & Framing Master T-SQL window function performance: understand OVER clause sorting, PARTITION BY, NTILE, framing (ROWS vs RANGE), indexing strategies, and how... 27 June 2018 11 min read
T-SQL Programming Joe Celko in T-SQL Programming Missing Data Missing data is a difficult and common problem to solve. In this article, Joe Celko explains several approaches to deleting... 20 June 2018 10 min read
T-SQL Programming Kathi Kellenberger in T-SQL Programming Introduction to T-SQL Window Functions T-SQL window functions were introduced in 2005 with more functionality added in 2012. Many database professionals are not aware of... 13 June 2018 13 min read
T-SQL Programming Darko Martinović in T-SQL Programming Migrate a SQL Server Database to In-Memory OLTP: Full Guide Step-by-step guide to migrating a SQL Server database to In-Memory OLTP. Covers limitations, foreign key workarounds, data type compatibility, natively... 10 May 2018 30 min read
T-SQL Programming Phil Factor in T-SQL Programming Importing JSON into SQL Server: OPENJSON for Arrays, Nested Arrays, and Complex Collections Import JSON documents into SQL Server using OPENJSON - covering simple arrays of objects, nested arrays (with CROSS APPLY), and... 09 May 2018 21 min read
T-SQL Programming Robert Sheldon in T-SQL Programming SQL Server Graph Databases Part 5: Import Relational Data into Graph Tables Learn how to import AdventureWorks relational data into SQL Server graph node and edge tables, query the graph data with... 30 April 2018 20 min read
