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,221 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,582 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,004 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,364 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
576 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,467 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,789 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,182 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,374 reads
In the previous article (Database Creation using Create Database command), I explained the database creation using the Create database command....
2014-08-17
945 reads
By Chris Yates
There was a time when the Chief Data Officer lived in the shadows of...
By Rayis Imayev
"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help...
By Steve Jones
I saw some good reviews of the small gemma3 model in a few places...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item We Should Demand Better
Comments posted to this topic are about the item Estimated Rows
I have two calls to the GENERATE_SERIES TVF in this code:
SELECT TOP 10 gs.value FROM GENERATE_SERIES(1, 10) AS gs ORDER BY NEWID () OPTION (RECOMPILE); go DECLARE @a int = 10; SELECT TOP (@a) gs.value FROM GENERATE_SERIES(1, @a) AS gs ORDER BY NEWID () OPTION (RECOMPILE);In the actual query plans, what is the estimated number of rows for each batch? See possible answers