Top 10 New Features in SQL Server 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...
SQLServerLog.com - Database Tips, Techniques and Tutorials
SQL Server Interview Questions and Answers
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...
Find SQL Server Last Restart Time and Resource Information with Useful DMV sys.dm_os_sys_info
SQL Server provides DMVs and system tables to find out when SQL Server was last restarted. We may need this information many times to troubleshoot or trace issues which occurs on database servers. So,...
Identify when Statistics were last Updated in SQL Server Database
403views 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...
Find All Tables Missing Clustered Index in Database
343views 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...
Find Number of Connections on Databases and Instance Used By Logins
We have a query which is very useful for DBAs and database users to find total number of connections used by particular login on database instance for all databases or on particular database. Here I am...
