Below is the script to find the fragmentation of the indexes created on a database.
SELECT OBJECT_NAME(OBJECT_ID), index_id,index_type_desc,index_level,
avg_fragmentation_in_percent,avg_page_space_used_in_percent,page_count
FROM sys.dm_db_index_physical_stats (DB_ID( N'Database name')...
2015-01-07 (first published: 2015-01-04)
7,224 reads
Below is the query to find out all the Queries and their details like SSID etc. running on the SQL...
2015-01-04
1,588 reads
Many times I was asked how to pass Microsoft certifications and how difficult it is. In my point of view,...
2015-01-03
1,007 reads
Technical Round Database Interview Questions
1) What are the different types of Trace flags which we used for detecting the Deadlock?
2)...
2014-11-03
1,368 reads
Below is the list of linkedin articles which I liked most. These articles gives you lot of motivation.
7 Bad Management...
2014-10-19
582 reads
Many times my friends ask me which technical sites they should refers for finding the solutions, so below is the...
2014-10-12
1,469 reads
In SQL Server, database can be created by 2 ways:-
Using Create Database command Using SQL Sever Management Studio (SSMS).
In this article,...
2014-08-20 (first published: 2014-08-17)
7,802 reads
SQL server gives the exception/error handling mechanism which is similar to c#, Try..Catch block. In SQL Server, we can write...
2014-08-19 (first published: 2014-08-11)
10,197 reads
SQLTea - Our new SQL Tutorial App on Google Play StoreWe are happy to announce our new SQL tutorial app SQLTea...
2014-08-18
1,375 reads
In the previous article (Database Creation using Create Database command), I explained the database creation using the Create database command....
2014-08-17
946 reads
In last months one of the scenarios where you can use AI has been...
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Comments posted to this topic are about the item Backup to Immutable Storage
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Comments posted to this topic are about the item Expanding into Print
In SQL Server 2025, a backup can be made on Azure Immutable Storage. What changes in how the backup is created?
See possible answers