Clement's user avatar
Clement's user avatar
Clement's user avatar
Clement
  • Member for 9 years, 7 months
  • Last seen this week
  • Sydney, Australia
9 votes
3 answers
2k views

Online Index Rebuild of large table takes exclusive lock

5 votes
1 answer
1k views

Why are U locks required when using Read Committed Snapshot Isolation

5 votes
1 answer
3k views

Export sql azure DB as bacpac file without including data for certain tables

4 votes
2 answers
32k views

SQL query to get monthly sales per product, including products with no sales

4 votes
2 answers
443 views

Columnstore index on multi-tenant database

3 votes
1 answer
185 views

What are some databases that are schema-full but not relational

3 votes
4 answers
2k views

SQL query for FIFO allocation of items

2 votes
1 answer
1k views

Sql server/azure connection string parameter for readonly access?

2 votes
1 answer
5k views

Get sql azure dead lock info

2 votes
1 answer
47 views

Cost of replaying transaction log on sql server HA replica

1 vote
0 answers
315 views

Can I run an index rebuild on a sql server HA replica or a copy the DB, and then swap with the primary?

1 vote
0 answers
106 views

Spin up an extra sql azure instance to reorganize/rebuild indexes with no downtime

1 vote
1 answer
467 views

SQL query with GROUPING SETS to get subtotals with a HAVING clause

1 vote
1 answer
649 views

Why can members of db_datareader SELECT sys views

1 vote
1 answer
379 views

Isolation level with SQL Server and Azure Sql Database Read-Only replica

1 vote
0 answers
203 views

In SQL server, why is N'🙂' equal to N''?

0 votes
1 answer
377 views

How to determine if an ALTER statement will be a metadata-only operation O(1) or a size of data operation O(n)?

-1 votes
2 answers
134 views

SQL query with GROUPING SETS to get subtotals with a HAVING clause (non additive measure)