Building SQL Server Indexes in Ascending vs Descending Order
In this tip we look at the impact of building SQL Server indexes in ascending versus descending order and the impact.
2020-02-04
Indexes
“Included columns” for non-clustered indexes explained
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
5,995 reads
Some T-SQL INSERTs DO Follow the Fill Factor! (SQL Oolie)
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
4,817 reads
Collect SQL Server Index Usage Information for all Instances with PowerShell
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
Disable or rebuild all nonclustered indexes on a table
Can be useful when inserting a lot of data into a table.
2019-02-26 (first published: 2019-02-14)
1,468 reads
Blogs
SQL Prompt and SSMS 18.5
By Steve Jones
I downloaded SSMS 18.5, as there were a lot of fixes in here and...
Jupyter Book Challenges in ADS
By Steve Jones
I was excited to try the Jupyter Book feature in the March Azure Data...
Join me (virtually) in Adelaide!
I will be presenting a session to the Adelaide SQL Server User Group on...
Forums
Always on Availability Groups
Can i configure a 2 Node AG Availability group in the same data(local site) ...
DB mail issue
We received error when testing the DBmail The mail could not be sent to...
Issue with case statement
i have a table A where the data looks like ID Name Phone CODE...
Ask SSC