By SQLRx Admin | Helpful Scripts , Miscellaneous , SQL Server , Tip of the Month
Find out if any of tables in your database have special features enabled using the queries below. These features need to be understood and carefully managed. — CDC Enabled Tables select distinct t.name AS CDCTables from sys.tables t where t.is_tracked_by_cdc = 1 — File Tables — SQL 2012 + select distinct t.name AS FileTables from […]
Continue readingBy Lori Brown | Helpful Scripts , SQL Administration , SQL Maintenance , SQL Server
I ran into a situation where we were working on a migration and had been directed to put all databases into FULL recovery model in anticipation of using log shipping to push databases to the new server. Once we are ready to go live on the new server the plan was to ship the last […]
Continue readingBy SQLRx Admin | Miscellaneous , SQL 2017 , SQL Server
Since we at SQLRX have been super busy this week and still need to do something for a blog post, I thought that doing a link round up of new dynamic management views that are going to be available in SQL 2017 would be a quick and good idea. I am really interested in sys.dm_db_log_info […]
Continue readingBy Ginger Daniel | Backup and Restore , Log Shipping , SQL Administration , SQL Server
For years the SQL Agent service account on my client’s SQL Server instance ran the Maintenance Plans and SQL Agent jobs with no issues. Many of the SQL databases were set to Full recovery model, and Tlog backups executed on regular bases with no problems. The client decided to migrate to new hardware in a […]
Continue readingBy SQLRx Admin | ColumnStore , SQL Administration , SQL Server , Tip of the Month
Find out if any of your tables contain special columnstore or spatial indexes. Columnstore indexes organizes the data in columns instead of rows like traditional indexes and can increase performance on large data sets as found in data warehouses. Spatial indexes are a special type of index on a spatial column such as geometry or […]
Continue readingBy Jeffry Schwartz | Performance Tuning , SQL Development , SQL Server
The Problem Many articles concerning SQL Server discuss how record insertion overhead increases with each additional index. They discuss b-tree manipulations and page splits in addition to leaf and non-leaf levels. However, few discuss the fact that deletion overhead increases as well, especially when large numbers of records are deleted by individual queries. Recently, I […]
Continue readingBy Ginger Daniel | SQL Administration , SQL Server
It is not uncommon for a DBA or other IT staff to set up AlwaysOn in a SQL environment and later leave the company. We ran into this recently with a client and were asked to delete the previous employee’s login from everything SQL related. We were able to remove the login from all databases […]
Continue readingBy Lori Brown | Backup and Restore , Beginner , Helpful Scripts , SQL Administration , SQL Server
We recently started using a third party software to do our in-house SQL backups so that the backup files are stored in a redundant and safe place. To confirm that the software was indeed compressing backups as it stated it would, we wanted to see what each backup size actually was in SQL so that […]
Continue readingBy Jeffry Schwartz | Expert , Missing Indexes , Performance Tuning , Query Tuning , SQL Development , SQL Server
The Problem Many articles concerning SQL Server missing index recommendations demonstrate the mechanics for obtaining them and often highlight whether the suggested key columns are used in equality or inequality relationships. Most of these examples emphasize a single index that can be implemented to improve performance. However, real-life situations often involve multiple or many suggested […]
Continue reading