Database Administrators
Clement's user avatar
Clement's user avatar
Clement's user avatar
Clement
  • Member for 9 years, 2 months
  • Last seen more than a month ago
  • Sydney, Australia
Profile Activity

18 Questions

Score Activity Newest Views
6 votes
3 answers
1k 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
31k views

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

4 votes
2 answers
422 views

Columnstore index on multi-tenant database

3 votes
1 answer
181 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
996 views

Sql server/azure connection string parameter for readonly access?

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
280 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
100 views

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

1 vote
1 answer
409 views

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

1 vote
1 answer
517 views

Why can members of db_datareader SELECT sys views

1 vote
1 answer
339 views

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

1 vote
0 answers
130 views

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

0 votes
1 answer
297 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
128 views

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

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.