211 reputation
11
bio website vincepergolizzi.com
location Boston, MA
age 25
visits member for 2 years, 7 months
seen Jul 30 at 16:46

Jan
31
awarded  Yearling
May
12
comment TSQL performance - JOIN on value BETWEEN min and max
How many rows do you have in each table? I would like to reproduce the scale of your problem on my DB and try to solve without adding an index :)
May
11
answered Is it better to populate variables using SET or SELECT?
May
11
answered TSQL performance - JOIN on value BETWEEN min and max
May
11
answered Naming question for functions: implicit or explicit naming of grouping in function name
Mar
1
comment Is there a setting to force an error when asigning a varchar longer than a variable?
Silent truncation doesn't raise a SQL Server error (hence the name) so you will have to do the error handling within the code.
Mar
1
answered Is there a setting to force an error when asigning a varchar longer than a variable?
Feb
21
awarded  Teacher
Feb
21
answered Very slow performance from MySQL