Skip to main content
olle's user avatar
olle's user avatar
olle's user avatar
olle
  • Member for 13 years, 5 months
  • Last seen more than 5 years ago
24 votes
3 answers
16k views

Find out what queries are causing the biggest amount of network traffic

12 votes
1 answer
3k views

What is the impact of changing the index creation memory setting in SQL Server?

11 votes
2 answers
6k views

How to prevent daily index fragmentation of 99%

10 votes
2 answers
7k views

What is the meaning of DOP in the context of SQL Server?

10 votes
1 answer
28k views

How can I monitor the call count per stored procedure per timespan?

5 votes
1 answer
11k views

How to remove xmlns from child elements with FOR XML

5 votes
3 answers
401 views

What affects the speed of a count(*) besides the number of records

4 votes
5 answers
3k views

Pros and cons of having one table per entity vs. having a shared table with an extra column indicating the entity type

3 votes
1 answer
3k views

sp_whoisactive keeps returning create procedure statements

2 votes
1 answer
2k views

How to prevent big performance impact during index creation

2 votes
2 answers
263 views

Why doesn't time for a simple update scale linearly with the number of records?

1 vote
2 answers
862 views

What are the disadvantage/consequences of moving updated column to separate table to prevent table lock on the original table?

1 vote
1 answer
785 views

How to insert and or update a variable number of records and prevent concurrency issues

1 vote
4 answers
3k views

Update column of a large set of records with a calculated value