Aaron Bertrand

36,285 reputation

34995

bio	website
	location	Rhode Island
	age	39
visits	member for	2 years, 2 months
	seen	22 mins ago
stats	profile views	1,882

Senior Consultant at SQL Sentry, SQL Server MVP, blogger at sqlperformance.com and sqlblog.com, Mac user, volleyball player, curler, hockey/football/tennis fan (Go Bruins!), proud father and Canadian, eh?

From May 24 -> June 1 I will be mostly offline.

	36,285 reputation	bio	website		visits	member for	2 years, 2 months
34995 badges		location	Rhode Island		seen	22 mins ago

summary answers questions tags badges favorites bounties reputation activity

36,285 Reputation

graph time post

yesterday

+10	14:41	upvote	Where are Statistics physically stored in SQL Server?
+10	07:30	upvote	checksum(newid()) as primary key - what happens if a collision occurs?

230

2 days ago

+85	23:00	8 events	Does an index with multiple columns make a similar index redundant?
+35	14:51	3 events	How to get a row_number to have the behavior of dense_rank
+30	09:10	3 events	Will a primary key be added as a clustered index?
+20	17:30	3 events	View column has an 8000 character limit?
+20	14:44	2 events	How to attach an .mdf file that was not properly detached?
+20	07:21	2 events	Why do linked servers have a limitation of 10 branches in a CASE expression?
+10	18:48	3 events	Can I trust the Database Engine Tuning Advisor recommendations?
+10	14:23	upvote	How does this undocumented syntax work? {fn CurDate()} or {fn Now()} etc
	18:21	upvote	SQL Server 2012 installation silently fails

215

May 22

+40	21:33	4 events	How to get a row_number to have the behavior of dense_rank
+30	22:30	4 events	How to attach an .mdf file that was not properly detached?
+30	22:30	4 events	Performance effect of indexing foreign keys
+20	22:30	2 events	View column has an 8000 character limit?
+20	22:30	2 events	Why do linked servers have a limitation of 10 branches in a CASE expression?
+20	10:33	2 events	Is there any way to prevent the memo structure from being pruned?
+20	08:54	2 events	checksum(newid()) as primary key - what happens if a collision occurs?
+15	12:06	accept	Is there a standard way to use common data and procedures across multiple databases?
+10	14:47	upvote	Why shouldn't we allow NULLs?
+10	00:26	upvote	Why does ORDER BY not belong in a View?

230

May 21

215

May 20

May 19

May 18

110

May 17

May 16

May 15

153

May 14

May 13

May 12

May 11

May 10

May 9

May 8

May 7

May 6

May 5

May 4

May 3

May 1

Apr 30

Apr 29

Apr 28

Apr 27

210

Apr 26

185

Apr 25

125

Apr 24