2024-01-29
373 reads
Query Store
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
2,912 reads
2023-04-28
313 reads
2023-02-20
431 reads
2020-12-28
515 reads
2020-11-20
607 reads
2020-02-13
563 reads
Query Store And Cruel Defaults
Erik Darling loves query store, but he really hates the default capture mode.
2019-01-25
2,931 reads
Blogs
Degrees and Trade Schools
By Kevin3NF
Can we normalize a couple of things? 1 – Trade Schools. Back in the...
Unlock the Power of Your Data: From Basic to Advanced Data Analysis
Data isn't just about numbers and spreadsheets. It holds stories, patterns, and the answers...
Attacking the Weakest Link
By Brian Kelley
When I look at a system and think about its security model, the first...
Forums
plugging a repo version number into the tabular model
hi we run 2019 std. we saw this week that someone hid 3 important...
The "ORDER BY" clause behavior
Comments posted to this topic are about the item The "ORDER BY" clause behavior
Are IT Certifications Still Relevant?
Comments posted to this topic are about the item Are IT Certifications Still Relevant?
Question of the Day
The "ORDER BY" clause behavior
Let’s consider the following script that can be executed without any error on both SQL Sever and PostgreSQL. We define the table t1 in which we insert three records:
create table t1 (id int primary key, city varchar(50)); insert into t1 values (1, 'Rome'), (2, 'New York'), (3, NULL);If we execute the following query, how will the records be sorted in both environments?
select city from t1 order by city;See possible answers