2019-11-01 (first published: 2017-09-11)
5,386 reads
Gary Strange
CosmosDB Change Feed Processing
This article was created to help readers understand CosmosDB change feed processing.
2018-11-13
1,535 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)
59,975 reads
DAX: Topn is not a Filter
In this document I will demonstrate how using the TOPN function in a DAX query doesn’t necessarily do what you may expect.
2014-05-01
4,389 reads
DAX Query - Part 2
A more detailed look at the DAX language and some of its more frequently used functions
2013-12-13 (first published: 2013-05-02)
11,287 reads
DAX Query Basics
In this document I will attempt to talk you through writing your first very simple DAX queries. For the purpose of this document I will query the rather familiar Adventure Works Tabular Cube.
2013-12-13 (first published: 2012-09-25)
28,511 reads
Asynchronous Procesing with Service Broker
Service Broker is a great feature that allows you to defer processing in SQL Server. Learn how you can have processes work together, but in an asynchronous fashion in this piece from Gary Strange.
2011-05-17
9,972 reads
Blogs
Parameter Sensitive Plan Optimization in SQL Server 2022. What is it and is it any good?
Parameter Sensitive Plan (PSP) optimization is a new feature in SQL Server 2022 that...
Azure chaos STUDIO
By Arun Sirpal
Chaos engineering is fun but especially important when building solutions in the cloud. It...
Announcing a New Book on SQL from 3Cloud Authors
By DataOnWheels
I am proud to announce the launch of a new book, centered around the...
Forums
Delayed tcp acknowledgement registry setting
Our IT department contacted me recently and asked if they should change the default...
Fact Table - Various Grains
Hi there, I'm on a team developing an enterprise data warehouse for our organization....
PostgreSQL Copy
Comments posted to this topic are about the item PostgreSQL Copy
Ask SSC