Database Administrators

Help Center > Badges > Nice Answer

 Nice Answer
Answer score of 10 or more. This badge can be awarded multiple times.
Awarded 5469 times.
In MySQL, does the order of the columns in a WHERE clause affect query performance?
Awarded 23 mins ago
How to solve the error Msg 547, Level 16, State 0, Line 1
Awarded 1 hour ago
Temporarily moving a SQL Server 2016 database to SQL Server 2017 and then moving back. Is it possible?
Awarded 21 hours ago
How to update one table based on another table's values on the fly?
Awarded yesterday
Fast alter column NVARCHAR(4000) to NVARCHAR(260)
Awarded yesterday
MySQL - How to check for a value in all columns
Awarded yesterday
Slow query when having 'contains' and '=' together in where clause
Awarded yesterday
MySQL - How to check for a value in all columns
Awarded 2 days ago
What does [FROM x, y] mean in Postgres?
Awarded 2 days ago
Asked to Not Use Transactions and to Use A Workaround to Simulate One
Awarded 2 days ago
Many columns vs few tables - performance wise
Awarded Sep 14 at 20:30
Is there a way to prevent Scalar UDFs in computed columns from inhibiting parallelism?
Awarded Sep 14 at 11:45
How to select the set of last non-NULL values per column over a group?
Awarded Sep 14 at 0:25
Asked to Not Use Transactions and to Use A Workaround to Simulate One
Awarded Sep 13 at 18:25
Asked to Not Use Transactions and to Use A Workaround to Simulate One
Awarded Sep 13 at 7:50
Efficient query to get greatest value per group from big table
Awarded Sep 12 at 18:10
Availability Group Listener
Awarded Sep 12 at 14:10
Impact of CLUSTER on performance
Awarded Sep 12 at 10:50
Is it possible to PIVOT on a LIKE statement
Awarded Sep 12 at 8:05
PLS-00306 Error: How to find the wrong argument?
Awarded Sep 11 at 22:30
Mysqldump treats some table as View
Awarded Sep 11 at 21:15
Can I update my Microsoft Enterprise SQL Server?
Awarded Sep 11 at 14:00
Resolving port 5500 not free issue during Oracle 12c Release 2 Database Configuration Assistant installation on CentOS
Awarded Sep 11 at 12:10
What are the best practices regarding lookup tables in relational databases?
Awarded Sep 11 at 6:25
How do I determine if a column is defined as a serial data type instead of an integer based off the catalog?
Awarded Sep 11 at 2:00
FORMAT returns large row size and data size
Awarded Sep 10 at 16:45
SQL Server table with 4,000,000 rows is 40GB
Awarded Sep 9 at 21:25
What is hot spotting in the context of adding files to tempdb?
Awarded Sep 9 at 16:25
How can I know what hashing algorithm SQL Server used to decrypt the encrypted data when using the function DECRYPTBYPASSPHRASE?
Awarded Sep 7 at 11:15
SQL Server : which role grants permission to execute all stored procedures?
Awarded Sep 6 at 20:25
Oddities with AT TIME ZONE and UTC offsets
Awarded Sep 6 at 19:35
Notification on long-running query or deadlock in SQL Server 2008 R2?
Awarded Sep 6 at 16:45
How do I generate a tnsnames.ora file to connect to an Oracle Database?
Awarded Sep 5 at 18:25
In the following inventory system, is it possible to force row locks to avoid deadlock and ensure it works as intended?
Awarded Sep 5 at 15:55
How can I take backup of particular tables in SQL Server 2008 using T-SQL Script
Awarded Sep 5 at 13:40
How do I move a PostgreSQL tablespace?
Awarded Sep 5 at 12:55
Concatenate one-to-many field in single result?
Awarded Sep 5 at 12:45
Which costing factors go into the optimizer choosing different types of spools?
Awarded Sep 5 at 8:50
Why doesn’t this recursive CTE with a parameter use an index when it does with a literal?
Awarded Sep 5 at 3:00
Move postgresql database from one server to another
Awarded Sep 4 at 20:55
Queries and updates extremely slow after IndexOptimize
Awarded Sep 4 at 15:25
What is the significance of the trailing dollar sign `$` on identifiers in SQL Server?
Awarded Sep 4 at 12:30
TDE Master Key Rotation
Awarded Sep 4 at 12:30
What is hot spotting in the context of adding files to tempdb?
Awarded Sep 4 at 11:00
What are user connections - when are the created and destroyed?
Awarded Sep 4 at 7:25
Unknown,AppDomain 66 (master.sys[runtime].65) is Marked for Unload Due to Memory Pressure
Awarded Sep 4 at 2:05
Does it ever make sense to have a clustered and non clustered index for the same column
Awarded Sep 3 at 17:55
Deleting millions of records on SQL Server 14.0
Awarded Sep 3 at 17:45
How mongoDB projection affects performance?
Awarded Sep 3 at 17:45
Tempdb Add files require Restart
Awarded Sep 3 at 17:20
What happens when there is no available physical memory left for SQL Server?
Awarded Sep 3 at 16:25
Help with SQL Server Error “ad Hoc access to OLE DB Provider 'Microsoft.ACE.OLEDB.12.0'”
Awarded Sep 3 at 12:50
Database level lock
Awarded Sep 3 at 8:55
How to get all months in a query where one month has no matches?
Awarded Sep 3 at 6:50
Understanding “max_wal_size” and “min_wal_size” parameters default values from postgresql.conf file
Awarded Sep 3 at 6:25
Permission Denied for Foreign Server
Awarded Sep 2 at 12:55
What is a “hashed transaction” in SQL Server Replication terminology?
Awarded Aug 31 at 6:35
Why am I getting an implicit conversion of Int / Smallint to Varchar, and is it really impacting Cardinality Estimates?
Awarded Aug 30 at 22:10
Alternatives to Network Backup
Awarded Aug 30 at 21:10
Lob Logical Read and lob read-ahead reads in NCCI
Awarded Aug 30 at 17:15
1 2 3 4 5 … 92