Database Administration / Performance Tuning / SQL Server
by Manzoor Siddiqui · Published October 9, 2015 · Last modified February 12, 2021
305views 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
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 simple...
Database Administration / Performance Tuning / SQL Server / SQL Tips and Tricks
by Manzoor Siddiqui · Published October 6, 2015 · Last modified October 25, 2015
555views 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...
440viewsSQL 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...
917viewsHere 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
406viewsAll 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
SQL 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
309viewsSQL 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
316viewsIn 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...
