Badge

 Nice Answer Answer score of 10 or more. This badge can be awarded multiple times.

This badge has been awarded 825 times. Recently awarded to:
15h ago
Right Join vs Left Join - My joins are broken and I don't understand why — billinkc 2,5311523
15h ago
SQL Server 2000 to 2008 to 2012 — Mike Walsh 3,548734
15h ago
Does combining columns into 1 column helps to optimize a large table? — JNK♦ 8,70512453
15h ago
datatypes in sql server , difference between similar dataypes, numeric, money , decimal ,float — JNK♦ 8,70512453
15h ago
What is the preferred method to roll out updates to hundreds of databases — JNK♦ 8,70512453
15h ago
Why are Denali sequences supposed to perform better than identity columns? — Martin Smith 17.5k43579
15h ago
Optimising plans with XML readers — Paul White 8,1652459
1d ago
Is there any way to prevent the memo structure from being pruned? — Paul White 8,1652459
2d ago
(post deleted or otherwise unavailable) — Thilo 11112
2d ago
What does a SQL Server DBA need to know about Windows Server? — gbn 42.4k353105
may 20 at 17:47
Index Seek vs Index Scan — David Spillett 4,7231124
may 20 at 6:35
Why can't we perform joins in a distributed database like Bigtable? — Jonas 1,62442341
may 19 at 10:23
Can spatial index help a “range - order by - limit” query — Erwin Brandstetter 8,8671238
may 17 at 21:12
Installation of SQL Server RAID 10 vs RAID 5 — Aaron Bertrand 36.3k34995
may 16 at 21:39
Advantages and Disadvantages to using ENUM vs Integer types? — RolandoMySQLDBA 41.7k528108
may 16 at 1:22
How to create a database for unknown kinds of data? — Chris Travers 5,416534
may 15 at 14:18
How can I generate Cassandra data model from a MySQL schema? — JamesRyan 38618
may 14 at 21:28
Still wrong to start the name of a user stored procedure with sp_? — marc_s 3,04711225
may 14 at 19:18
Do empty columns take up space in a table? — JNK♦ 8,70512453
may 12 at 2:06
I have a powerful machine with 70 GB RAM. How many Oracle instances with 20 GB can be created? — Phil 10.3k11334
may 11 at 19:53
Installation of SQL Server RAID 10 vs RAID 5 — Kevin Edward Kline 1312
may 11 at 6:55
PostgreSQL is running locally but I cannot connect. Why? — thure 2264
may 10 at 7:48
MySQL Sharding vs MySQL Cluster — Frazer Clement 41622
may 10 at 7:38
If I fail over one database, do the others that share the same mirror endpoint fail over as well? — Kin 2,217211
may 9 at 12:42
How To Profile Stored Procedures — Mike Walsh 3,548734
may 9 at 10:11
Restore exceeds licensed limit of 10240 MB per database. All I really need is the DB structure — mrdenny♦ 17.2k1442
may 9 at 6:55
Are SQL Server statistics stored in database or buffer pool? — Remus Rusanu 21.1k22357
may 8 at 18:17
How to find the SQL statements which caused the tempdb grew huge? — Mark Storey-Smith 18.8k13072
may 7 at 22:09
Database Design: New Table versus New Columns — Todd Everett 65615
may 7 at 7:49
Copy PostgreSQL data from one PC to another — swasheck 2,913733
may 4 at 2:10
Why can't RDBM's cluster the way NoSQL does? — Matt 1215
may 3 at 22:09
Is there way to join every row of TableA to a row of the smaller TableB by repeating TableB however many times are needed? — Lamak 657613
may 3 at 18:02
How do I map an IS-A relationship into a database? — Nick Chammas 5,91022763
may 2 at 17:07
For absolute performance, is SUM faster or COUNT? — Erwin Brandstetter 8,8671238
may 2 at 16:07
Should I be alarmed by this NO JOIN PREDICATE warning? — Martin Smith 17.5k43579
may 2 at 4:19
Force sql server to run query conditions as written? — RBarryYoung 1,537213
may 1 at 15:19
Retrieving row count without using Count function — RThomas 1,488316
apr 30 at 15:37
Error on import of mysqldump file - Illegal double value found during parsing — RolandoMySQLDBA 41.7k528108
apr 30 at 4:24
What could cause the wrong ID to be inserted? — Max Vernon 4,2063533
apr 30 at 4:24
How to insert in a table with only an IDENTITY column? — Aaron Bertrand 36.3k34995
apr 27 at 22:36
What is the name of this schema pattern — Joel Brown 4,1351619
apr 27 at 22:36
What is the name of this schema pattern — ConcernedOfTunbridgeWells 10.4k2049
apr 27 at 22:36
Improve performance of sys.dm_db_index_physical_stats — Remus Rusanu 21.1k22357
apr 26 at 20:20
Why does InnoDB store all databases in one file? — RolandoMySQLDBA 41.7k528108
apr 26 at 18:15
Is it possible to have passwords configured per database or per host in .my.cnf — Derek Downey 9,88242256
apr 25 at 14:20
SQL Server Transaction Backups vs Logs — StrayCatDBA 780111
apr 24 at 11:31
Storing data as rows as opposed to columns — Remus Rusanu 21.1k22357
apr 22 at 18:46
What is a partitioned view? — Justin Cave 9,43111427
apr 22 at 16:26
DBCC CHECKDB firing every 20 - 60 seconds — Thomas Stringer 14.4k22453
apr 20 at 13:09
How can I use a default value in a Select query in PostgreSQL? — Jack Douglas♦ 12.8k22657
apr 18 at 7:11
Varchar(Max) field cutting off data after 8000 characters SQL Server 2008 — Martin Smith 17.5k43579
apr 16 at 17:59
Why are constraints applied in the database rather than the code? — Colin 't Hart 1,206113
apr 16 at 11:31
Why should I create an ID column when I can use others as key fields? — Michael Durrant 26317
apr 15 at 12:34
Version control for database objects — Remus Rusanu 21.1k22357
apr 15 at 11:24
Why does an Oracle database require both the SYSTEM and the SYSAUX tablespaces? — Brian Ballsun-Stanton 3,18111331
apr 14 at 22:45
Included Index Vs Filtered Index — Remus Rusanu 21.1k22357
apr 14 at 18:54
Database design: Dividing multiple identical tables, good or bad? — Mike Sherrill 'Catcall' 4,422620
apr 14 at 14:18
Is a join optimized to a where clause at runtime? — Paul White 8,1652459
apr 13 at 23:38
Is there a tool to check if my database is normalized to the third normal form? — Michael - sqlbot 3,2131216
apr 13 at 0:14
Why are constraints applied in the database rather than the code? — FrustratedWithFormsDesigner 1,734412
1 2 3 4 5 … 14