Column Store Index in SQL
Column Store Index in SQL Server 2016. ColumnStore Indexes are great! They are a real performance booster for Data Warehousing and Reporting workloads. In combination with Clustered Column Store Indexes you get a [...]
Unable to Delete a Tempdb Data File
Unable to Delete a Tempdb Data File. Once in a while as a DBA you might come across a situation where in you are required to remove a data file from the tempdb [...]
Remove or Archive Old Partitions when we have multiple partitions in multiple filegroups in SQL Server
Remove or Archive Old Partitions when we have multiple partitions in multiple filegroups in SQL Server. Scenario: Remove old partitions from a partition table, you should either issue a Delete or Switch command. [...]
SQL Server – Data Partitioning
SQL Server Large Tables with Data Partitioning. Partitioning is primarily planned to make managing large tables easier for database administrators. However, partitioned objects can also improve performance of SELECT, UPDATE and DELETE queries. [...]
Using EXCEPT and UNION combination to select uncommon values from two tables on SQL server
Using EXCEPT and UNION combination to select uncommon values from two tables on SQL server. I came across a problem from my client where he wanted me to prepare the list of all the [...]
Database Auto_Close – Please keep it turned off!
Database Auto_Close – Please keep it turned off! Just a few days ago, we observed that our daily differential backup job failed on one of our not so busy servers. On checking the [...]