User Randi Vertongen

41 votes

Accepted

Does SQL Server Only Perform Calculations In A SELECT List Once?

answered Nov 6, 2019 at 14:17

26 votes

Accepted

Do SQL Server compressed indexes remain compressed on rebuild without specifying data compression?

answered Jan 9, 2019 at 13:03

19 votes

Select * from View takes 4 minutes

answered May 29, 2019 at 21:58

16 votes

Accepted

Is it possible for master, tempdb, model and msdb to have a database_id other than 1,2,3,4 respectively?

answered Feb 12, 2020 at 13:01

14 votes

What is DBCC SHRINKFILE actually doing?

answered Apr 4, 2019 at 13:30

12 votes

Accepted

Slow query when having 'contains' and '=' together in where clause

answered Sep 16, 2019 at 8:55

12 votes

Accepted

SQL server backup message

answered Oct 3, 2019 at 10:39

12 votes

Accepted

Missing Non Clustered Index already part of Clustered Index

answered Jan 25, 2019 at 11:06

11 votes

Accepted

Is it possible to take a database offline when doing a backup using an SQL job?

answered Sep 24, 2019 at 9:28

11 votes

Accepted

Prevent SSMS from seeing the server's file system

answered Sep 2, 2019 at 17:15

11 votes

Accepted

logical reads on global temp table, but not on session-level temp table

answered Apr 1, 2019 at 22:20

11 votes

Accepted

Writing a T-SQL stored procedure to receive 4 numbers and insert them into a table

answered Apr 23, 2019 at 13:16

11 votes

Accepted

If sp_ExecuteSql creates a new session, how come I can access a local temp table created (prior to it's execution) outside of the dynamic SQL?

answered Dec 9, 2019 at 16:32

10 votes

Accepted

How the first IAM page is found by SQL Server

answered Feb 18, 2020 at 9:38

10 votes

Accepted

Deadlock Graph and Interpretation, solution to avoid

answered Apr 9, 2019 at 13:14

10 votes

Why doesn’t this recursive CTE with a parameter use an index when it does with a literal?

answered Sep 2, 2019 at 9:27

10 votes

Accepted

Query store audit

answered Sep 10, 2019 at 12:11

10 votes

Accepted

How SQL Server caches data in memory

answered Oct 29, 2019 at 20:41

10 votes

Accepted

Does LocalDB support temporary tables?

answered Jan 10, 2019 at 15:05

9 votes

Why is this faster and is it safe to use? (WHERE first letter is in the alphabet)

answered Jan 18, 2019 at 10:27

9 votes

SQL Server database level roles for creating tables

answered Dec 19, 2018 at 11:31

9 votes

Accepted

Incorrect syntax near '+' in stored procedure sql server

answered Sep 17, 2019 at 11:43

9 votes

Accepted

Performance issue with Top, Order By and Where condition with more than one million rows involved

answered Sep 20, 2019 at 13:08

9 votes

How to find out which object is taking space?

answered Oct 1, 2019 at 8:02

9 votes

Accepted

Database Cache Memory in Performance Monitor drops down significantly after DBCC CheckDB

answered Aug 1, 2019 at 8:28

9 votes

Accepted

SQL Server query scanning more partitions than expected

answered Aug 17, 2019 at 0:31

9 votes

Accepted

Compatibility level of SQL Server

answered Dec 4, 2019 at 10:33

8 votes

Optimize a slow nested loops join

answered Dec 11, 2019 at 7:51

8 votes

Accepted

SQL Server Deadlock between two selects and one update on one table

answered Jan 8, 2020 at 13:28

8 votes

Accepted

Change character limit of SQL Agent Operators

answered Jan 14, 2020 at 11:56

Stack Exchange Network

364 Answers

Does SQL Server Only Perform Calculations In A SELECT List Once?

Do SQL Server compressed indexes remain compressed on rebuild without specifying data compression?

Select * from View takes 4 minutes

Is it possible for master, tempdb, model and msdb to have a database_id other than 1,2,3,4 respectively?

What is DBCC SHRINKFILE actually doing?

Slow query when having 'contains' and '=' together in where clause

SQL server backup message

Missing Non Clustered Index already part of Clustered Index

Is it possible to take a database offline when doing a backup using an SQL job?

Prevent SSMS from seeing the server's file system

logical reads on global temp table, but not on session-level temp table

Writing a T-SQL stored procedure to receive 4 numbers and insert them into a table

If sp_ExecuteSql creates a new session, how come I can access a local temp table created (prior to it's execution) outside of the dynamic SQL?

How the first IAM page is found by SQL Server

Deadlock Graph and Interpretation, solution to avoid

Why doesn’t this recursive CTE with a parameter use an index when it does with a literal?

Query store audit

How SQL Server caches data in memory

Does LocalDB support temporary tables?

Why is this faster and is it safe to use? (WHERE first letter is in the alphabet)

SQL Server database level roles for creating tables

Incorrect syntax near '+' in stored procedure sql server

Performance issue with Top, Order By and Where condition with more than one million rows involved

How to find out which object is taking space?

Database Cache Memory in Performance Monitor drops down significantly after DBCC CheckDB

SQL Server query scanning more partitions than expected

Compatibility level of SQL Server

Optimize a slow nested loops join

SQL Server Deadlock between two selects and one update on one table

Change character limit of SQL Agent Operators