user avatar
user avatar
user avatar
Clement
  • Member for 7 years, 10 months
  • Last seen more than a week ago
  • Sydney, Australia
6 votes
3 answers
610 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
27k views

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

4 votes
2 answers
308 views

Columnstore index on multi-tenant database

3 votes
1 answer
152 views

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

3 votes
4 answers
720 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
125 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
77 views

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

1 vote
1 answer
228 views

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

1 vote
1 answer
92 views

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

1 vote
1 answer
262 views

Why can members of db_datareader SELECT sys views

1 vote
1 answer
565 views

Sql server/azure connection string parameter for readonly access?

0 votes
1 answer
55 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
111 views

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