Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL Toast

I have been working as a SQL Administrator for more than 5 years and it has been an enriching and exciting experience. I want to contribute back to the community which has given me a lot over the years.

Send SMS from SQL Server

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

0 comments, 244 reads

Posted in SQL Toast on 31 March 2014

Merge outputs of perfmon and profiler to get a great view

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

6 comments, 2,086 reads

Posted in SQL Toast on 9 October 2013

SQL Server Statistics

INTRODUCTION

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

5 comments, 529 reads

Posted in SQL Toast on 29 September 2013