Paul White

less info

network profile

8,405 reputation

2662

bio	website	sqlblog.com/blogs/paul_white/…
	location	New Zealand
	age	43
visits	member for	2 years, 3 months
	seen	3 hours ago
stats	profile views	1,471

Rockstar Blogger SQL ServerMVP

Blog: SQLblog.com Twitter: @SQL_Kiwi

summary answers questions tags badges favorites bounties reputation activity

103 Answers

votes activity newest

33	Unexpected scans during delete operation using WHERE IN
27	Execution plan shows expensive CONVERT_IMPLICIT operation. Can I fix this with indexing or do I need to change the table?
21	Does SQL Server read all of a COALESCE function even if the first argument is not NULL?
20	DELETE vs TRUNCATE
18	SQL query for combinations without repetition

view more

8,405 Reputation

+20	query processor ran out of internal resources and could not produce a query plan
+10	Why is this query not using my nonclustered index, and how can I make it?
+10	Why won't SQL Server optimize the UNIONs?
+10	Parameter Sniffing vs VARIABLES vs Recompile vs OPTIMIZE FOR UNKNOWN

view more

0 Questions

votes activity newest

This user has not asked any questions

85 Tags

536 sql-server × 77	68 query-performance × 7
140 sql-server-2008 × 24	65 t-sql × 10
133 sql-server-2008-r2 × 13	60 execution-plan × 6
129 sql × 23	60 optimizer × 5
87 sql-server-2012 × 14	45 query × 3

view more

5 Accounts

	Database Administrators	8,405 rep	2662
	Stack Overflow	1,851 rep	619
	Server Fault	101 rep	2
	Super User	101 rep	2
	Meta Stack Overflow	101 rep	2

41 Badges

recent class name

Necromancer × 3	Reviewer × 2
Nice Answer × 22	Proofreader
Revival × 5	Good Answer × 2
Constituent × 2	Yearling × 2
Caucus × 2	sql-server-2008

view more

0 Active bounties

active offered earned

This user has no active bounties

976 Votes Cast

all time			by type			month		week
771	up		357	question		18		8
205	down		619	answer		18		8

Technology			Life / Arts	Culture / Recreation	Science	Other
Stack Overflow Server Fault Super User Web Applications Ask Ubuntu Webmasters Game Development TeX - LaTeX	Programmers Unix & Linux Ask Different (Apple) WordPress Answers Geographic Information Systems Electrical Engineering Android Enthusiasts IT Security	Database Administrators Drupal Answers SharePoint User Experience Mathematica more (14)	Photography Science Fiction & Fantasy Seasoned Advice (cooking) Home Improvement more (13)	English Language & Usage Skeptics Mi Yodeya (Judaism) Travel Christianity Arqade (gaming) Bicycles Role-playing Games more (21)	Mathematics Cross Validated (stats) Theoretical Computer Science Physics more (7)	Stack Apps Meta Stack Overflow Area 51 Stack Overflow Careers

site design / logo © 2013 stack exchange inc; user contributions licensed under cc-wiki with attribution required

rev 2013.6.18.748

Database Administrators Stack Exchange works best with JavaScript enabled