Clement's user avatar
Clement's user avatar
Clement's user avatar
Clement
  • Member for 8 years, 2 months
  • Last seen more than a month ago
  • Sydney, Australia
6 votes
3 answers
703 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
2k views

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

4 votes
2 answers
29k views

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

4 votes
2 answers
341 views

Columnstore index on multi-tenant database

3 votes
1 answer
160 views

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

3 votes
4 answers
910 views

SQL query for FIFO allocation of items

2 votes
1 answer
4k views

Get sql azure dead lock info

2 votes
1 answer
46 views

Cost of replaying transaction log on sql server HA replica

1 vote
0 answers
151 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
81 views

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

1 vote
1 answer
249 views

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

1 vote
1 answer
150 views

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

1 vote
1 answer
310 views

Why can members of db_datareader SELECT sys views

1 vote
1 answer
666 views

Sql server/azure connection string parameter for readonly access?

0 votes
1 answer
89 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
115 views

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