Vince Pergolizzi

211 reputation

	211 reputation	bio	website	vincepergolizzi.com	visits	member for	1 year, 3 months
11 badges		location	London		seen	Jun 1 '12 at 8:26

9 Actions

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