SQL Window Functions Series: RANK() and DENSE_RANK()
Welcome to the fascinating world of SQL window functions! Today, we'll explore in detail: RANK() and DENSE_RANK().
2023-11-20 (first published: 2023-11-15)
9,199 reads
sql query
Optimized Plan Forcing with Query Store in SQL Server 2022
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.
2023-09-04
4,272 reads
MSSQL Server AlwaysON: Get alerted for inconsistencies in logins, jobs and databases
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.
2022-02-22 (first published: 2022-01-25)
7,514 reads
Power Query or SQL Server? Which, when and why
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 […]
2021-01-25
16,823 reads
Fill In Missing Dates for SQL Server Query Output
In this tip we look at how to fill gaps in dates and times for SQL Server query output when no data exists for specific dates or times.
2019-07-31
Blogs
Cool AI sites
By James Serra
As I researched and wrote my OpenAI and LLMs blogs (see Introduction to OpenAI...
A Quick Test Data Manager Eval with My Database Backup
By Steve Jones
I wrote about getting the Redgate Test Data Manager set up in 10 minutes...
Take over Ownership in Microsoft Fabric
When you create an item in Microsoft Fabric (a notebook, a lakehouse, a warehouse,...
Forums
Why you should avoid Implicit Measures in your Power BI model
Comments posted to this topic are about the item Why you should avoid Implicit...
Getting below error
An error occurred during recovery, preventing the database 'XXXXX' (28:0) from restarting. Diagnose the...
Why is "SELECT *" about 10 times faster than "SELECT (ALL Columns)"
Dear all, I have noticed that a "SELECT * ..." is about 10 time...
Question of the Day
Dates and Languages
The string, listopad, translates to a month name in different languages. If I were to run this code, what values are returned?
DECLARE @yourInputDate NVARCHAR(32) = '28 listopad 2018'; SET LANGUAGE Polish; SELECT CONVERT(DATE, @yourInputDate) AS [SL_Polish]; SET LANGUAGE Croatian; SELECT CONVERT(DATE, @yourInputDate) AS [SL_Croatian]; SET LANGUAGE English;See possible answers