sql query

Article

Welcome to the fascinating world of SQL window functions! Today, we'll explore in detail: RANK() and DENSE_RANK().

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(4)

You rated this post out of 5. Change rating

2023-11-20 (first published: 2023-11-15)

16,615 reads

Discuss

Optimized Plan Forcing with Query Store in SQL Server 2022

by Prakash K

SQLServerCentral

Article

In this Article , We will delve into the world of Query Store and explore how to use Optimized Plan Forcing to improve performance in SQL Server 2022. We will discuss what it is, how it works, and how it can impact your system's performance.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2023-09-04

5,625 reads

Discuss

MSSQL Server AlwaysON: Get alerted for inconsistencies in logins, jobs and databases

by Arun Yadav

SQLServerCentral

Script

This script will create the necessary login and linked servers on a given availability replica. Please ensure that the script is executed on all the replicas.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(6)

You rated this post out of 5. Change rating

2022-02-22 (first published: 2022-01-25)

7,914 reads

Discuss

Power Query or SQL Server? Which, when and why

by Victor Sánchez Jáuregui

SQLServerCentral

Article

When it comes to developing a Power BI report, we can use it for accessing data, transforming the data, and turning the data into information using visuals. With no doubt Power BI can do the job from beginning to end. Now, this is not the only, nor necessarily the best, tool for all the steps […]