Knowledge Base Category: Development

Dns Clean up

Start > Run > CMD Right click and run as administrator, Then type the following:
ipconfig /flushdns
net stop dnscache
net start dnscache
  To Refresh Group Policy:
gpupdate
You may also use:
gpresult
 ...
Read more

Database Table Size Script for SQLServer

I found these two scripts online, very useful for rows counts and size:
Declare @QueryString NVARCHAR(MAX);
Select @QueryString =COALESCE(@QueryString + ' UNION ALL ','') +
					'SELECT ' +
					'''' + QUOTENAME(SCHEMA_NAME(sOBJ.SCHEMA_ID)) +
					'.' + QUOTENAME(sOBJ.name) + ''''+ ' AS [TABLENAME]
					, COUNT(*) AS [RowCount] FROM ' + QUOTENAME(SCHEMA_NAME(sOBJ.SCHEMA_ID)) +
					'.' + QUOTENAME(sOBJ.name)... 						
						
Read more