Badge

 Enlightened First to answer and accepted with score of 10 or more. This badge can be awarded multiple times.

This badge has been awarded 299 times. Recently awarded to:
21h ago
SQL Server 2000 to 2008 to 2012 — Mike Walsh 3,548734
21h ago
What is the preferred method to roll out updates to hundreds of databases — JNK♦ 8,70512453
21h ago
datatypes in sql server , difference between similar dataypes, numeric, money , decimal ,float — JNK♦ 8,70512453
21h ago
Does combining columns into 1 column helps to optimize a large table? — JNK♦ 8,70512453
2d ago
What does a SQL Server DBA need to know about Windows Server? — gbn 42.4k353105
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 10 at 8:13
MySQL Sharding vs MySQL Cluster — Frazer Clement 41622
may 2 at 17:23
Should I be alarmed by this NO JOIN PREDICATE warning? — Martin Smith 17.5k43579
may 1 at 16:40
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
How to insert in a table with only an IDENTITY column? — Aaron Bertrand 36.3k34995
apr 27 at 23:52
Improve performance of sys.dm_db_index_physical_stats — Remus Rusanu 21.1k22357
apr 26 at 19:20
Is it possible to have passwords configured per database or per host in .my.cnf — Derek Downey 9,88242256
apr 25 at 15:00
SQL Server Transaction Backups vs Logs — StrayCatDBA 780111
apr 25 at 6:03
What is a partitioned view? — Justin Cave 9,43111427
apr 24 at 13:41
Storing data as rows as opposed to columns — Remus Rusanu 21.1k22357
apr 22 at 17:21
DBCC CHECKDB firing every 20 - 60 seconds — Thomas Stringer 14.5k22453
apr 22 at 0:59
How do you mysqldump specific table(s)? — RolandoMySQLDBA 41.7k528108
apr 20 at 15:01
How can I use a default value in a Select query in PostgreSQL? — Jack Douglas♦ 12.9k22657
apr 18 at 7:31
Varchar(Max) field cutting off data after 8000 characters SQL Server 2008 — Martin Smith 17.5k43579
apr 15 at 11:39
Why does an Oracle database require both the SYSTEM and the SYSAUX tablespaces? — Brian Ballsun-Stanton 3,18111331
apr 14 at 19:04
Database design: Dividing multiple identical tables, good or bad? — Mike Sherrill 'Catcall' 4,422620
apr 5 at 11:38
Securely generate a UNIQUEIDENTIFIER in SQL Server — Martin Smith 17.5k43579
apr 3 at 11:22
SQL Server uses only 1 CPU of 4 available — Ed Harper 30738
mar 27 at 7:30
Custom unique column constraint, only enforced if one column has a specific value — Erwin Brandstetter 8,8861238
mar 26 at 16:26
SQL Server Express on Windows 8 isn't locking MDF database files — Remus Rusanu 21.1k22357
mar 26 at 9:18
In Change Data Capture (CDC), why lsn is used instead of timestamp? — gbn 42.4k353105
mar 19 at 6:07
How do you move a SQL Server 7 database to SQL Server 2012? — Mike Fal 2,475517
mar 17 at 11:37
Parameter Sniffing vs VARIABLES vs Recompile vs OPTIMIZE FOR UNKNOWN — Martin Smith 17.5k43579
mar 17 at 8:49
Does an IOT guarantee order in a select? — Nick Chammas 5,92022763
mar 17 at 7:43
Combine column from multiple rows into single row — Aaron Bertrand 36.3k34995
mar 13 at 15:49
how do I insert a default row? — Martin Smith 17.5k43579
mar 12 at 15:52
Sql Server - Best Practices for Growing Database Files — Aaron Bertrand 36.3k34995
mar 11 at 18:55
Common Table Expression (CTE) benefits? — JNK♦ 8,70512453
mar 6 at 23:49
Is there a concept of an “include file” in SQL Server? — Michael Fredrickson 465312
mar 5 at 19:16
How to identify which query is filling up the tempdb transaction log? — Aaron Bertrand 36.3k34995
mar 5 at 9:41
A database in MySQL is a schema in Oracle : I do not understand this statement — Phil 10.3k11334
feb 27 at 19:01
Is a join optimized to a where clause at runtime? — Aaron Bertrand 36.3k34995
feb 27 at 16:51
Why would I NOT use the SQL Server option “optimize for ad hoc workloads”? — Peter Schofield 1,79948
feb 26 at 22:13
Is there any difference between putting a column alias at the start or the end of the column definition? — Thomas Stringer 14.5k22453
feb 23 at 22:47
Does SQL Server use pointers instead of storing duplicate rows? — gbn 42.4k353105
feb 23 at 0:56
Index fragmentation and SSD disks — Paul White 8,1652459
feb 20 at 8:01
Trigger in combination with transaction — Martin Smith 17.5k43579
feb 19 at 13:09
SQL Database Structure for RESTful API — Mark Storey-Smith 18.9k13072
feb 18 at 14:06
Are there disadvantages to contained databases? — Aaron Bertrand 36.3k34995
feb 17 at 16:05
Is PostgreSQL replication production ready? — Craig Ringer 4,374518
feb 14 at 22:03
Methods of speeding up a huge DELETE FROM <table> with no clauses — gbn 42.4k353105
feb 14 at 17:38
Why are non-digits LIKE [0-9]? — Martin Smith 17.5k43579
feb 7 at 21:26
SQL Server 2012 - Always On — Aaron Bertrand 36.3k34995
feb 7 at 0:38
selecting where two columns are in a set — ypercube 8,92021544
feb 6 at 16:15
SQL Server TempDB behaviour in large memory environment — Mark Storey-Smith 18.9k13072
feb 1 at 14:44
Is it ALWAYS possible to avoid cursor? — Aaron Bertrand 36.3k34995
feb 1 at 12:59
How to tackle a large undocumented database — Mark Storey-Smith 18.9k13072
jan 31 at 1:47
Is there any tangible difference between a unique clustered index and a clustered primary key? — Marian 8,44011334
jan 31 at 1:07
Which is faster, InnoDB or MyISAM? — RolandoMySQLDBA 41.7k528108
jan 30 at 13:22
How can a group track database schema changes? — eiefai 934914
jan 28 at 20:09
Is there an analog of GETDATE() that returns DATETIME2 — swasheck 2,913733
jan 28 at 7:09
Importance of ER Diagrams — holodoc 22634
jan 28 at 4:19
Who installed SQL Server — mrdenny♦ 17.2k1442
jan 25 at 23:15
Is that a good idea to use one database for 50.000+ shops? — Aaron Bertrand 36.3k34995
1 2 3 4 5