Get the Sql Database tables record count till date

SELECT T.name AS [Table Name],

I.rows AS [Record Count]

FROM sys.tables AS T

INNER JOIN sys.sysindexes AS I

ON T.object_id = I.id

AND I.indid < 2

ORDER BY I.rows DESC




SELECT

t.NAME AS TableName,

i.name as indexName,

p.[Rows],

sum(a.total_pages) as TotalPages,

sum(a.used_pages) as UsedPages,

sum(a.data_pages) as DataPages,

(sum(a.total_pages) * 8) / 1024 as TotalSpaceMB,

(sum(a.used_pages) * 8) / 1024 as UsedSpaceMB,

(sum(a.data_pages) * 8) / 1024 as DataSpaceMB

FROM

sys.tables t

INNER JOIN

sys.indexes i ON t.OBJECT_ID = i.object_id

INNER JOIN

sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id

INNER JOIN

sys.allocation_units a ON p.partition_id = a.container_id

WHERE

t.NAME NOT LIKE 'dt%' AND

i.OBJECT_ID > 255 AND

i.index_id <= 1

GROUP BY

t.NAME, i.object_id, i.index_id, i.name, p.[Rows]

ORDER BY

p.[Rows] DESC

--object_name(i.object_id)

Loop through the SQL Table and add columns to it

create table #Temp

(
testID int

)
select object_id('tempdb..#Temp')

SELECT top 10 OBJECT_ID FROM tempdb.sys.columns WHERE object_id = object_id('#Temp')

select * from #Temp

declare @counter_val int = 0

WHILE ( SELECT COUNT(*) FROM tempdb.sys.columns WHERE object_id = object_id('tempdb..#Temp')) < 1000

BEGIN

set @counter_val = @counter_val + 1

DECLARE @SQL NVARCHAR(MAX)

declare @fieldname nvarchar(20)

SET @fieldname = 'niraj' + cast(@counter_val as nvarchar(10))

   

SET @SQL = 'ALTER TABLE #Temp

ADD [' + CAST(@fieldname AS VARCHAR(10)) + '] varchar(30)'

--PRINT @SQL

EXECUTE (@SQL)

END

　

　

drop table #Temp

How can I retrieve old code before merge with new code in TFS

Issue -
By mistake if you merge the new code(of server) with your local code and now you want to retrieve the old code before the merge ...

Solution -
You can use below path to get the temp file which has old code, TFS storing this data as temp data in this folder ... VERY MUCH USERFUL

Path : C:\Users\%USERNAME%\AppData\Local\Temp\TFSTemp\