Network profile

Lennart

Reputation

19,513

19.5k
12.7k
6k

2018
2019
2020
2021

Top tag

mysql

Next privilege

20,000 Rep.

Access 'trusted user' tools

Badges

2

21

54

Newest

Notable Question

Next badge

29/30

Impact

147 posts edited

34 helpful flags

1,371 votes cast

Answers (786)

Votes Activity Newest

47	NOT (a=1 AND b=1) vs (a<>1 AND b<>1)
27	If a database only ever has one insert, is it bad to index every possible column combination?
14	Does `COUNT` discard duplicates?
12	Does the spec permit column-count mismatch on INSERT?
12	What is the optimized way to pass multiple parameter from a single table to a function?

View more →

Reputation (19,513)

+10	Create smaller row from alias and preserve column names
+10	New bufferpool not being used
+10	How to insert data into tables which reference each other?(MySQL)
+10	Select multiple values in LIKE Operator

View more →

Questions (42)

Votes Activity Newest

5	What is the meaning of `(ORDER BY x RANGE BETWEEN n PRECEDING…)` if x is a date?
3	New bufferpool not being used
3	How to install pgcrypto?
3	Find invalid objects in database?
3	What might be the reason for licence compliance violation?

View more →

Tags (262)

404 mysql × 276	92 foreign-key × 37
316 sql-server × 118	88 query-performance × 49
235 postgresql × 151	86 t-sql × 24
121 database-design × 68	83 join × 53
97 performance × 59	68 db2 × 96

View more →

Bookmarks (6)

Votes Activity Newest Views Added

12	Inner join elimination inhibited by prior outer join
4	How many B-tree indexes do I need to support lookups by any subset of n columns?
2	mysql - sum interval dates
1	delayed locks after commit?
1	Storing data on separate storage volumes

View more →

Accounts (24)

	Database Administrators	19,513 rep	2 gold badges21 silver badges54 bronze badges
	Stack Overflow	5,552 rep	1 gold badge15 silver badges29 bronze badges
	Mathematics	153 rep	7 bronze badges
	Geographic Information Systems	133 rep	4 bronze badges
	Academia	101 rep	1 bronze badge

Badges (46)

Recent Class Name

Notable Question	Caucus × 2
Nice Answer × 8	Constituent × 2
Enlightened × 2	Popular Question × 7
mysql	Yearling × 6
Revival × 7	Sportsmanship

View more →

Active bounties (0)

Active Offered Earned

This user has no active bounties

Votes cast (1,371)

all time			by type			month
1,243	up		240	question		2
128	down		1,131	answer		2

Database Administrators Stack Exchange works best with JavaScript enabled