Indexes play vital role for performance tuning on database systems. When you adjust correct indexes on tables, queries can run faster. Otherwise, a proper index can improve the performance and a bad index can hamper the performance. You can find missing indexes with below query. But, result of the query do not mean that you…
Category: SQL
Create Schedule Job For Execute Procedure in SQL Server 2008
If you want to run procedure or any query as scheduling, you can use job in SQL Server Database. For this process, you can use below operations. Right Click On SQL Server Agent > New > Job