Skip to main content
Database Administrators

Popular Question

 Popular Question
Question with 1,000 views. This badge can be awarded multiple times.

earned this badge 23 times.
Prepared statements with many parameters is slow
Awarded Jul 18 at 20:25
Server audit with more than 1.000 entries
Awarded Aug 14, 2023 at 17:34
Optimizing single-row DELETEs from a table with many FOREIGN KEY references
Awarded Feb 24, 2023 at 19:48
Indexed views on double linked server
Awarded Jul 8, 2022 at 8:57
Logging errors with extended events excluding some users
Awarded Sep 1, 2021 at 5:18
UPDATE, subquery with SELECT TOP
Awarded Oct 22, 2020 at 21:45
SQL Server 2016: Adding temporal tables to existing application
Awarded Jun 19, 2020 at 18:21
Investigating errors from strange query
Awarded Apr 10, 2020 at 2:40
Just update one column, trigger updates another
Awarded Dec 17, 2019 at 10:50
Effective dates, complex requirements
Awarded Sep 30, 2019 at 13:15
Reuse a complex non-deterministic expression in SELECT and WHERE clauses
Awarded Jun 5, 2019 at 17:00
SQL Server: performance of IDENTITY vs INT as primary key
Awarded Nov 5, 2018 at 11:05
SQL Server: insert french characters without using them in a query
Awarded Apr 12, 2018 at 8:47
Why does dropping foreign keys take long?
Awarded Dec 14, 2017 at 18:47
Log all than queries taking more than X seconds
Awarded Nov 24, 2017 at 1:41
Remote linked servers
Awarded Jun 14, 2016 at 17:35
Restoring a database, changing recovery model
Awarded Jan 25, 2016 at 18:10
Identify applications with locks
Awarded Jun 1, 2015 at 16:53
Scripting a maintenance plan
Awarded Mar 16, 2015 at 15:30
Reducing database size to restore to SQL Server Express
Awarded Dec 11, 2014 at 13:19
Log all errors in queries
Awarded Oct 22, 2014 at 15:17
SQL Server : keep track of all connections/disconnections
Awarded Aug 19, 2014 at 20:02
Give permission to select from system tables
Awarded Oct 31, 2013 at 20:45

Others with this badge