Database Administrators

Enlightened

 Enlightened
First to answer and accepted with score of 10 or more. This badge can be awarded multiple times.
Awarded 3244 times.
Listing the existing SQL Server Logins and Users
Awarded Aug 7, 2016 at 21:55
Does CREATE TABLE SomeSchema.#TempTableName have a bug?
Awarded Aug 5, 2016 at 12:11
SQL query failing because of commented part of T-SQL query
Awarded Aug 5, 2016 at 9:00
How to set up multiple fields as primary key in MySQL?
Awarded Aug 4, 2016 at 14:31
Troubleshooting high CPU usage from postgres and postmaster services?
Awarded Aug 1, 2016 at 19:15
Suppressing the SSMS prompt to save changes
Awarded Jul 31, 2016 at 21:24
How can I query for existing database snapshots in SQL server?
Awarded Jul 27, 2016 at 13:29
Referencing system views in SSDT?
Awarded Jul 21, 2016 at 15:41
Most efficient way to add a serial column to a huge table
Awarded Jul 21, 2016 at 9:43
How to get rid of "maximum user connections" error?
Awarded Jul 20, 2016 at 9:49
Does any DBMS have a collation that is both case-sensitive and accent-insensitive?
Awarded Jul 20, 2016 at 8:38
mysqladmin not taking inline password
Awarded Jul 20, 2016 at 0:22
What is the special database "postgres" for?
Awarded Jul 19, 2016 at 17:31
Why clustered index scan?
Awarded Jul 19, 2016 at 17:06
select rows having condition met for group (without temporary table)
Awarded Jul 19, 2016 at 5:34
Transform all columns records to lowercase
Awarded Jul 18, 2016 at 19:43
Do SQL Server Express Editions support CLR procedures?
Awarded Jul 18, 2016 at 19:43
How can I monitor the call count per stored procedure per timespan?
Awarded Jul 18, 2016 at 15:25
Difference between now() and current_timestamp
Awarded Jul 17, 2016 at 13:12
How to convert a unix time to PostgreSQL' Timstamp without timezome?
Awarded Jul 15, 2016 at 19:03
How to avoid implicit conversion for an Integer column
Awarded Jul 14, 2016 at 12:30
Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries
Awarded Jul 14, 2016 at 0:07
Was Management Studio removed from SQL Server 2016 installation media?
Awarded Jul 13, 2016 at 1:53
Create a MySQL database with charset UTF-8
Awarded Jul 9, 2016 at 19:24
Why does my execution plan (sometimes) include a left join?
Awarded Jul 9, 2016 at 12:29
Using multiple cores for single MySQL queries on Debian
Awarded Jul 9, 2016 at 7:40
Postgres with pgpool architecture
Awarded Jul 8, 2016 at 16:07
sp_Blitz says "Page Verification Not Optimal" on MDS database
Awarded Jul 7, 2016 at 20:18
CPU Schedulers Offline
Awarded Jul 7, 2016 at 20:18
How do I set a SQL Server Unicode / NVARCHAR string to an emoji or Supplementary Character?
Awarded Jul 7, 2016 at 20:18
How to use COLUMNS_UPDATED to check if any of certain columns are updated?
Awarded Jul 7, 2016 at 20:18
Count instances of value in multiple tables
Awarded Jul 7, 2016 at 20:18
Cross Apply Fails When DateTime Added
Awarded Jul 7, 2016 at 20:18
how to ignore the SSMS (sql server management studio) sql server ansi settings?
Awarded Jul 7, 2016 at 20:18
SELECT TOP 1 harms query performance; is there a dba-accessible way to overcome this?
Awarded Jul 7, 2016 at 19:19
Can we use TDE as an anti-injection technique
Awarded Jul 7, 2016 at 18:33
How can I insert smiley faces into MySQL ( 😊 )
Awarded Jul 7, 2016 at 14:49
Why does transaction log continue to grow in Simple recovery mode with nightly backups
Awarded Jul 7, 2016 at 14:49
CLR SQL vs T-SQL for queries
Awarded Jul 6, 2016 at 19:09
PostgreSQL streaming versus file-based replication (In terms of server behavior & configuration)
Awarded Jul 6, 2016 at 6:59
Multiple PVSCSI with SQL Server
Awarded Jul 5, 2016 at 23:08
Ordering of table is based on Clustered index or non clustered primary key?
Awarded Jul 5, 2016 at 17:52
'Conversion failed' error with ORDER BY CASE expression
Awarded Jul 4, 2016 at 17:39
Is there a better alternative than LIKE for this query?
Awarded Jul 4, 2016 at 7:51
Why is PL/Python untrusted?
Awarded Jul 1, 2016 at 8:35
Storage order vs Result order
Awarded Jul 1, 2016 at 5:09
If positive, sum all items. If negative, return each one
Awarded Jun 30, 2016 at 1:16
SQL Server Maximum and Minimum memory configuration
Awarded Jun 29, 2016 at 19:05
At What Point Should I Split or Partition a Very Large but Simple Table
Awarded Jun 26, 2016 at 18:40
SQL Server database snapshots for integration testing
Awarded Jun 23, 2016 at 20:12
Using Two LEFT JOIN or use AND with single LEFT JOIN?
Awarded Jun 23, 2016 at 12:13
SQL Server 2008 R2 Restore COPY_ONLY full backup with transaction logs
Awarded Jun 22, 2016 at 19:52
Clustered index not used in a delete statement
Awarded Jun 22, 2016 at 8:42
SQL Server 2014: any explanation for inconsistent self join cardinality estimate?
Awarded Jun 21, 2016 at 18:43
Is the overhead of frequent query cache invalidation ever worth it?
Awarded Jun 17, 2016 at 17:56
Partitioning a large table has not improved performance, why?
Awarded Jun 17, 2016 at 10:14
Refresh materalized view incrementally in PostgreSQL
Awarded Jun 16, 2016 at 9:01
Will running a large query on a secondary database in an availability group affect transaction performance in the primary database?
Awarded Jun 16, 2016 at 2:49
How can I handle unwanted, non-erroneous situations better?
Awarded Jun 15, 2016 at 18:48
Add DEFAULT to existing column
Awarded Jun 15, 2016 at 15:04
1
…
34 35
36
37 38
…
55