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

Extend Timeout on Windows Failover Cluster Manager

Windows -> Server Manager -> Tools -> Failover Cluster Manager -> Roles -> Select Role -> Other Resources -> Select Resources -> Properties -> Properties tab “Lease Timeout” field – default to 20000 (20 seconds) “HealthCheck Timeout” field – default to 30000 (30 seconds)

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

Binary Numbers

Decimal Binary 0 0000 1 0001 2 0010 3 0011 4 0100 5 0101 6 0110 7 0111 8 1000 9 1001 10 1010 11 1011 12 1100 13 1101 14 1110 15 1111

SQL Bitwise Operators

Bitwise Operators X Y X&Y X|Y X^Y ~X 0 0 0 0 0 1 0 1 0 1 1 1 1 0 0 1 1 0 1 1 1 1 0 0 See the following topics: & (Bitwise AND) &= (Bitwise AND Assignment) | (Bitwise OR) |= (Bitwise OR Assignment) ^ (Bitwise Exclusive OR) ^=... » read more