SQL

SQLServerCentral Article

SQL Window Functions Series: NTILE()

  • Article

Unlock the power of SQL's NTILE function with our latest deep-dive article. Learn to segment your data effectively into quantiles for more nuanced analysis, discover common pitfalls and their solutions, and optimize your queries for peak performance.

4.67 (3)

You rated this post out of 5. Change rating

2024-02-03 (first published: )

4,747 reads

SQLServerCentral Article

5 (4)

You rated this post out of 5. Change rating

2023-11-20 (first published: )

11,411 reads

External Article

Introduction to SQL for Cosmos DB

  • Article

This article by Adam Aspin reviews the Azure Cosmos DB SQL API from the perspective of the relational database developer. More specifically it will show you how to leverage your Structured Query Language skills to exploit the core possibilities of Cosmos DB as a NoSQL document database.

2019-03-25

219 reads

External Article

Resumable Online Index Create and Rebuild Operations

  • Article

Index maintenance can be a real headache for database administrators as tables grow larger and maintenance windows shrink. In this article, Greg Larsen demonstrates resumable index operations available with SQL Server 2017 and 2019. This feature helps DBAs work around those small maintenance windows by allowing certain index operations to be paused and restarted again later.

2019-03-21

1,738 reads

Blogs

T-SQL Tuesday 188 - Growing the Younger Data Community and Speakers

By

T-SQL Tuesday is a monthly blog party hosted by a different community member each...

Azure Cloud Chronicles with Microsoft MVPs YouTube Channel

By

In my YouTube subscriptions feed, a new video for the Azure Cloud Chronicles with...

T-SQL Tuesday #188: Growing the Community

By

This month we have a great T-SQL Tuesday, hosted by John Sterrett. He has...

Read the latest Blogs

Forums

How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory

By Chandan Shukla

Comments posted to this topic are about the item How a Legacy Logic Choked...

Has the PK been used --

By dbakevlar

Comments posted to this topic are about the item Has the PK been used...

Has the PK been used --

By dbakevlar

Comments posted to this topic are about the item Has the PK been used...

Visit the forum

Question of the Day

Has the PK been used --

You're analyzing a query execution plan in SQL Server to determine whether the query optimizer chose to use a primary key index. Which Dynamic Management View (DMV) would you use to verify the usage of the primary key in the plan?

See possible answers