Tag Archives: SQL Server

Upgrade SQL Server 2016 to Service Pack 1 faced with Exit code (Decimal): -2068380094

I wanted to upgrade the SQL Server 2016 installed on my laptop to service pack 1 last night. But the setup failed with this error:   Final result:                  The patch installer has failed to update the shared features. To determine … Continue reading

Posted in Database Administration, SQL General Information | Tagged , , , ,

Event ID 129 Reset to device, \Device\RaidPort0, was issued on Database Server

Two months ago, one of my clients called me that his DB Server is not responsive. Their Server is a HP DL580 with this specs: CPU: 4 x 12 cores Memory: 256 GB Storage:  2 x Raid 10 (8 x … Continue reading

Posted in Database Administration, SQL General Information | Tagged , , , , ,

Stored Procedure string parameter accepts default value without quotes

Supposing that we define a parameter with string data type such as NVARCHAR. We can assign a default value for this parameter usually using quotes. So, the following code must encounter an error: CREATE PROC uspStringWithoutQuotes   @Param NVARCHAR(20) = Hello … Continue reading

Posted in T-SQL Tips & Tricks | Tagged , ,