Phil Sandler

234 reputation

bio	website	psandler.wordpress.com
	location	Chicago, IL
	age	43
visits	member for	1 year, 3 months
	seen	yesterday
stats	profile views	13

Senior Software Architect working in the Chicago area.

	234 reputation	bio	website	psandler.wordpress.com	visits	member for	1 year, 3 months
16 badges		location	Chicago, IL		seen	yesterday

summary answers questions tags badges favorites bounties reputation activity

25 Actions

suggestions reviews revisions comments badges posts accepts all

2d	asked	BI and Self Service Reporting Tools that Support Web (HTML) Interface?
Apr 20	accepted	How Should I Configure Memory for Multiple Instances of SQL Server?
Apr 19	asked	How Should I Configure Memory for Multiple Instances of SQL Server?
Feb 10	awarded	Yearling
Dec 29	accepted	Proper Index for WHERE X <> 1 AND Y <> 1 ORDER BY Z
Dec 29	awarded	Editor
Dec 29	revised	Proper Index for WHERE X <> 1 AND Y <> 1 ORDER BY Z added 255 characters in body
Dec 29	comment	Proper Index for WHERE X <> 1 AND Y <> 1 ORDER BY Z Can't legally post DDL, otherwise I would have. However, I tried Martin's example and it got me scratching my head. The generated query was actually not doing "m.IsFlag1 = 0", it was doing "m.IsFlag1 != 1". Still not completely clear on why that would cause a sort, but in any case I see where I was going wrong.
Dec 28	asked	Proper Index for WHERE X <> 1 AND Y <> 1 ORDER BY Z
Sep 25	comment	Investigating/Troubleshooting I/O Spikes The SAN admin is showing us IOPS data, which I think would be quantity? We are seeing performance degradation, which is why we started looking into it, which I would imagine also indicates latency issues.
Sep 25	asked	Investigating/Troubleshooting I/O Spikes
Jul 17	awarded	Supporter
Jul 17	accepted	SQL Server: Effect of Setting These Index Options
Jul 16	asked	SQL Server: Effect of Setting These Index Options
Mar 16	asked	Reindex Task Failing Randomly
Mar 10	awarded	Scholar
Mar 10	accepted	Activity Monitor Showing Long Duration for WAITFOR
Mar 2	asked	Activity Monitor Showing Long Duration for WAITFOR
Feb 12	awarded	Student
Feb 11	comment	SQL Server: Duplicate Index Question Thanks Martin. Could you provide a link as to how to do that? Put it as an answer in case it's right? :)