Aaron Bertrand

Aaron Bertrand has asked 2 questions and find answers to 695 problems.

Stats

About

Proud father of two beautiful girls
🇨🇦
Mac user
24-time MVP
blogger at sqlperformance.com, mssqltips.com, and sqlblog.org
OSS contributor (e.g. Brent Ozar's First Responder Kit, Andy Mallon's DBA Database, and my own ParamParser)
Cheer for:
- 🏈 ➜ Patriots
- 🏒 ➜ Bruins
- 🎾 ➜ Nadal
- 🥌 ➜ Me

Aaron Bertrand questions

How do I get date/time information from a TIMESTAMP column?
Improve GeSHi syntax highlighting for T-SQL

Aaron Bertrand answers

Clustered Index Scan instead of Clustered Index Seek on left join
UPDATE modified date trigger only if modified date is not supplied
Select statement on non-existing columns not being caught by exception block
Using OpenQuery With INSERT INTO Statement
Adding column to table and then setting value gives error
Does full backup work with simple recovery mode? [closed]
Reuse a table variable?
How can I store and query schedule data?
Should I remove clustered index from surrogate keys?
SQL INDEX WITH ONLINE = ON