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,630 reads
This is an investigation, to get an impression on the impact of the used disk space before and after compression considering different index types.
2017-03-23
1,040 reads
I wrote a short blog post about the misperception that Profiler was easier than...
If you read the title to this post and your first thought was That’s...
sys.xp_delete_files and 'allow filesystem enumeration': two new undocumented items in SQL Server 2019… Continue...
Good Morning All -I have used triggers to do some basic auditing, but I...
Hello, Our company has used SQL replication to refresh our staging data on a...
Ask SSC