Get Missing Index In database

SELECT TOP 25

dm_mid.database_id AS DatabaseID,

dm_migs.avg_user_impact*(dm_migs.user_seeks+dm_migs.user_scans) Avg_Estimated_Impact,

dm_migs.last_user_seek AS Last_User_Seek,

OBJECT_NAME(dm_mid.OBJECT_ID,dm_mid.database_id) AS [TableName],

'CREATE INDEX [IX_' + OBJECT_NAME(dm_mid.OBJECT_ID,dm_mid.database_id) + '_'

+ REPLACE(REPLACE(REPLACE(ISNULL(dm_mid.equality_columns,''),', ','_'),'[',''),']','')

+ CASE

WHEN dm_mid.equality_columns IS NOT NULL

AND dm_mid.inequality_columns IS NOT NULL THEN '_'

ELSE ''

END

+ REPLACE(REPLACE(REPLACE(ISNULL(dm_mid.inequality_columns,''),', ','_'),'[',''),']','')

+ ']'

+ ' ON ' + dm_mid.statement

+ ' (' + ISNULL (dm_mid.equality_columns,'')

+ CASE WHEN dm_mid.equality_columns IS NOT NULL AND dm_mid.inequality_columns

IS NOT NULL THEN ',' ELSE

'' END

+ ISNULL (dm_mid.inequality_columns, '')

+ ')'

+ ISNULL (' INCLUDE (' + dm_mid.included_columns + ')', '') AS Create_Statement

FROM sys.dm_db_missing_index_groups dm_mig

INNER JOIN sys.dm_db_missing_index_group_stats dm_migs

ON dm_migs.group_handle = dm_mig.index_group_handle

INNER JOIN sys.dm_db_missing_index_details dm_mid

ON dm_mig.index_handle = dm_mid.index_handle

WHERE dm_mid.database_ID = DB_ID()

ORDER BY Avg_Estimated_Impact DESC

GO

Update On inner Join

    select  T.id,T1.IsFinalStatus_FirstLevel,T.IsFinalStatus_SecondLevel,T1.IsFinalStatus_SecondLevel As Change
    from IGRS_Report..tbl_Complaints_CompiledStatus T inner join IGRS_Report..tbl_Complaints_CompiledStatus T1

    On T.ComplaintCode=T1.ComplaintCode and  T1.IsFinalStatus_SecondLevel='ATRS' and T1.IsFinalStatus_FirstLevel <> 'ATRS'
    and T1.ComplaintCode=10159160008930
     and T.id >=T1.id

----------------------Update----------------------------------
     Update
    T set
    T.IsFinalStatus_FirstLevel=T1.IsFinalStatus_SecondLevel
    from IGRS_Report..tbl_Complaints_CompiledStatus T inner join IGRS_Report..tbl_Complaints_CompiledStatus T1

    On T.ComplaintCode=T1.ComplaintCode and  T1.IsFinalStatus_SecondLevel='ATRS' and T1.IsFinalStatus_FirstLevel <> 'ATRS'
    and T1.ComplaintCode=10159160008930
     and T.id >=T1.id

Display Number of Online Users Asp.net- Using Global.asax file

Global .asax file-

1. <%@ Application Language="C#" %>  
2.   
3. <script runat="server">  
4.   
5.     void Application_Start(object sender, EventArgs e)   
6.     {  
7.         // Code that runs on application startup  
8.         Application["TotalOnlineUsers"] = 0;  
9.     }  
10.       
11.     void Application_End(object sender, EventArgs e)   
12.     {  
13.         //  Code that runs on application shutdown  
14.   
15.     }  
16.           
17.     void Application_Error(object sender, EventArgs e)   
18.     {   
19.         // Code that runs when an unhandled error occurs  
20.   
21.     }  
22.   
23.     void Session_Start(object sender, EventArgs e)   
24.     {  
25.         // Code that runs when a new session is started  
26.         Application.Lock();  
27.         Application["TotalOnlineUsers"] = (int)Application["TotalOnlineUsers"] + 1;  
28.         Application.UnLock();  
29.     }  
30.   
31.     void Session_End(object sender, EventArgs e)   
32.     {  
33.         // Code that runs when a session ends.   
34.         // Note: The Session_End event is raised only when the sessionstate mode  
35.         // is set to InProc in the Web.config file. If session mode is set to StateServer   
36.         // or SQLServer, the event is not raised.  
37.         Application.Lock();  
38.         Application["TotalOnlineUsers"] = (int)Application["TotalOnlineUsers"] - 1;  
39.         Application.UnLock();  
40.     }  
41.          
42. </script>

Web config-

1. <system.web>  
2. <sessionState mode="InProc" cookieless="false" timeout="20"></sessionState>  
3. </system.web> 

Default.aspx -

1. <form id="form1" runat="server">  
2.     <div>  
3.     <p>No. of Online Users:<asp:Label ID="Label1" runat="server" Text="Label" ForeColor="#CC0000"></asp:Label></p>  
4.     </div>  
5. </form>  

Default.aspx.cs -

1. protected void Page_Load(object sender, EventArgs e)  
2. {  
3.         Label1.Text = Application["TotalOnlineUsers"].ToString();  
4. }