Wednesday, October 27, 2010

Maximum Number of Index per Table in SQL SERVER

SQL Server 2005:
1 Clustered Index + 249 Nonclustered Index = 250 Index

SQL Server 2008:
1 Clustered Index + 999 Nonclustered Index = 1000 Index

No comments:

Split the String values with a special character in MS Flow to convert this into Array

 Many times we have a requirement to prepare the Mailing address for some of the documents, suppose there are Address Line1, Address Line2, ...