Charlieface's user avatar
Charlieface's user avatar
Charlieface's user avatar
Charlieface
  • Member for 3 years, 4 months
  • Last seen this week
25 votes
Accepted

Why is my ORDER BY in STRING_AGG not always working?

22 votes
Accepted

Why is an OR statement slower than UNION?

20 votes
Accepted

What is the point of TRY CATCH block when XACT_ABORT is turned ON?

17 votes

Does killing an application kill the SQL connection?

17 votes
Accepted

Are views logically redundant?

16 votes

What does SQL server do with the query output once it is read by the client?

15 votes
Accepted

Is there a reliable way to check if a trigger being fired was the result of a DML action from another *specific* trigger?

11 votes

Multiple Set Quoted_identifier within one script takes the last one?

10 votes
Accepted

How database engine of SQL swap two columns values?

10 votes
Accepted

How to create xml string for each row of table?

9 votes

How to restore transactions after full backup

9 votes
Accepted

SQL Return Table with where clause and occurrences of value of total table

9 votes
Accepted

Index seek to specific multi-column key, then get some rows in lexicographical order

9 votes

How can I eliminate this scalar function or make it faster?

8 votes

How does use of sp_executesql with parameters protect against SQL injection?

8 votes
Accepted

IF statement not being evaluated

7 votes
Accepted

Why does an inequality search on an indexed column give constant scans

7 votes
Accepted

Is there an option or hint possible to improve performance of query with multiple values in the "in" clause

7 votes
Accepted

Trigger execution order after delete

7 votes

SQL Server WHILE loop runs twice with update, once without

7 votes

Indexed columns in SQL Server do not appear to work for basic queries according to execution plan

6 votes
Accepted

Select distinct column values from multiple databases

6 votes
Accepted

Can I restore my SQL Server database to a point before the last full backup with my current backup strategy?

6 votes

How to use application lock in SQL server from two databases

6 votes
Accepted

Does each member of execution plan run in its entirety before the next execution starts?

6 votes

SSMS - SQL Execution Plans

6 votes
Accepted

Constraint for 2 foreign keys to have same secondary column value

6 votes
Accepted

Are individual indexes necessary on columns that are included in a compound primary key?

6 votes

Disable ALL indexes on a table in SQL Server without Warning messages

6 votes
Accepted

Why does SQL Server require a LEFT JOIN to retrieve a status that doesn't exist?

1
2 3 4 5
14