Database Administration / Performance Tuning / SQL Server
by Manzoor Siddiqui · Published October 9, 2015 · Last modified February 12, 2021
1.3kviews If you want to identify when last time statistics were updated on objects in database then you can use either DBCC SHOW_STATISTICS header information or sys.stats catalog view. Below example displays all statistics information for the...
Database Administration / Performance Tuning / SQL Server
by Manzoor Siddiqui · Published October 8, 2015 · Last modified November 12, 2015
1.1kviews If your database contains hundreds or thousands of tables then it’s difficult to find which tables are missing clustered index in a database manually. You can go through this article which provides very...
Database Administration / Performance Tuning / SQL Server / SQL Tips and Tricks
by Manzoor Siddiqui · Published October 6, 2015 · Last modified October 25, 2015
1.8kviews As a DBA, time to time we have to trace SQL queries which are consuming highest CPU utilization in SQL Server and need to tune those queries. You can refer below query which...
1.9kviewsSQL Server Data Migration Assistant (DMA) is a free tool developed by Microsoft to help you migrate your databases to a newer version of SQL Server or even migrate them to the cloud, specifically...
1.9kviewsHere are some of the key new features introduced in SQL Server 2022: Cloud-connected features: Performance and scalability: Security: Machine learning: Other notable features: Azure-connected features: Reference: Manzoor Siddiqui [www.SQLServerLog.com]
Database Administration / SQL Server
by Manzoor Siddiqui · Published March 27, 2016 · Last modified June 25, 2021
915viewsAll the jobs information are stored in system tables of MSDB system database. Here we are going to use sysjobs and sysjobhistory tables to monitor information for each scheduled jobs execution. Below query will help...
SQL Commands / SQL Programming / SQL Server
by Manzoor Siddiqui · Published February 27, 2016 · Last modified May 25, 2016
443viewsSQL constraints are set set of rules by which SQL engine enforces the integrity of database. Constraint maintains the standard rules to follow so that integrity in database can be maintained. If there is...
Database Administration / SQL Server / SQL Tips and Tricks
by Manzoor Siddiqui · Published January 30, 2016 · Last modified May 24, 2016
785viewsSQL Server provides very useful T-SQL to find out details about property information of SQL Server instance by querying SERVERPROPERTY. With this T-SQL you can find out information like Product Version, Server Name, Edition,...
SQL Commands / SQL Programming / SQL Server
by Manzoor Siddiqui · Published December 27, 2015 · Last modified May 16, 2016
788viewsIn many tables we use Identity column to maintain the uniqueness and automatically increment the values when records are inserted. If you want to reset the identity column numbers in a table then we...
