In Part 1 of this article we looked at a specific use case (probably exaggerated) that gave us an idea about how CPU and IO performance might be affected by a bad page split. We continue this analysis looking at what really happens to the data on the leaf pages of a clustered index with […]
2020-07-02
3,788 reads
In this tip we look at the impact of building SQL Server indexes in ascending versus descending order and the impact.
2020-02-04
Microsoft SQL Server has the feature to use “Included columns” for the creation of non-clustered indexes. This feature and its benefits and disadvantages will be explained in the following article. Included columns can be used to create a covering indexes without including all the data into the key columns. This covering index has the advantage […]
2019-09-17
7,725 reads
With origins from the world of “Submarine ‘Dolphin’ Qualification” questions, an “Oolie” is a difficult question to answer, or the knowledge or fact needed to answer such a question, that may or may not pertain to one's duties but tests one's knowledge of a system or process to the limit. Introduction Contrary to what many […]
2019-08-08
5,146 reads
In this tip we look at a PowerShell script you can use to collect index information for all of your SQL Server instances that you manage.
2019-06-26
Can be useful when inserting a lot of data into a table.
2019-02-26 (first published: 2019-02-14)
2,187 reads
This level of the Stairway to Exploring Database Metadata focuses on indexes and all the information you can gather about them.
2020-08-05 (first published: 2016-09-28)
4,290 reads
By Andy Warren
in my last post I wrote about thinking of the tools as being a...
By Devin-Knight
There are a lot of hot phrases you’ve likely heard thrown around during various...
By Kamil
Azure Data Factory is a fantastic tool which allows you to orchestrate ETL/ELT processes...
Hello SSC friends, I am a SQL Developer who is learning how to be...
Comments posted to this topic are about the item Who is my customer?
Hi, First time poster, and hoping everyone goes easy on me. I am very...
Ask SSC