Skip to main content
Database Administrators

Nice Answer

 Nice Answer
Answer score of 10 or more. This badge can be awarded multiple times.
Awarded 7962 times.
Implicit conversion warning despite persisted computed column vs. performance hit from UDF in persisted computed column definition
Awarded Nov 19 at 14:39
Convert a postgres GENERATED column to a regular non-generated column (in place without DROP)
Awarded Nov 15 at 4:51
PostgreSQL ignores index, runs seq scan
Awarded Nov 11 at 9:16
using "\dp table_name" in "psql" throws "operator is not unique"
Awarded Nov 7 at 18:08
STRING_SPLIT - issue with NCHAR(769) and SQL_Latin1_General_CP1_CI_AS
Awarded Nov 5 at 11:31
@@SERVERNAME Consistency in 3 node SQL Availability Group
Awarded Nov 5 at 3:55
Are 'Functional Indexes' Supported in MS SQL Server?
Awarded Nov 3 at 3:03
Is it legal for SQL Server to fill PERSISTED columns with data that does not match the definition?
Awarded Nov 3 at 3:03
Subtracting sum of previous rows' data from current row's data in SQL
Awarded Nov 3 at 3:03
Change SELECT DISTINCT to UPDATE DISTINCT
Awarded Nov 3 at 3:03
Concatenating rows into a single string query running for 5 hrs and counting
Awarded Nov 3 at 2:53
Is it possible to enforce unique values in a column, excluding nulls?
Awarded Nov 3 at 2:47
Setting READ UNCOMMITTED when reading DMVs
Awarded Nov 3 at 2:47
Obtaining the average of three columns per row in SQL
Awarded Nov 3 at 2:38
INSERT performance difference between temporary tables and table variable
Awarded Nov 3 at 0:39
Why does SQL Server convert floats to scientific notation?
Awarded Oct 22 at 12:26
How to release unused space?
Awarded Oct 21 at 12:48
Arbitrarily ordering records in a table
Awarded Oct 19 at 1:53
What is Microsoft SQL Server doing when I manually reduce the file size in Database Properties > Files?
Awarded Oct 17 at 15:50
What does SOS in SQL Server stand for?
Awarded Sep 30 at 15:42
How do I set the option use_remote_estimate?
Awarded Sep 29 at 17:22
PostgreSQL: Auto update updated_at with custom column
Awarded Sep 12 at 14:48
Does changing the length limit (type-modifier) of varchar() result in a table or index rewrite?
Awarded Sep 11 at 16:12
Alter table alter column does not work with user defined types
Awarded Sep 11 at 10:34
Why didn't the transaction fail?
Awarded Sep 10 at 12:52
What is the point of column families?
Awarded Sep 10 at 3:45
Is it better to add conditional logic to a heavily used stored procedure or create a separate one for a new use case?
Awarded Sep 9 at 23:30
When is it safe to disable InnoDB doublewrite buffering?
Awarded Sep 9 at 21:18
Reducing database size to restore to SQL Server Express
Awarded Sep 2 at 14:51
Meaning of '#' suffix on SQL Server columns
Awarded Sep 2 at 9:31
How to control psql displaying rows with (END)?
Awarded Aug 25 at 14:21
How do I find PostgreSQL's data directory?
Awarded Aug 21 at 20:32
Execute Stored Procedure that cannot be manually stopped
Awarded Aug 19 at 10:46
SQL Server - Payroll query kills database every month
Awarded Aug 16 at 14:17
When to use CDC to track history?
Awarded Aug 15 at 14:17
Statistics on temp tables
Awarded Aug 15 at 0:33
On SQL 2022, DECLARE statement causes evaluation of database availability
Awarded Aug 9 at 5:46
CHECK constraint for array column to verify length > 0
Awarded Aug 7 at 15:08
The curious case of HADR_SYNC_COMMIT waits
Awarded Aug 4 at 21:12
FOR XML PATH and OPTION() can't be together in query?
Awarded Aug 2 at 10:00
Unable to Create COMMIT inside PostgreSQL 11.5 Procedure
Awarded Jul 29 at 21:46
How do I do a JOIN in ANSI SQL 89 syntax?
Awarded Jul 21 at 4:01
What does 'b' stand for in PostgreSQL's JSONB data type?
Awarded Jul 20 at 1:22
CROSS JOIN with table that has no row
Awarded Jul 18 at 14:07
PgAdmin 4 - How to connect to database using unix socket via ssh tunnel?
Awarded Jul 18 at 6:27
Clustered index in SQL Server vs index organized tables in Oracle
Awarded Jul 16 at 12:02
Problem with mysqldump and view
Awarded Jul 12 at 0:25
Interpreting SQL Server's Showplan XML
Awarded Jul 1 at 17:42
Passing value of datatype interval in parametrized query
Awarded Jul 1 at 8:21
How do I query this 20 million record view faster?
Awarded Jun 30 at 13:52
What is a "heterogeneous query"?
Awarded Jun 30 at 4:09
Change Data Capture vs trigger for logging changes
Awarded Jun 29 at 3:25
How to avoid using variables in WHERE clause
Awarded Jun 27 at 1:05
What is ERROR_STATE() in SQL Server and how it can be used?
Awarded Jun 27 at 0:57
How MSSQL handle cross database transaction in TRN files?
Awarded Jun 26 at 16:51
Why does my query search datetime not match?
Awarded Jun 25 at 23:36
Anybody using HierarchyId in production? Is it reliable?
Awarded Jun 25 at 23:27
Are there DBMS that allow a Foreign Key that References a View (and not only base tables)?
Awarded Jun 24 at 0:33
How to change table and sequence owner to another user with PostgreSQL?
Awarded Jun 23 at 19:23
Why and how and where to use user without login
Awarded Jun 22 at 16:02
1
2 3 4 5
…
133