As of May 31, 2023, we have updated our Code of Conduct.
Database Administrators
Clement's user avatar
Clement's user avatar
Clement's user avatar
Clement
  • Member for 8 years, 10 months
  • Last seen this week
  • 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
390 views

Columnstore index on multi-tenant database

3 votes
1 answer
179 views

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

3 votes
4 answers
1k views

SQL query for FIFO allocation of items

2 votes
1 answer
878 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
242 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
90 views

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

1 vote
1 answer
358 views

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

1 vote
1 answer
417 views

Why can members of db_datareader SELECT sys views

1 vote
1 answer
289 views

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

1 vote
0 answers
80 views

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

0 votes
1 answer
226 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
123 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.