Reputation
990
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
6 16
Impact
~14k people reached

12h
answered Are mysql global variables values in bytes?
Aug
28
comment ERROR 1091 (42000): Can't DROP 'created_date'; check that column/key exists
You're confusing index name and column name. When you want to drop an index, use the index name.
Aug
27
accepted SQL Server data folder access rights
Aug
27
revised SQL Server data folder access rights
deleted 3 characters in body
Aug
27
asked SQL Server data folder access rights
Aug
20
awarded  Notable Question
Aug
4
answered Major performance difference from a small change in query
Aug
4
awarded  Constituent
Aug
3
answered Select Between Date Range Mysql
Jul
31
comment MySQL Query with good execution plan is very slow due to Sending data operation
@NoahGoodrich You're missing an index on b.id
Jul
28
awarded  Caucus
Jul
27
reviewed No Action Needed Is it necessary for rownum = 1 with Query.createQuery().getSingleResult()?
Jul
24
comment Use “NOT IN” in the same table, Mysql
@Mihai CREATE TABLE AS creates a table just with same datatypes, nothing else. CREATE TABLE LIKE creates a table including primary key and foreign keys and indexes.
Jul
24
comment Set in mySQL a predefined order for SELECT queries without using the ORDER BY clause
@Masoud There is no ordered data in a relational database unless you specify it with ORDER BY!
Jul
24
answered Set in mySQL a predefined order for SELECT queries without using the ORDER BY clause
Jul
24
answered Use “NOT IN” in the same table, Mysql
Jul
17
reviewed Reviewed Avoid joining to the same table multiple times
Jul
17
comment Avoid joining to the same table multiple times
A few explaining words are always a good idea, just saying.
Jul
17
answered How to merge two large mysql tables into one with similar data keeping the latest record
Jul
13
answered Can I remove “/*!50100 PARTITION BY HASH…” to success with import?