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,073 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
4,584 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)
1,020 reads
Bob Pusateri (B|T) tweeted a quote image that really struck a chord with me...
I consider myself to be the most responsible for making such a huge deal...
By Andy Warren
The last two years we did Family Feud as part of our end of...
Guys, Can I use SSMS 2014 Express edition to connect to a lower and...
I encountered a weird issue and hope that somebody may have a fix for...
Comments posted to this topic are about the item Function to pad Bigint with...
Ask SSC