Sql Query

Sql Query

/* Delete Duplicate records */WITH CTE (COl1,Col2, DuplicateCount)AS(SELECT COl1,Col2,ROW_NUMBER() OVER(PARTITION BY COl1,Col2 ORDER BY Col1) AS DuplicateCountFROM DuplicateRcordTable)DELETE
FROM CTEWHERE DuplicateCount > 1
GO

----------------------------------------------------------------------------------------

SQL SERVER – 2008 – 2005 – Rebuild Every Index of All Tables of Database – Rebuild Index with FillFactor

 DECLARE @TableName VARCHAR(255)DECLARE @sql NVARCHAR(500)DECLARE @fillfactor INT
SET @fillfactor = 80DECLARE TableCursor CURSOR FOR
SELECT OBJECT_SCHEMA_NAME([object_id])+'.'+name AS TableNameFROM sys.tablesOPEN TableCursorFETCH NEXT FROM TableCursor INTO @TableNameWHILE @@FETCH_STATUS = 0BEGIN
SET @sql = 'ALTER INDEX ALL ON ' + @TableName + ' REBUILD WITH (FILLFACTOR = ' +CONVERT(VARCHAR(3),@fillfactor) + ')'EXEC (@sql)FETCH NEXT FROM TableCursor INTO @TableNameEND
CLOSE TableCursorDEALLOCATE TableCursor
GO

-------------------------------------------------------------------------------------------

http://iis-7.blogspot.in/2012/09/iis-interview-questions.html
http://www.dotnetfunda.com/interviews/cat/122/iis
http://www.scribd.com/doc/94909071/IIS-Interview-Questions-and-Answers
http://www.iis.net/learn/web-hosting/frequently-asked-questions-%28faq%29/general-iis7-questions