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
8 votes
Accepted

Can I bulk insert into an empty page-compressed table and get full compression?

8 votes

In the following inventory system, is it possible to force row locks to avoid deadlock and ensure it works as intended?

8 votes
Accepted

Patching SQL Server 2014 Versus SQL Server 2014 Express

8 votes
Accepted

Replace long GROUP BY list with a subquery

8 votes

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

8 votes
Accepted

Table Fragmentation

8 votes
Accepted

Indexes with the same object_id but different names

8 votes
Accepted

Very similar queries, vastly different performance

8 votes
Accepted

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

7 votes
Accepted

Adding COMPRESSION_DELAY to an existing COLUMNSTORE INDEX

7 votes
Accepted

Unfamiliar syntax - Query with Parameters in Braces at the beggining

7 votes
Accepted

How to remove the red squiggly line from IntelliSense for the newly created table or procedure without restarting the SSMS

7 votes

Forcing execution plan with local join hints

7 votes
Accepted

Sql Server delete syntax

7 votes
Accepted

Cursor Replacement for Newbies

7 votes

Xml index, slow count of rows

7 votes
Accepted

IndexOptimize - Configuration

6 votes
Accepted

Finding Missing Inverse Relationships

6 votes

What exactly triggers the UPDATE of the column is_media_read_only on sys.database_files?

6 votes

Creating an Index that is not used by a (SELECT) query reduces performance of that query

6 votes
Accepted

remove leading and trailing quotes

6 votes
Accepted

Why the job's next_run_time is wrong?

6 votes
Accepted

Does increasing the tempdb file size require a restart

6 votes
Accepted

SQL Server Index and Statistics Maintenance performance question

6 votes
Accepted

OPTIMIZE FOR variable error

6 votes
Accepted

Available space differs between sys.database_files and database properties dialog in SQL Server Management Studio

6 votes
Accepted

tuning huge delete operation on sql server table

6 votes
Accepted

Why would writing the CTE to an actual table provide a performance improvement?

6 votes
Accepted

Do varchar(max), nvarchar(max) and varbinary(max) columns affect select queries?

6 votes
Accepted

SQL Server job stuck even after restart

1
2
3 4 5
13