Help Center > Badges

 Good Answer Answer score of 25 or more. This badge can be awarded multiple times.

This badge has been awarded 84 times. Recently awarded to:
jun 5 at 16:49
Why is Database Administration so hard? — David 501314
jun 5 at 16:29
What is the difference between an INNER JOIN and an OUTER JOIN ? — LittleBobbyTables 718712
jun 5 at 7:49
How to make a transition from SQL Server DBA to Oracle? — ConcernedOfTunbridgeWells 10.7k2250
jun 5 at 0:54
How to the get current date without the time part — gbn 43.4k456107
may 29 at 9:28
How do you mysqldump specific table(s)? — RolandoMySQLDBA 42.9k530111
may 22 at 11:49
Why are constraints applied in the database rather than the code? — FrustratedWithFormsDesigner 1,777412
may 20 at 20:18
How to insert values into a table from a select query in PostgreSQL? — Jack Douglas♦ 13k22760
may 15 at 19:10
What is the difference between a “record” and a “row” in SQL Server? — Aaron Bertrand♦ 38.2k350102
may 10 at 14:05
How to determine if an Index is required or necessary — Jeremiah Peschka 1,441613
may 9 at 12:57
Is 'Avoid creating a clustered index based on an incrementing key' a myth from SQL Server 2000 days? — gbn 43.4k456107
apr 26 at 15:40
What's the difference between a CTE and a Temp Table? — JNK♦ 8,95112753
apr 18 at 7:36
Execution plan shows expensive CONVERT_IMPLICIT operation. Can I fix this with indexing or do I need to change the table? — Paul White 8,4252662
apr 4 at 22:03
When should I use a unique constraint instead of a unique index? — David Spillett 4,8781126
mar 31 at 13:27
Why is Database Administration so hard? — RolandoMySQLDBA 42.9k530111
mar 25 at 22:39
Passing array parameters to a stored procedure — Marian 8,50111335
mar 6 at 10:10
Why do people recommend not using the name “Id” for an identity column? — JNK♦ 8,95112753
feb 21 at 14:38
Why can't RDBM's cluster the way NoSQL does? — ConcernedOfTunbridgeWells 10.7k2250
feb 17 at 11:39
What are the arguments against or for putting application logic in the database layer? — gbn 43.4k456107
feb 8 at 16:26
Why is there still a varchar data type? — gbn 43.4k456107
feb 7 at 10:41
Running total with count? — Aaron Bertrand♦ 38.2k350102
feb 1 at 1:53
How far should you go with normalization? — jcolebrand♦ 3,84711749
jan 30 at 3:36
Is it OK to keep a value which updates in a table? — db2 3,674420
jan 29 at 18:25
How to dive into an ugly database? — Bill Karwin 831158
jan 25 at 8:55
When should a primary key be declared non-clustered? — Remus Rusanu 22.1k22359
jan 24 at 13:58
How do I list all databases and tables using psql? — Frank Heikens 1,859812
jan 3 at 18:39
How can I learn to become a DBA? — Matt Rogish 38622
dec 27 at 15:39
Why are Denali sequences supposed to perform better than identity columns? — mrdenny♦ 17.9k1443
dec 20 at 14:03
Can MySQL reasonably perform queries on billions of rows? — Koliber Services 45416
dec 5 at 23:56
Performance of Non Clustered Indexes on Heaps vs Clustered Indexes — Filip De Vos 396310
nov 27 at 21:31
Are SQL Server in-place upgrades as ill advised as they used to be? — Mike Walsh 3,548734
oct 7 at 9:11
Why use both TRUNCATE and DROP? — Martin Smith 18.1k43782
sep 21 at 8:38
Storing vs calculating aggregate values — Brian Ballsun-Stanton 3,20111331
sep 6 at 4:20
As a DBA, how would I go about transitioning from Oracle to SQL Server? — ConcernedOfTunbridgeWells 10.7k2250
sep 3 at 23:54
What should I use? A string or 15 integer fields? — Cade Roux 3,688827
aug 27 at 18:44
Does SQL Server read all of a COALESCE function even if the first argument is not NULL? — Aaron Bertrand♦ 38.2k350102
aug 21 at 21:22
Commonly Used Acronyms by Database Administrators — nojak 121210
aug 20 at 3:00
Unexpected scans during delete operation using WHERE IN — Paul White 8,4252662
jul 18 '12 at 18:28
Efficency of stored procedures vs raw queries — mrdenny♦ 17.9k1443
jul 13 '12 at 7:24
Is there a name for this database structure? — Simon Righarts 2,466918
jul 9 '12 at 18:06
Should you design the database before the application code is written? — gbn 43.4k456107
jul 3 '12 at 18:26
Can MySQL reasonably perform queries on billions of rows? — srini.venigalla 61417
jul 3 '12 at 18:16
Can MySQL reasonably perform queries on billions of rows? — Kevin Bedell 651115
jun 28 '12 at 3:43
When to use TINYINT over INT? — Mark Storey-Smith 19.4k13172
jun 22 '12 at 8:52
How could DBAs be more 'programmer friendly'? — RolandoMySQLDBA 42.9k530111
jun 16 '12 at 11:44
When to use NULL and when to use an empty string? — Larry Coleman 93665
jun 14 '12 at 11:18
Best practices on common person fields (Name, email, address, gender etc…) — Justin Cave 9,59911529
jun 11 '12 at 20:42
Why are numbers tables “invaluable”? — Remus Rusanu 22.1k22359
may 31 '12 at 13:51
Possible attack on my SQL server? — Mark Storey-Smith 19.4k13172
may 16 '12 at 13:54
A good SQL sniffer — Thomas Stringer 15.5k32457
may 14 '12 at 18:43
Is using multiple foreign keys separated by commas wrong, and if so, why? — Simon Righarts 2,466918
may 14 '12 at 3:18
How do you document your databases? — Cade Roux 3,688827
may 3 '12 at 13:35
What are Objective Business Reasons to Prefer SQL Server 2012 over 2008 R2? — Aaron Bertrand♦ 38.2k350102
apr 26 '12 at 18:47
Is table aliasing a bad practice? — Nick Chammas 5,95822963
apr 18 '12 at 14:23
What's the point of WHERE 1=2 for SELECT INTO table query — Thomas Stringer 15.5k32457
apr 12 '12 at 6:12
What's the difference between a temp table and table variable in SQL Server? — Martin Smith 18.1k43782
apr 11 '12 at 19:12
Why is it a bad practice to allow everyone to use the sa login? — Brent Ozar 4,711736
mar 23 '12 at 16:53
Where should you define foreign keys? — ConcernedOfTunbridgeWells 10.7k2250
mar 13 '12 at 6:13
SQL Server “empty table” is slow after deleting all (12 million) records? — Remus Rusanu 22.1k22359
feb 25 '12 at 12:49
How can I optimize a mysqldump of a large database? — David Spillett 4,8781126
feb 16 '12 at 0:23
How can a group track database schema changes? — eiefai 949914
1 2