.NETADO.NETAgileAngularArchitectureASP.NETAuthenticationAzureAzure FunctionBIBig DataBlazorBusinessC#Cloud ServiceCosmosDBCSSDebuggingDesignEncryptionEntity FrameworkFYIGoogleHardwareInternetInterviewsJavascriptjQueryLeadershipLINQManagementMicrosoftMobileMS OfficeMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSSyncfusionTeamTestingTSQLUncategorizedVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress
#temp tables are available ONLY to the session that created it and are dropped when the session is closed. ##temp tables (global) are available to ALL sessions, but are still dropped when the session that created it is closed and all other references to them are closed. Local temporary tables are visible only in the... » read more
How do I Ctrl Alt Delete in Remote Desktop? CTRL + ALT + END Now on your host machine (A), press and hold the CTRL and ALT keys on your physical keyboard and then press the DEL key on the on-screen keyboard. That’s one way to do it. You can also open the on-screen keyboard on computer B and then type CTRL + ALT + END, which... » read more
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
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) Note: There is also a timeout in the Availability Group setup... » read more
Microsoft SQL Server Management Studio (SSMS) -> Server -> Always On Hight Availability -> Properties Session Timeout (seconds) field Note: Default to 20 seconds. The timeout setting in Windows Failover Cluster will override setting in the AlwaysOn Availability Group setting.
Setup: Windows Failover Cluster Manager (Windows) SQL Server AlwaysOn High Availability (SQL Server) The two different applications goes hand in hand. Note: Failover Cluster Manager (Windows) override AlwaysOn High Availability (SQL Server). Timeout setup in both Failover Cluster Manager and Always On High Availability.
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
Decimal Hexadecimal 0 0 1 1 2 2 3 3 4 4 5 5 6 6 7 7 8 8 9 9 10 A 11 B 12 C 13 D 14 E 15 F