Database Hash Warning

A hash warning event means that part of the data processed for a hash operation was written to tempdb. This means that a hash join or hash aggregate has run out of memory and been forced to spill information to disk (tempdb) during query execution, which can degrade the SQL Server performance. While spills are something... » read more

FULL OUTER JOIN

https://www.w3schools.com/sql/sql_join_full.asp The FULL OUTER JOIN keyword returns all matching records from both tables whether the other table matches or not. So, if there are rows in “Customers” that do not have matches in “Orders”, or if there are rows in “Orders” that do not have matches in “Customers”, those rows will be listed as well.

Making Always On More Reliable

Increasing the Failover Maximum failures in a specified period will enhance the cluster service for making more attempts in keeping the role up and working. You can increase Maximum failures in a specified time period to 5 or more. Default is 2 in 6 hours. Failover Cluster Manager -> Roles -> click on resource ->... » read more

No Global Profile Is Configured

Error: No Global Profile Is Configured Resolution: 1.  Open database mail configuration by logging into SQL Server Management studio and expanding Management and right clicking on DatabaseMail, then choosing configure: 2.  Choose Manage Profile Security. 3.  Configure your profile to be the default profile: There’s no need to restart anything, your maintenance plan should now send... » read more

How can I tell what version of SQL Server that I have?

Example: -1253826760 = Desktop -1592396055 = Express -1534726760 = Standard 1333529388 = Workgroup 1804890536 = Enterprise -323382091 = Personal -2117995310 = Developer 610778273 = Enterprise Evaluation 1044790755 = Windows Embedded SQL 4161255391 = Express with Advanced Services

Login failed due to trigger execution

Error: Login failed for login <Login Name> due to trigger execution. Changed database context to ‘master’. Changed language setting to us_english. (Microsoft SQL Server, Error: 17892) Resolution: Search for the trigger via: If you see a server level trigger that might be responsible for the login issues, then you can drop it with: Instead of... » read more

Temporal System-Versioned Table

Temporal tables (also known as system-versioned temporal tables) are a database feature that brings built-in support for providing information about data stored in the table at any point in time, rather than only the data that is correct at the current moment in time. Example: Employee (System-Versioned) Sources: https://docs.microsoft.com/en-us/sql/relational-databases/tables/temporal-tables?view=sql-server-ver15

Generate Logs for Microsoft Support Troubleshooting for AlwaysOn

Please open the below link https://aka.ms/getTSS 2. Copy the zip file to the Server 3. Unzip the contents of tss_tools.zip to a folder 4. Open PowerShell as Administrator 5. Change to the directory where the files were extracted 6. Run the following command: .\get-psSDP.ps1 Cluster In case if this command does not work please try .\tss... » read more

Unable to access availability database ‘xxxxxxx’ because the database replica is not in the PRIMARY or SECONDARY role.

Error: Cluster Log: Cluster resource ‘xxxxxx’ of type ‘SQL Server Availability Group’ in clustered role ‘xxxx’ failed. Based on the failure policies for the resource and role, the cluster service may try to bring the resource online on this node or move the group to another node of the cluster and then restart it.  Check... » read more