Aaron Bertrand

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

Loop through table and update a specific column
Using BETWEEN clause
Estimated execution plan show needed indexes?
Dynamic sql variable issues need fixing
Cannot create CLUSTERED INDEX on a View due to LEFT JOIN or subquery
Connecting to SQL Server Named Instance from Windows 64bit
Deleting multiple rows based on row number(s)
How can I insert data from SQL Server to SQL Azure?
Setting SCHEMABINDING and IsDeterministic for a CLR function
ExecuteNonQuery leaves a sleeping awaiting command session