Clement
  • Member for 7 years, 6 months
  • Last seen more than a month ago
  • Sydney, Australia
3 answers
6 votes
550 views
1 bookmarks
Online Index Rebuild of large table takes exclusive lock
1 answers
5 votes
2k views
2 bookmarks
Export sql azure DB as bacpac file without including data for certain tables
1 answers
5 votes
1k views
Why are U locks required when using Read Committed Snapshot Isolation
2 answers
4 votes
26k views
1 bookmarks
SQL query to get monthly sales per product, including products with no sales
2 answers
4 votes
280 views
Columnstore index on multi-tenant database
4 answers
3 votes
595 views
3 bookmarks
SQL query for FIFO allocation of items
1 answers
3 votes
149 views
What are some databases that are schema-full but not relational
1 answers
2 votes
44 views
Cost of replaying transaction log on sql server HA replica
1 answers
2 votes
4k views
Get sql azure dead lock info
1 answers
1 votes
61 views
Isolation level with SQL Server and Azure Sql Database Read-Only replica
1 answers
1 votes
483 views
Sql server/azure connection string parameter for readonly access?
1 answers
1 votes
217 views
Why can members of db_datareader SELECT sys views
1 answers
1 votes
213 views
1 bookmarks
SQL query with GROUPING SETS to get subtotals with a HAVING clause
0 answers
1 votes
75 views
Spin up an extra sql azure instance to reorganize/rebuild indexes with no downtime
0 answers
1 votes
110 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 answers
0 votes
40 views
How to determine if an ALTER statement will be a metadata-only operation O(1) or a size of data operation O(n)?
2 answers
-1 votes
103 views
SQL query with GROUPING SETS to get subtotals with a HAVING clause (non additive measure)