Aaron Bertrand

Aaron Bertrand has asked 2 questions and find answers to 724 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

retrieve the most recent record for each customer
Finding all views that are using linked server
Different result running a query in SQL Server and from C#
Calculate rank based on Consecutive Dates (Return to 1 if there is a gap days between dates)
group by in sql combining values [closed]
SQL Server check constraint failing on correct input
Keyword search with SQL Server
Using RTRIM in JOIN condition
Getting most recent distinct records
Adding one more join kills performance