Covering Indexes: Not Just for SELECT but also for UPDATE statements
Covering indexes help UPDATE performance also
2018-05-15
12,368 reads
Indexing
2018-05-10
867 reads
Missing Index Impact and Join Type
Erik Darling shows how missing index requests have different impact numbers depending on the query's join type.
2018-04-26
7,058 reads
When Does Index Size Change Index Choice?
Erik purposely fragments indexes trying to slow down queries.
2018-02-15
3,508 reads
2018-02-06
972 reads
2018-06-07 (first published: 2018-01-13)
2,356 reads
2018-06-15 (first published: 2018-01-04)
2,080 reads
2017-11-02
1,043 reads
Indexing for Windowing Functions: WHERE vs. OVER
Erik Darling shows that if you take SQL Server's word when it asks for an index, things can go horribly awry.
2017-10-09
4,023 reads
2017-04-20
1,237 reads
Blogs
Can I Change a Primary Key Value? #SQLNewBlogger
By Steve Jones
I heard someone say recently that you can’t change a primary key value in...
SQL Server Index Primer
By Kevin3NF
Indexes 101: What, Why, and When? “What Is an Index?” I get this question...
Secure Azure SQL Server Backups Using Managed Identities
By Arun Sirpal
I do believe most people know about the ability to backup your SQL server...
Forums
Just a rant about the SQL Server 2022 upgrade
Upgrading an instance of SQL Server 2019 to SQL Server 2022 - I am...
Report Server Configuration Manager - The target principal name is incorrect SSL
SQL Server SSRS 2022. Running into ' SSL Provider, error: 0 - The target...
Report Server Configuration Manager - Change Database - SSL Error
SQL Server SSRS 2022. Running into ' SSL Provider, error: 0 - The target...
Question of the Day
Getting the TEXTSIZE
How can I check what value I used for TEXTSIZE? I ran this code:
SET TEXTSIZE 8096But then deleted the code and couldn't remember. Is there a way to check this? See possible answers