Randi Vertongen's user avatar
Randi Vertongen's user avatar
Randi Vertongen's user avatar
Randi Vertongen
  • Member for 6 years
  • Last seen more than a month ago
  • Belgium
41 votes
Accepted

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

26 votes
Accepted

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

19 votes

Select * from View takes 4 minutes

16 votes
Accepted

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

14 votes

What is DBCC SHRINKFILE actually doing?

12 votes
Accepted

Missing Non Clustered Index already part of Clustered Index

12 votes
Accepted

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

12 votes
Accepted

SQL server backup message

11 votes
Accepted

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

11 votes
Accepted

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

11 votes
Accepted

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

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?

11 votes
Accepted

Prevent SSMS from seeing the server's file system

10 votes
Accepted

Deadlock Graph and Interpretation, solution to avoid

10 votes
Accepted

Does LocalDB support temporary tables?

10 votes
Accepted

Query store audit

10 votes

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

10 votes
Accepted

How SQL Server caches data in memory

10 votes
Accepted

How the first IAM page is found by SQL Server

9 votes

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

9 votes

SQL Server database level roles for creating tables

9 votes
Accepted

Incorrect syntax near '+' in stored procedure sql server

9 votes
Accepted

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

9 votes

How to find out which object is taking space?

9 votes
Accepted

Compatibility level of SQL Server

9 votes
Accepted

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

9 votes
Accepted

SQL Server query scanning more partitions than expected

8 votes
Accepted

How to split XML array into separate rows (while upholding consistency)

8 votes

How to get the last not-null value in an ordered column of a huge table?

8 votes
Accepted

Indexes with the same object_id but different names

1
2 3 4 5
13