Aaron Bertrand

38,180 reputation

350102

bio	website
	location	Rhode Island
	age	39
visits	member for	2 years, 3 months
	seen	1 hour ago
stats	profile views	2,060

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?

I will be in Ireland at SQL Saturday #229, June 20 -> 24, so largely offline during that time.

	38,180 reputation	bio	website		visits	member for	2 years, 3 months
350102 badges		location	Rhode Island		seen	1 hour ago

summary answers questions tags badges favorites bounties reputation activity

687 Answers

newest activity votes

Why shouldn't we allow NULLs?

aug 30 '11 at 23:01

What are Objective Business Reasons to Prefer SQL Server 2012 over 2008 R2?

mar 9 '12 at 20:10

Does SQL Server read all of a COALESCE function even if the first argument is not NULL?

sep 19 '11 at 17:47

What is the difference between a “record” and a “row” in SQL Server?

jan 13 at 0:17

Running total with count?

jun 19 '12 at 3:31

In SQL Server, what is the purpose of grouping stored procedures?

sep 18 at 18:53

Which DBMS are fast enough for an online game (few thousand players)?

jul 7 '11 at 18:37

Still wrong to start the name of a user stored procedure with sp_?

oct 3 at 14:32

Stored procedures vs. inline SQL

jun 14 at 15:17

In what data type should I store an email address in database?

mar 19 at 14:59

Why does ALTER COLUMN to NOT NULL cause massive log file growth?

nov 29 at 17:17

Composing the “ultimate database maintenance script”

aug 7 at 13:16

Why does ORDER BY not belong in a View?

jul 24 at 20:34

What database technologies do big search engines use?

jun 1 '12 at 11:59

Does SQL Sentry Plan Explorer work?

aug 4 '11 at 18:16

Where are Statistics physically stored in SQL Server?

oct 18 at 15:55

Why do wildcards in GROUP BY statements not work?

jul 20 '12 at 13:22

Why is the SELECT clause listed first?

jun 22 '12 at 22:06

Efficient way of changing VARCHAR to NVARCHAR fields in a large table in SQL Server 2008?

jul 19 '12 at 16:23

Why are numbers tables “invaluable”?

jan 25 '12 at 15:12

How does SQL Server order results when joins are used?

nov 27 at 20:41

Are these two queries logically equivalent?

oct 17 at 15:29

How can I force SQL Server Management Studio to update metadata?

may 18 '12 at 15:30

Is a join optimized to a where clause at runtime?

feb 27 at 16:37

Is there a reason to update statistics manually?

feb 10 '12 at 20:18

Is that a good idea to use one database for 50.000+ shops?

jan 25 at 16:01

How do I add minutes to a time data type?

jan 10 at 3:29

Restore SQL Server 2012 backup to a SQL Server 2008 database?

jul 9 '12 at 16:58

Is there a way to force an index to stay in memory with SQL Server 2008?

feb 15 '12 at 20:32

How do you kick users out of a SQL Server 2008 database?

sep 21 '11 at 22:18