Database Administration / Performance Tuning / SQL Server
by Manzoor Siddiqui · Published October 9, 2015 · Last modified February 12, 2021
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 AK_Currency_Name...
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
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 provides...
Database Administration / SQL Server
by Manzoor Siddiqui · Published March 27, 2016 · Last modified June 25, 2021
All 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
SQL 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
In 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...
Articles / SQL Server / Tutorials
by Manzoor Siddiqui · Published November 29, 2015 · Last modified May 26, 2016
Microsoft is releasing new and exciting features with new versions over the time. SQL Server 2016 also has lots of new features for database users and it has been reformed and made database users...
Interview Q&A / SQL DBA Interview Q&A / SQL Developer Interview Q&A / SQL Server
by Manzoor Siddiqui · Published October 11, 2015 · Last modified December 8, 2015
1. What do mean by XML Datatype? XML data type is used to store XML documents in the SQL Server database. Columns and variables are created and store XML instances in the database. 2. What...
More
