2015-03-13
1,465 reads
T-SQL
SQL Server Random Sorted Result Set
In this tip Dallas Snider illustrates how to write a T-SQL query that will return rows sorted randomly.
2015-03-10
8,200 reads
2015-03-06
2,192 reads
2015-03-05
2,022 reads
2015-03-04
1,864 reads
2015-03-02
1,509 reads
The Potential of Joins
An article about how we underestimate the power of joins and degrade our query performance by not using proper joins
2015-02-26
10,624 reads
Dynamically Query a 100 Million Row Table-Efficiently
This article describes methods of creating dynamic queries without the use of dynamic SQL to efficiently access large tables.
2016-05-27 (first published: 2015-02-24)
65,110 reads
2015-02-23
1,671 reads
2015-02-20
1,757 reads
Blogs
Getting the SQL Server MCP Server Running
By Steve Jones
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...
Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
Rambling about Data on Wheels – origins, branding, expansion
By DataOnWheels
I have been asked many times about how the name “Data on Wheels” came...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
DBCC CHECKDB Limits III
Comments posted to this topic are about the item DBCC CHECKDB Limits III
CROSS APPLY Fundamentals: Part 1
Comments posted to this topic are about the item CROSS APPLY Fundamentals: Part 1
Question of the Day
DBCC CHECKDB Limits III
On SQL Server 2025, does DBCC CHECKDB support Memory-Optimized tables?
See possible answers