How to get column names in the row wise along with their values

Very odd behavior with parameter sniffing, overall poor performance post CU19

Hey all, Seeing something very strange. Overall performance on a SQL 2017 instance has dramatically…

AD group access - persists after removed?

I have a strange problem regarding an Active Directory group that has access to a database. We have…

Memory Pressure alleviate with proper indexing ?

Dear friends: SQL Server physical machine, critical services, overloaded with several requests, som…

Windows update on Virtual SQL Server 2016.

We have a Virtual Server with Windows Server 2012 & SQL 2016 installed on it. When we restart t…

Export dtx package but doesnt work on SQL Agent

Hello, So I am trying to get this simple SSIS package to work on SSISDB, it has 1 variable called S…

Self join / row_number() partition number generation based multiple status

Thanks in Advance:) Whenever there is a change in Status or Comment for name_id then we need to con…

Representing uncertainty in difficult times

Comments posted to this topic are about the item Representing uncertainty in difficult times Best w…

Update duplicate values to 0

Hi, I need some help in my query. Want to change numbers to 0 if the row is a duplicate records bas…

Installing Ubuntu in Level 1 of the Stairway to SQL Server on Linux

Comments posted to this topic are about the item Installing Ubuntu in Level 1 of the Stairway to SQ…

FTI Query over Joined tables is slow

Hi I have a table with a full text index. I have a query which uses CONTAINS to search the table. T…

T-SQL Self Referencing Join

Hi All, I am trying to do a self referencing cross join, i think not sure what else to call it from…

Postgresql JDBC Tutorial on Linux

Comments posted to this topic are about the item Postgresql JDBC Tutorial on Linux

SSIS - Connection Problem when outputting to an Excel Binary Workfile (.xlsb)

Hello All, I'm just about trearing my hair out with a Connection problem when I'm writing to an Exc…

Error al Importar una tabla con el (SQL Server Import and Export Wizard)

Hola a todos, mi nombre es james sabogal , soy nuevo en sql-server, pues en mi empresa trabajamos c…