SQL

Here is a useful script to get the unused index in a Database. This may be inaccurate sometime. So you had to apply commonsense before runn...

I got this error in my event log ID 10016 of my database server installed with Windows Server 2012, in which i have only installed SQL ser...

Intellisense is a new feature that comes with SSMS(SQL Server Management Studio) 2008 onwards. Intellisense makes coding quite easy.  Some...

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...