Recent

• Parsing of XML data has high CPU usage
• Convert simple Javascript to jQuery plugin
• Active Record getting unique records
• List the files in a directory without the directory name or the extension
• clean the code
• ohs system, recruitment software, hr software, oh&s software, human resources software, ohs software
• Array parsing in a block
• Learning JS
• Type Safety
• Euler Problem 2 solution

Popular

• Parsing of XML data has high CPU usage
• List the files in a directory without the directory name or the extension
• Convert simple Javascript to jQuery plugin
• Active Record getting unique records
• Breadth first cartesian product iterator
• php refactoring
• first BST
• Learning JS
• Too many if statements
• clean the code

Pastable version of Drop all Indexes in SQL Server

<pre class='prettyprint' language='cs'>Declare @Index varchar(128) Declare @Table varchar(128) Select SysIndexes.Name As 'Index', SysObjects.Name As 'Table' Into #Indexes From SysIndexes Inner Join SysObjects On SysObjects.id = SysIndexes.id Where SysIndexes.Name Is Not Null and SysObjects.XType = 'U' Order By SysIndexes.Name, SysObjects.Name While (Select Count(*) From #Indexes) &gt; 0 Begin Set @Index = (Select Top 1 [Index] From #Indexes) Set @Table = (Select Top 1 [Table] From #Indexes) --Print 'Drop Index [' + @Index + '] On [' + @Table + ']' + Char(13) Exec ('Drop Index [' + @Index + '] On [' + @Table + ']') Delete From #Indexes Where [Index] = @Index and [Table] = @Table End Drop Table #Indexes</pre> <a href="http://www.refactormycode.com/codes/522-drop-all-indexes-in-sql-server" style="color:#fff" title="As seen on RefactorMyCode.com"><img alt="Small_logo" src="http://www.refactormycode.com/images/small_logo.gif" style="border:0" /></a>