sp_helptext

The sp_helptext is a system stored procedure that is used to view the text definition of any SQL Server objects that contain code. It can be used for unencrypted user-defined stored procedures, functions, views, triggers, even system objects such as system stored procedures. sp_helptext uspMyProcedureName

Cluster and Failover Setup

Setup: Failover Cluster Manager (Windows) Always On High Availability (SQL Server) Note: Failover Cluster Manager (Windows) override Always On High Availability (SQL Server). Timeout setup in both Failover Cluster Manager and Always On High Availability.

SQL Server Collation

A collation is a configuration setting that determines how the database engine should treat character data at the server, database, or column level. … In SQL Server, you can configure a character column with a Unicode data type (nchar, nvarchar, or ntext) or non-Unicode data type (char, varchar, or text). Collation is a set of rules dictating how... » read more

Microsoft Distributed Transaction Coordinator (MSDTC)

MSDTC is an acronym for Microsoft Distributed Transaction Coordinator. As the name says, MSDTC is a Windows service providing transaction infrastructure for distributed systems. In this case, a transaction means a general way of structuring the interactions between autonomous agents in a distributed system. The Microsoft Distributed Transaction Coordinator service is a component of modern versions of... » read more

Check for SQL Server Mail Profile

Check whether mail profile has been setup on the server. The following will return mail profile that has been setup. The query will return no records if mail profile has not been setup.

sp_updatestats

Runs UPDATE STATISTICS against all user-defined and internal tables in the current database. Updates query optimization statistics on a table or indexed view. By default, the query optimizer already updates statistics as necessary to improve the query plan; in some cases you can improve query performance by using UPDATE STATISTICS or the stored procedure sp_updatestats to update statistics more frequently... » read more

sp_delete_jobsteplog

Removes all SQL Server Agent job step logs that are specified with the arguments. Use this stored procedure to maintain the sysjobstepslogs table in the msdb database.