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,235 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,600 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,023 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,380 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
595 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,483 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,830 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,239 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,380 reads
In the previous article (Database Creation using Create Database command), I explained the database creation using the Create database command....
2014-08-17
950 reads
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
We have performed a side-by-side upgrade, from SQL Server 2016 to 2022 Developer Edition,...
Comments posted to this topic are about the item Automating OSM Data Refresh in...
Comments posted to this topic are about the item Database Mail Configuration
If I want to get a list of the configuration settings for Database Mail using T-SQL, how can I do so?
See possible answers