Thomas Kejser's user avatar
Thomas Kejser's user avatar
Thomas Kejser's user avatar
Thomas Kejser
  • Member for 11 years, 10 months
  • Last seen more than a week ago
147 votes

SQL server databases stuck in restoring state

20 votes
Accepted

How to efficiently check EXISTS on multiple columns?

18 votes

OLAP or OLATP - How to determine

15 votes

Why shouldn't we allow NULLs?

15 votes

How do I shrink all files quickly for all databases?

13 votes

Indexing a PK GUID in SQL Server 2012

12 votes

Change Data Types large Live table

12 votes

Can rebuilding indexes cause worse performance after the rebuild is finished?

11 votes
Accepted

Running parallel delete statements

10 votes

At What Point Should I Split or Partition a Very Large but Simple Table

9 votes
Accepted

What are the possible causes for sp_reset_connection taking a long time to execute?

8 votes

Why do sequential GUID keys perform faster than sequential INT keys in my test case?

8 votes
Accepted

What is the effect of replacing indexes with filtered (non-null value) indexes?

7 votes
Accepted

What is the best way to store a lot of user-encrypted data?

7 votes

How to remove a table partition

7 votes
Accepted

Why do/should DBMS cache at the application layer?

6 votes
Accepted

SET DATEFORMAT problems

6 votes

Does tempDB disk perf matter if you have plenty of unused memory?

5 votes
Accepted

Can you put a SQL DB on a NAS?

5 votes

Replace relational database with "poor" design in software product with non-relational DB?

5 votes
Accepted

Is my understanding of Fact table granularity correct?

5 votes

Ideal values for wait time in SQL server

5 votes
Accepted

UPDATE a column by COUNT of another table

5 votes
Accepted

Any way to reduce sysallocunits contention under a heavy concurrent INSERT workload?

5 votes
Accepted

PAGELOCK Conversion Deadlock From Update to Intent Exclusive

5 votes
Accepted

Shrinking old partitions

5 votes
Accepted

Are CTEs multithreaded?

4 votes

Should I enable db_writer in public facing website

4 votes
Accepted

Reusing covering index for fields in FROM, from another query's index

4 votes

Is there a way to query all error messages in Postgres?