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,240 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,603 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,024 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,382 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
596 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,484 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,842 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,243 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,381 reads
In the previous article (Database Creation using Create Database command), I explained the database creation using the Create database command....
2014-08-17
961 reads
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Comments posted to this topic are about the item Absolute and Relative References
Comments posted to this topic are about the item Moving Beyond the Reboot: Finding...
Comments posted to this topic are about the item Reserved Words I