SQL Server Data Import System to Alert For Missed Imports We discovered that one of our import processes hadn't been importing data for over a month. After looking at it, the vendor changed the schedule without notifying us, so since the new data weren't detected, the process was executing without sending a notification. Since we have numerous import processes, how can we set up a system that allows automatic notification if a process doesn't import new data?
Execute Dynamic SQL commands in SQL Server In some applications having hard coded SQL statements is not appealing, because of the dynamic nature of the queries being issued against the database server. Because of this sometimes there is a need to dynamically create a SQL statement on the fly and then run that command. This can be done quite simply from the application perspective where the statement is built on the fly whether you are using ASP.NET, ColdFusion or any other programming la
Step one is to discover where the time is going using standard server traces, code that analyzes the trace, and the new SQL Server Extended Events. Once we know where the time is going we will look at strategies to improve performanc