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

468 Answers

Newest Activity Votes
5
SQL Deadlocks - Same Stored Procedure Called Concurrently
16 hours ago
3
Why can't the query processor produce a query plan with a FORCESEEK hint when I'm INNER JOINing by the clustered index on both indexed views?
yesterday
4
What's the best way to concatenate a multi-column foreign key?
yesterday
1
What should I ask my DBA in order to diagnose a slow application?
2 days ago
0
Design question: join data
Dec 10 at 23:51
2
Column values in SQL Server changes to null
Dec 8 at 21:56
2
Does enabling LPIM work even if the memory pressure is coming from SQL Server itself
Dec 6 at 15:59
3
SQL server database Role management - Azure SQL MI
Dec 3 at 18:10
7
Keeping data in old Database (SQL 2008) identical to new Database (SQL 2016)?
Dec 3 at 14:40
2
Why is it considered that a set unnormalizes a database absolutely?
Nov 25 at 2:49
28
What's a good use case for SELECT * in production code?
Nov 22 at 1:31
5
Only return recordset(s) from Stored Procedure if it has rows
Nov 22 at 15:04
1
Capturing Column Names in Dynamic SQL Statement
Nov 20 at 22:54
2
Expired 2016 RC No Backups
Nov 16 at 17:07
0
Firewall security and SQL Server
Nov 16 at 16:37
1
Large Sleep counts causing THREADPOOL wait?
Nov 15 at 15:14
0
SSMS.exe Access Denied
Nov 11 at 15:41
4
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION
Nov 6 at 20:53
3
When are non-parameterized, non-trivial, adhoc query plans reused
Nov 5 at 20:57
13
Is the NOLOCK hint completely safe to use on a table that's guaranteed not to change?
Nov 4 at 18:43
0
Restore from .db folder for Analysis Services
Oct 31 at 23:16
3
Using SQL Server 2017, can log backups be safely taken on primary when using Log Shipping or Availability Groups?
Oct 30 at 13:32
10
Decrypt T-SQL log backup header and read LSN
Oct 30 at 13:19
6
Does assigning variable in SELECT do RBAR operations?
Oct 29 at 16:12
1
Azure SQL Server Trigger Not Firing
Oct 25 at 18:13
3
MSSQL - what is the best isolation level for a website
Oct 24 at 15:12
7
SQL Server trusted connection additional security
Oct 23 at 19:20
3
Solving ON DELETE CASCADE cycles with triggers on MS SQL Server
Oct 23 at 14:58
1
Create table permissions issues with SQL Server
Oct 23 at 9:14
1
Computed Columns - SQL Server Function
Oct 22 at 21:30
1 2 3 4 5 … 16