Category "sql-server-2014"

Referencing the outer query from the case of a subquery in SQL server 2014

I'm trying to build a stored procedure that transforms a lot of data from a very condensed table with a key to find any given information, to a wide table with

SQL Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding

I am using Microsoft.EntityFrameworkCore.SqlServer 2.2.6. I have a stored procedure which typically takes 1 to 2 seconds to execute. I am using .NET Core 2.2 wi

Checking variable for NULL kills performance

I have following queries: DECLARE @application_number CHAR(8)= '37832904'; SELECT la.LEASE_NUMBER AS lease_number, la.[LEASE_APPLICATION] AS applicatio

SQL Server after update trigger

I have a problem with this trigger. I would like it to update the requested information only to the row in question (the one I just updated) and not the entire

What SQL Error codes should be allowed to retry?

We have a SQL Server 2014 AlwaysOn Availability Group that we connect to via standard C# SqlConnection objects. We want to catch the exceptions that are happeni

cannot drop the view 'XXX' because it does not exist or you do not have permission

We migrated our servers from 2005 to 2014, User is able to delete it in the 2005 server But in 2014 we are getting the error as do not have permission or does n