There were couple of occasions of late where people asked me way to display total rows along with detailed data while applying crosstabbing using PIVOT. Though this can be very easily generated in front end languages especially when you’re using…
Retrieve the status of SQL Server services programatically
One of the cool features that’s got introduced from SQL 2008 R2 is ability of getting the running status of various SQL Server services like SQL Server, Full-Text, and SQL Server Agent by means of T-SQL query. This is made possible…