SQL

Use below query to find the tables in a database based on Size SELECT O.Name AS [Table],         SUM(A.Total_Pages) AS [Reserved Pages],...

Use below function to convert Seconds to HH:MM:SS Create Function dbo.GetHHMMSS(@InputSecs BIGINT) RETURNS nVarChar(Max) Begin Declare...

Sometime when you try to restore a backup over an existing database, the following error may appear: RESTORE DATABASE is terminating abno...

You can use below query to get the list of all database restored in SQL Server: SELECT [RS].[Destination_Database_Name] AS [Destination D...

There must be a numeric identity / Unique column for comparing current with next / previous Rows in a table.  Lets say you want to compar...