Skip to main content
Database Administrators
Bill Karwin's user avatar
Bill Karwin's user avatar
Bill Karwin's user avatar
Bill Karwin
  • Member for 13 years, 1 month
  • Last seen this week
Profile Activity
Stats
15,473
reputation
1.3m
reached
502
answers
0
questions
Communities
View all
About

I've been a software engineer since 1987, and my specialty is as an SQL maven. I also have experience programming in Java, Ruby, Python, Go, PHP, Perl, C, JavaScript, and I have many other coding skills.

I've written a book, SQL Antipatterns Volume 1: Avoiding the Pitfalls of Database Programming from Pragmatic Bookshelf, based on the most common SQL problems I've answered on Stack Overflow and other forums, mailing lists, and newsgroups.

Badges
View all badges
2
gold badges
31
silver badges
42
bronze badges
Top tags
View all tags
1,092
Score
476
Posts
95
Posts %
163
Score
60
Posts
12
Posts %
149
Score
44
Posts
9
Posts %
85
Score
24
Posts
5
Posts %
76
Score
33
Posts
7
Posts %
73
Score
38
Posts
8
Posts %
Top posts
View all questions and answers
answer
29
How to dive into an ugly database?
Nov 10, 2008
answer
27
MySQL - How to check for a value in all columns
Sep 15, 2019
answer
23
Is the concept of a clustered index in a DB design sensical when using SSDs?
Nov 28, 2011
answer
21
How are auto_increment keys handled in INSERT (SELECT * FROM...)
Mar 9, 2014
answer
20
InnoDB create table error: "Row size too large"
Oct 6, 2011
answer
18
What are the drawbacks of using Galera Cluster instead of Master/Slave Replication?
Dec 6, 2013
answer
15
How do you tune innodb_read_io_threads?
Sep 12, 2021
answer
13
Do I need --skip-lock-tables with --single-transaction?
Sep 28, 2021
answer
12
Row size error with MySQL
Aug 29, 2014
answer
12
mysqldump not escaping single quotes properly
Nov 29, 2012
Top network posts
View all network posts
1417
Retrieving the last record in each group - MySQL
1162
What's the difference between identifying and non-identifying relationships?
1128
"INSERT IGNORE" vs "INSERT ... ON DUPLICATE KEY UPDATE"
805
Should I use != or <> for not equal in T-SQL?
742
How do the Proxy, Decorator, Adapter, and Bridge Patterns differ?