We have configured email alerts in our environment. Recently I had requirement of sending SMS for critical alerts on production server. Though this is NOT a feature of SQL Server, but we have a simple workaround for this.
Cell phone service providers have a SMS gateway. These gateways accept requests… Read more
There is a way by which we can merge the .trc and .blg files to get a great view as below :
We have SQL Server Profiler event data in the top pane and PerfMon data in the middle. Data from both PerfMon and Profiler is correlated. If you click… Read more
Statistics contain information about the data. How the data is distributed inside the table. They are representation of a table. They represent the table in the sense that optimizer refers to the statistics to generate a plan rather than scanning the whole table for plan generation. These stats are… Read more