Skip to main content
Share Your Experience: Take the 2024 Developer Survey
Thomas Kejser's user avatar
Thomas Kejser's user avatar
Thomas Kejser's user avatar
Thomas Kejser
  • Member for 11 years, 11 months
  • Last seen more than a month ago
0 votes

How to speedup pg_dump big database

147 votes

SQL server databases stuck in restoring state

13 votes

Indexing a PK GUID in SQL Server 2012

16 votes

Why shouldn't we allow NULLs?

2 votes

Using timestamp plus integer as primary key

12 votes

Change Data Types large Live table

5 votes
Accepted

UPDATE a column by COUNT of another table

5 votes
Accepted

Shrinking old partitions

3 votes

Database-agnostic stored procedure call passing array of name/value pairs

1 vote

Modifying a non managed table partition

4 votes
Accepted

Is a clustered index on a child table in a parent/child relationship the most optimal index?

0 votes

Connecting SQL Server 2008 R2 to SQL Server 2000

4 votes

Should I enable db_writer in public facing website

3 votes

Counting SQL Server Transactions

1 vote

Best Indexing Strategy for Query with Equality[A], Range[B], Group By[C], AND Order By[count(P)]

4 votes
Accepted

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

2 votes
Accepted

Query on 250 million records

4 votes
Accepted

Confused about sys.dm_io_virtual_file_stats num_of_reads/writes column

18 votes

OLAP or OLATP - How to determine

4 votes

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

7 votes
Accepted

Why do/should DBMS cache at the application layer?

1 vote
Accepted

How to determine efficacy of index on child side of foreign key

10 votes

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

12 votes

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

2 votes

Best way to document Dwh views

5 votes
Accepted

Are CTEs multithreaded?

1 vote
Accepted

DB Design storing products sold in bulk, priced by vastly different units

0 votes

choose Username or ID as primary key?

6 votes
Accepted

SET DATEFORMAT problems

2 votes

SQL Server 2012 Table Partitioning - Have I done it correctly?