The Stack Overflow podcast is back! Listen to an interview with our new CEO.
Database Administrators
David Browne - Microsoft
Meta user
Network profile
Summary Answers Questions Tags Badges Favorites Bounties Reputation All actions

438 Answers

Newest Activity Votes
3
Restore plan cache and buffer pool after database restore?
yesterday
1
Without rewriting this query, is there a way to force the query optimizer to better estimate the amount of resources required, e.g. with query hints?
2 days ago
5
Permissions using a TYPE as a Table Valued Parameter
Oct 18 at 16:33
2
Indexing Strategy for the query performance
Oct 16 at 20:11
1
SQL server 2016/2017 in terms of better performance
Oct 14 at 13:38
4
Why selecting rowversion using outer join never returns null
Oct 10 at 23:42
3
Database Consistency History fails in SQL Server 2017 Express
Oct 12 at 21:10
5
Understanding when to remove Order By or Sort operator from Query/plan
Oct 9 at 1:01
0
Tail log backup or use log backup after putting DB into single user mode?
Oct 8 at 13:44
1
SQL Server secondary replica snapshot with Basic Availability Group
Oct 7 at 15:10
4
Does an excessive table violate normalization rules?
Oct 7 at 0:02
0
Solutions for Introducing a new Entity In Between An Existing Association
Oct 5 at 21:38
0
Count up numbers from a specific column
Oct 5 at 21:28
3
Does loading data to temp table improve performance?
Oct 3 at 14:44
7
How do I grant a SELECT permission to an individual user who's part of a large group that is explicitly denied?
Oct 1 at 20:04
2
Authentication failed when deploy an Analysis Services project
Oct 1 at 19:11
5
Can default object names be changed?
Oct 1 at 14:01
3
DNS Alias for SQL Instance - LOTS of Instances - All going to default instance
Sep 30 at 18:55
3
Most efficient way to cancel or avoid select in union query?
Sep 26 at 1:27
4
SQL Server - global temporary table vs normal table
Sep 16 at 14:22
3
Extending fiat transaction log to support cryptocurrency
Sep 16 at 16:15
3
T-SQL Stored Procedure Returns Before Completing
Sep 14 at 19:35
5
Lots of short term blockings on SQL Server 2008-R2 database
Jan 26 '18 at 5:55
3
Why is my auto-restore procedure not dropping the databases when I expect it to?
Sep 12 at 19:04
4
Constrain unique value between multiple tables
Sep 11 at 18:53
5
What is the purpose of “Schema Owner”?
Sep 10 at 21:29
4
indexes are not created on localdb
Sep 7 at 13:22
3
Is there a way to check connection properties of an active SQL Server connection?
Sep 6 at 22:02
2
SQL Server on Windows Server (VMware) - online storage swap
Sep 4 at 13:31
7
Can lowering fill factor result in more page splits?
Aug 26 at 16:51
1 2 3 4 5 … 15