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, 4 months
  • Last seen this week
Profile Activity
Stats
16,003
reputation
1.3m
reached
522
answers
0
questions
Communities
View all
About

I've written a book, SQL Antipatterns Volume 1: Avoiding the Pitfalls of Database Programming from Pragmatic Bookshelf.

I no longer use Stack Overflow or other Stack Exchange sites.

Badges
View all badges
2
gold badges
31
silver badges
42
bronze badges
Top tags
View all tags
1,130
Score
496
Posts
95
Posts %
167
Score
62
Posts
12
Posts %
153
Score
47
Posts
9
Posts %
90
Score
36
Posts
7
Posts %
85
Score
24
Posts
5
Posts %
74
Score
39
Posts
7
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
mysqldump not escaping single quotes properly
Nov 29, 2012
answer
12
Row size error with MySQL
Aug 29, 2014
Top network posts
View all network posts
1421
Retrieving the last record in each group - MySQL
1164
What's the difference between identifying and non-identifying relationships?
1131
"INSERT IGNORE" vs "INSERT ... ON DUPLICATE KEY UPDATE"
810
Should I use != or <> for not equal in T-SQL?
745
How do the Proxy, Decorator, Adapter, and Bridge Patterns differ?