Aaron Bertrand

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

sql server if block errors when running a stored proc inside - gives a syntax error
SQL Server execute stored procedure in update statement
How to detect which stored procedures UPDATE or INSERT into a certain TABLE?
Specify the parameter values part of sp_executeSQL as a parameter
SQL Delete query not working properly
SQL Server and Efficiency of Large Range of Values within an IN Clause
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