Cleanup Indexes not in use
Among the many tasks that are under the DBA’s responsibilities is keeping the database performing well and in good health. And when mentioning performance the
No Comments
Read More »
Use SQL Server’s missing indexes feature
SQL Server exposes missing indexes metadata via the following 3 DMVs (Dynamic Management Views) sys.dm_db_missing_index_details, sys.dm_db_missing_index_groups and sys.dm_db_missing_index_group_stats which combined in a simple query return
No Comments
SQLScripter
SQLScripter is a powerful command line utility designed to automate the process of schema generation. SQLScripter simply preserves your schema on the file system at
No Comments
Implement SQL Server Agent Jobs with AlwaysOn Availability Groups
In this post I talk about SQL Server Agent jobs when implementing AlwaysOn Availability Groups. AlwaysOn Availability Groups synchronizes the databases that are part of an Availability
No Comments
sp_helpindex2
As far as I recall the trigger to code sp_helpindex2 was that with the introduction of INCLUDE columns to indexes that was added in SQL Server 2005 the old
No Comments
Use Powershell to Multi Thread SQL Server Index Maintenance tasks
This is my very first blog post at my own site after over a year of none blogging. What happened is that the site I
No Comments
The following two tabs change content below.
Yaniv Etrogi is an SQL Server consultant. He loves SQL Server and he is passionate about Performance Tuning, Automation and Monitoring.
Latest posts by Yaniv Etrogi (see all)
- Monitor AlwaysOn Availabilty Groups - July 6, 2023
- SQL Server – The secret index syntax - February 8, 2023
- Use .net SqlClient with Powershell to access data - January 25, 2023
- Use Powershell to find unused resources in Azure - August 5, 2022