Database Administrators
Sponsored by
Sponsored logo

Nice Answer

 Nice Answer
Answer score of 10 or more. This badge can be awarded multiple times.
Awarded 6868 times.
Add article to transactional publication without generating new snapshot
Awarded 7 hours ago
How do I find out *why* a user has certain effective permissions?
Awarded 11 hours ago
First Normal Form, why is it good and how does it reduce redundancy
Awarded 16 hours ago
PostgreSQL use NEW in query for INSTEAD OF trigger
Awarded 23 hours ago
1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column
Awarded yesterday
Relating ExecutionInstanceGUID to the SSISDB
Awarded Dec 4 at 3:36
What is the difference between sys and system accounts in Oracle databases?
Awarded Dec 3 at 22:40
"New query window" shortcut for Oracle SQL Developer
Awarded Dec 3 at 18:51
pg_restore certain tables only
Awarded Dec 3 at 18:41
Adding new null column to table caused lock
Awarded Dec 3 at 3:50
Should I split semantically almost identical entities into different tables?
Awarded Dec 2 at 18:27
Breaking a big insert query into smaller ones
Awarded Dec 2 at 16:45
Poor temporal table performance on older values
Awarded Dec 2 at 12:41
Can I get OSQL if I install SQL Server Client Tools?
Awarded Dec 1 at 23:51
"Role does not exist" error when granting usage on public schema, but role does exit
Awarded Dec 1 at 23:05
Show DOMAIN details
Awarded Dec 1 at 10:25
Scripting SQLite with dot commands
Awarded Nov 30 at 20:32
cannot execute as the database principal because the principal does not exist - DB Restoration
Awarded Nov 29 at 23:11
Postgres: Get nextval in sequence without actually incrementing sequence?
Awarded Nov 29 at 11:45
How to make SSMS upper case keywords
Awarded Nov 27 at 15:56
How can I use an environment variable in a Postgres function?
Awarded Nov 26 at 13:04
Is there way to get transaction commit timestamp in Postgres?
Awarded Nov 26 at 9:26
Find which functions are used
Awarded Nov 25 at 21:25
The specified network name is no longer available
Awarded Nov 25 at 9:35
Loop through key/value pairs of a jsonb object in postgresql function
Awarded Nov 25 at 6:56
Strange conditional Syntax in TSQL Query: "<=+" What does it do?
Awarded Nov 23 at 17:06
Can SQL Server use multiple indexes for the same query?
Awarded Nov 23 at 14:25
connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host
Awarded Nov 22 at 18:46
Query time of fetching a particular, single row id by PK is extremely slow
Awarded Nov 21 at 18:20
MariaDB - "ERROR 1205 ... Lock wait timeout exceeded; ..." when doing multiple parallel UPDATEs affecting different rows
Awarded Nov 20 at 10:45
Shrink database operation in maintenance plan failed
Awarded Nov 19 at 18:12
What's the differences between the two version of oracle client download file, "client" and "client home"?
Awarded Nov 19 at 10:28
how will nvarchar(max) store data in database will it be fast if some data is less then 4000 characters?
Awarded Nov 18 at 9:46
Does SQL Server support GREATEST and LEAST, if not what is the common workaround?
Awarded Nov 17 at 23:47
How to get notices to the output stream?
Awarded Nov 17 at 9:55
How to run SQL services on NT SERVICE\MSSQLSERVER account if it is running earlier on LocalSystem
Awarded Nov 16 at 17:20
Are "Always On Failover Cluster Instances" and "SQL Server Failover Clustering" the same thing?
Awarded Nov 16 at 13:06
Understanding where pg_toast is coming from
Awarded Nov 15 at 15:19
Differences between .dump and .sql in pg_dump PostgreSQL
Awarded Nov 14 at 2:26
How can I determine who dropped a DB in SQL Server 2005 (and when)?
Awarded Nov 13 at 6:31
MySQL master binlog corruption
Awarded Nov 12 at 23:49
mysql workbench: ssl is required but the server doesn't support it
Awarded Nov 12 at 20:32
Oracle no privileges on tablespace USERS
Awarded Nov 11 at 19:40
PostgreSQL: changing password for a user is not working
Awarded Nov 11 at 17:57
Best way to get last identity inserted in a table
Awarded Nov 10 at 14:18
Incorrect comparison of datetime and datetime2
Awarded Nov 10 at 11:40
ALTER DATABASE statement not allowed within multi-statement transaction
Awarded Nov 9 at 23:10
How to execute a query from psql without waiting for the result?
Awarded Nov 9 at 19:47
Compacting a sequence in PostgreSQL
Awarded Nov 9 at 17:19
Applying indexes on columns used in join condition
Awarded Nov 9 at 14:26
How to create a unique index with only certain values required to be unique?
Awarded Nov 9 at 9:40
What is the difference between xact_start and query_start in postgresql?
Awarded Nov 9 at 3:37
Sql Server agent can not start
Awarded Nov 8 at 22:07
Joining two tables on multiple criteria
Awarded Nov 8 at 15:17
How to generate a 1, 2, 3, 3, 2, 1, 1, 2, 3, 3, 2, 1, ... series in standard SQL or T-SQL?
Awarded Nov 8 at 13:33
SQL Server - Is my database being queried over linked server?
Awarded Nov 6 at 19:50
How to print to console in SQL?
Awarded Nov 4 at 19:30
SQL Server: How to track progress of CREATE INDEX command?
Awarded Nov 4 at 10:03
SQL Server service - Not Starting With Automatic Startup, "The system cannot find the file specified", but starts fine manually
Awarded Nov 1 at 9:02
How to build a table for a private messaging system that supports replies?
Awarded Oct 31 at 8:09
1
2 3 4 5
…
115

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.