SurendraThotaMSBIProfessional

Hi All we need to Create index on some of the Matching attributes in our Customer Entity. It is not straight forward in MDS DB , so for that we need to do the fallowing steps Step1 : Get the Entity ID and EntityTable metadata from mdmtblEntity  table in MDS DB Step2 : Need to Get the attribute tablecolumn from mdm.tblAttribute table . we can create a Dynamic query to create custome index when you know EntityName and attributes names. Dyanmic query USE MDS GO Declare @SQL Varchar(2000), @f int =0 Declare  @i int, @S Varchar(50) Select @S=EntityTable , @i=ID From mdm.tblentity where name='Customer' If Exists (Select Name From Sysindexes Where Name='IX_Customer_MatchAttributes_001') Begin Set @SQL ='Drop Index IX_Customer_MatchAttributes_001 on mdm.' +  @S exec  (@SQL) set @f=1 End Set @SQL   ='CREATE NONCLUSTERED INDEX IX_Customer_MatchAttributes_001 ON [mdm].' Set @SQL= @SQL + '['+  @S +'] (' Select @SQL = @SQL + '['

Hi All I have listed out some of the differences between azure SQL Database and SQL server Databases. you need to select any one of the 2 based on the features you want in your project , in our project we are handling with PII data where we need Transparent Data encryption which is not available in Azure SQL Database so we went for SQL server databases .   SQL Server Database Azure SQL Database services Category       Size Limitations SQL server can grow upto 524,272 Terabytes 1 to 5 GB for web edition   and    10 to 150GB   for business edition       Connecion Limitations   Tcp/ip   , sharedmemory , and Named Pipes client protocols Only one TCP/IP   Windows authentication No windows authentication   only through username and password   Communication through static/Dyanic port only through 1433 port Unsupported Features In SQL database   Agent Service       Audit     Backup/Restore     Change data Capture     Compression     Database Object naming Con