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

764 Answers

Votes Activity Newest
2
sys.dm_tran_version_store_space_usage reports always zero space used
17 hours ago
4
How to optimize and estimate DB recovery times?
17 hours ago
1
SQL - Emptying Secondary Data File
yesterday
0
MSSQL Logon Error in /var/opt/mssql/log/errorlog
yesterday
0
Allow user to create databases on server and to see only the databases that are created by him, without creating login first
yesterday
7
varchar(255) or varchar(256)?
Aug 11 '17 at 17:34
1
What is the best desing for configuration tables with simple FK?
Jan 18 at 15:47
1
Will large transaction log file slow db recovery?
Jan 17 at 0:35
4
Multiple disks vs single disk on virtualized environment
Jan 14 at 16:42
2
Do I need a domain controller for multiple PCs accessing the same SQL server db? How do I configure it?
Jan 14 at 16:35
46
What does the GO statement do in SQL Server?
Jan 11 at 22:51
0
What Account should SQL service use?
Jan 11 at 22:26
2
What is the correct and performant pattern for loading (and querying) a large clustered columnstore table?
Jan 10 at 16:44
5
SQL Server 2019 column store indexes - maintenance
Jan 9 at 16:53
2
An expression for non-boolean type specified in a context where a condition is expected, near 'order'
Jan 6 at 14:12
3
How to reduce fragmentation of nonclustered index on date partitioned log table
Jan 5 at 3:04
2
How To Detect locking due to multi row updates
Jan 4 at 23:36
3
Trying to understand an RCSI example-The Potential Dangers of the Read Committed Snapshot Isolation Level
Jan 3 at 22:38
6
Import local data to remote server for SQL Server
Jan 2 at 17:02
7
Remote Scan when updating using functions
Jan 1 at 16:29
0
Database T-Log is full due to 'Active_transaction'. SQL server is using new T-log file first rather than old
Jan 1 at 16:35
3
DBCC CloneDatabase - sys.partitions rows value wrong
Dec 31 '20 at 0:13
1
Update via C# EF Core or SQL
Dec 30 '20 at 14:04
7
Updating an indexed view with NOEXPAND
Dec 28 '20 at 23:26
7
Why Does the SQL Server Query Optimizer Not Convert an OUTER JOIN to an INNER JOIN When a Trusted Foreign Key Is Present?
Dec 22 '20 at 23:47
0
Non-yielding issue on SQL Server
Dec 22 '20 at 22:47
0
behavior of a Sql Server availability group listener and a jdbc client during a failover?
Dec 22 '20 at 17:56
6
Index and statistics optimization scripts duration and log bloat problem. Looking for good strategy?
Dec 18 '20 at 15:00
4
Using a filtered index when setting a variable
Dec 18 '20 at 14:56
15
Safe to use WITH (NOLOCK) in this case?
Dec 14 '20 at 22:10
1
2 3 4 5
…
26