SQL SERVER – Query to find number Rows, Columns, ByteSize for each table in the current database – Find Biggest Table in Database (via Journey to SQLAuthority)

USE DatabaseName GO CREATE TABLE #temp ( table_name sysname , row_count INT, reserved_size VARCHAR(50), data_size VARCHAR(50), index_size VARCHAR(50), unused_size VARCHAR(50)) SET NOCOUNT ON INSERT #temp EXEC sp_msforeachtable 'sp_spaceused ''?''' SELECT a.table_name, a.row_count, COUNT(*) AS col_count, a.data_size FROM #temp a INNER JOIN information_schema.columns b ON a.table_name collate database_default = b.table_name collate database_default … Read Morevia Journey to SQLAuthority

Advertisements

Error : the RPC security information for the publisher is missing or invalid

This is genereally an error which will be throw when you have a replicated set of data in SQL Server and if you are trying to perform a DML statement on the table it gives this error. This error is generally  related to network transaction in DCOM service in Windows. To allow the network transaction, … Continue reading Error : the RPC security information for the publisher is missing or invalid