Michael Green

Member for 9 years, 8 months
Last seen this week

Melbourne, Australia

Summary

Reputation

24,688

24.7k
21.3k
17.8k

2020
2021
2022
2023

Top tag

sql-server

Next privilege

25,000 Rep.

Access to site analytics

Badges

13

51

95

Newest

Popular Question

Next badge

67/500

Illuminator

Answers

View all 839 answers

Score Activity Newest

47

Not using foreign key constraints in real practice. Is it OK?

Mar 30, 2017

34

Why would SELECT * be magnitudes faster than SELECT foo?

Jul 27, 2014

29

Does it save anything to use a smaller varchar or nvarchar size instead of some large value like 4000?

Feb 12, 2022

19

Does an excessive table violate normalization rules?

Oct 7, 2019

19

What is the benefit of indexing assuming that SQL server has huge memory to accomodate the entire database in memory?

Sep 1, 2022

Questions

View all 25 questions

Score Activity Newest Views

23

Implementation and contraindications for OPTIMIZE_FOR_SEQUENTIAL_KEY

Jul 1, 2019

12

Convert a date range to an interval description

May 10, 2016

11

Inline Scalar UDF Under RCSI - Can Results Differ

Nov 6, 2019

7

What is the stride of a GAM interval

Mar 30

6

Why does estimated memory have a three phase shape?

Feb 22, 2022

Tags

View all 359 tags

sql-server

861

Score

389

posts

database-design

492

Score

220

posts

performance

174

Score

76

posts

mysql

148

Score

88

posts

postgresql

115

Score

51

posts

Reputation

+20

Is a serialization anomaly only possible with SUM/COUNT?

+10

Order of operation with LTRIM/RTRIM/ISNULL

+10

Find first non-matching character between two strings

+10

Can a weak entity have a primary key?

Badges

View all badges

13

gold badges

Marshal

Apr 5, 2018
Copy Editor

Dec 6, 2016
Electorate

Mar 14, 2017

51

silver badges

database-design

Dec 21, 2020
Archaeologist

Jul 27, 2017
Sportsmanship

Oct 6, 2017

95

bronze badges

performance

Jan 3, 2020
postgresql

Jul 10, 2022
mysql

Feb 17, 2017

Accounts

View all 20 accounts

Database Administrators

24.7k
13
51
95

1,407
1
18
25

Software Engineering

903
5
16

Cross Validated

173
5

158
1
7

Active bounties (0)

Active Offered Earned

This user has no active bounties

Votes cast

3,935

upvotes

227

downvotes

1,861

question votes

2,301

answer votes