Reputation
27,152
Next tag badge:
563/400 score
69/80 answers
Badges
9 93 163
Newest
 Enlightened
Impact
~549k people reached

Jul
22
reviewed Looks OK Error PRVG-11322 while atempting to install ODAC 12c release 3
Jul
21
reviewed Reviewed How do I convert a datetime column from SQL Server 2014 to Oracle 11g using ogr2ogr?
Jul
21
reviewed Close Creating a relationship between one field in a table with two fields in another
Jul
21
reviewed Leave Open How to model “Courses prerequisites” for a university?
Jul
21
reviewed Close MySQL not updating a row (zero row(s) affected)
Jul
21
reviewed Leave Open DB design for employee working hours constraints
Jul
21
reviewed Reject DB2 Materialised Query Table performance problems
Jul
21
reviewed Approve Process Data cube from job on SQL server
Jul
21
reviewed Reviewed Storing a music playlist, best approach?
Jul
21
reviewed Reviewed PostgreSQL user can not connect to server after changing password
Jul
21
revised PostgreSQL user can not connect to server after changing password
Spelling and formatting
Jul
21
reviewed Reviewed How do I list or search all the column names in my database?
Jul
21
revised How do I list or search all the column names in my database?
Code formatting
Jul
20
comment How do I merge similar records with different validity dates?
How large is the "large" dataset? Why don't you fix the snapshot import so it doesn't create the problem in the first place?
Jul
20
reviewed Close How to name a new table storing location at which transaction occurred
Jul
20
reviewed Close Help writing query for MS SQL Server
Jul
20
reviewed No Action Needed MongoDB does'nt starts after changing the data directory
Jul
20
revised How do I merge similar records with different validity dates?
edited tags
Jul
20
reviewed Leave Open FOR XML could not serialize the data because it contains character (0x0000)
Jul
20
comment Overcome MERGE JOIN(INDEX SCAN) with explicit single KEY value on a FOREIGN KEY
@OlegI No, there's no way to choose loop/merge per validation, closest would be to use a plan guide, but it could be tough to construct. Yes, the QO makes a cost-based decision for each FK.