Reputation
Next tag badge:
98/100 score
33/20 answers
Badges
11 85 191
Newest
 Guru
Impact
~7.5m people reached

Oct
24
revised How to repair all indexes in a MySQL database?
added 641 characters in body
Oct
24
answered How to repair all indexes in a MySQL database?
Oct
24
reviewed Close Alternative method of viewing a database diagram in SQL Server to see what tables have gone missing?
Oct
24
comment How to create new column with value from other table
Lesson #2: Doctors can help you with JOINTS. You come here for help with JOINs.
Oct
24
reviewed No Action Needed Populate the columns of one table with the records of another
Oct
24
reviewed Reviewed Database design to track student attendance
Oct
24
reviewed Close Time Boxing SSIS Task
Oct
24
comment How to create new column with value from other table
+1 for getting to this first
Oct
24
reviewed No Action Needed failed with the following error: “Write on ”…bak" failed: 27(error not found) BACKUP DATABASE is terminating abnormally
Oct
24
reviewed No Action Needed SQL Server Management Studio - connection with SQL Server database engine
Oct
24
reviewed No Action Needed Cannot connect to database remotely (not even locally when using ip address)
Oct
24
reviewed No Action Needed db2-AIX multiple admin accounts
Oct
24
reviewed No Action Needed Fastest way to change a 600GB table indexed key datatype from INT to BIGINT
Oct
24
reviewed No Action Needed MYSQL How do I query to show data in separate columns from one field?
Oct
24
reviewed Reject SQL Server Decimal(9, 0) vs INT
Oct
24
reviewed Approve MYSQL How do I query to show data in separate columns from one field?
Oct
23
comment Does using LIMIT improve the performance and is it noticeable?
It's more like (A LIMIT 100) [LEFT] JOIN B. The idea is to use LIMIT to determine the size of the result set as early as possible. I also use LEFT JOIN instead of INNER JOIN because LEFT JOIN will preserve the order of the keys on the left side.
Oct
23
revised Does using LIMIT improve the performance and is it noticeable?
added 2 characters in body
Oct
23
answered Does using LIMIT improve the performance and is it noticeable?
Oct
23
revised Fastest way to change a 600GB table indexed key datatype from INT to BIGINT
added 39 characters in body; edited tags