Database Administrators
Profile Activity
Meta user
Network profile
David Browne - Microsoft
Summary Answers Questions Tags Badges Bookmarks Bounties Reputation All actions

768 Answers

Votes Activity Newest
11
SQL Server - Benefits of splitting databases across different logical drives
Nov 24 '20 at 21:47
2
SQL Server replication methodology
Nov 24 '20 at 16:19
4
Index size is 598GB and database size is 609GB. whether the index contains data?
Nov 24 '20 at 16:13
3
Switching SQL Server service credentials to AD account
Nov 20 '20 at 23:44
2
Databases missing after exporting server and rebuilding master DB
Nov 15 '20 at 17:00
8
OPENXML to get content by using element and attribute name
Nov 14 '20 at 15:04
4
Azure Virtual Machine - local temp storage (D: drive) - how much IOPS it can handle?
Nov 13 '20 at 15:21
2
batch insert causing blocking on other unrelated tables - LCK_M_IS
Nov 12 '20 at 17:39
4
Will SQL Server check FK restrictions between row deletes in a single DELETE statement?
Nov 12 '20 at 15:28
1
Azure Elastic Pool - is it supported for MySQL?
Nov 11 '20 at 21:26
1
Creating external tables from SQL Server using JDBC Drivers
Nov 7 '20 at 15:29
2
Can we configure logins to only connect to read-only replicas in Azure SQL Database automatically?
Nov 4 '20 at 14:22
5
Optimizing concurrent read performance
Nov 3 '20 at 11:49
1
Web server accessing the database server in Always on availability group
Oct 27 '20 at 14:52
2
Two backup programs, diff and log out of sync
Oct 23 '20 at 16:30
2
Do user defined data types always cause implicit conversion to occur when fields of those UDDTs are used as predicates?
Oct 17 '20 at 14:45
0
Data that are sometimes entered and sometimes computed
Oct 6 '20 at 14:12
-1
Structure my database to make search queries fast
Oct 5 '20 at 14:19
1
sql transactional replication - slow renitialization / slow bulk insert
Oct 2 '20 at 17:05
5
Benefits of not having a clustered index on tables (heaps)
Sep 26 '20 at 17:58
3
Pros and Cons of building a relationship model where all table ids are just “_id”?
Sep 26 '20 at 17:50
2
How to List All Permissions for SQL Server Fixed Database and Server Roles
Sep 23 '20 at 21:08
3
User cannot query cross-database, despite having permissions for both databases
Sep 22 '20 at 23:56
2
Is it possible to specify a different collation for the data vs the entities within a single database?
Sep 22 '20 at 23:29
0
SQL Server user and role backup
Sep 21 '20 at 20:34
0
How to reorganize MS SQL Server database
Sep 17 '20 at 14:47
1
Best practices for providing PHI/PII data to users in organization
Sep 15 '20 at 19:23
2
How to run Sql Server stored procedure in Async mode?
Sep 14 '20 at 16:33
0
Database Shrink, Backup, then Restore
Sep 11 '20 at 21:13
1
SQL Server Distributed Transactions: xp_sqljdbc_xa_commit vs xp_sqljdbc_xa_end
Sep 8 '20 at 20:34
1 2
3
4 5
…
26