Fastest way to get rows count from large table (sql server database)
Query: SELECT Total_Rows= SUM(ss.row_count) FROM sys.dm_db_partition_stats ss WHERE object_name(object_id) = ' Table name...Read More
Popular Posts
-
Log file creating using Log4net in Asp.net and C# By adding log4net.dll reference to project we can create log file. I will show you ste...
-
Inserting multiple values to database using single textbox with values separated with comma [,]: Front end Code: Am just creat...
-
Here is the example for EF core 2.0 model with all data annotations. Primarykey Table: [Table( "Master" , Schema = "Ad...
-
Query: SELECT Total_Rows= SUM(ss.row_count) FROM sys.dm_db_partition_stats ss WHERE object_name(object_id) = ' Table name...