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

114 Posts

suggestions reviews revisions comments badges posts accepts all

Feb 16	answered	LIKE character length limitation
Feb 14	answered	How can I make sure the SQL Server query optimizer uses the exact tables in the query
Feb 11	answered	32-bit ODBC driver on 64-bit SQL Server
Feb 6	answered	Getting Identity values to use as FK in an INSTEAD OF trigger
Feb 6	answered	SQL Server Deadlock on two updates due to index lock order
Jan 29	answered	Parameter Sniffing vs VARIABLES vs Recompile vs OPTIMIZE FOR UNKNOWN
Jan 29	answered	Returning rows where all non-NULL values are equal
Jan 27	answered	Index included columns
Dec 22	answered	Optimising plans with XML readers
Dec 21	answered	Query taking too much time
Dec 20	answered	Index fragmentation and SSD disks
Dec 20	answered	Transposing data
Dec 20	answered	Finding longest matching prefix
Dec 18	answered	Improve performance of query using IN()
Dec 18	answered	MERGE a subset of the target table
Dec 14	answered	avoid insert xml duplicate data
Dec 14	answered	Performance tuning a cascading delete with many foreign keys
Dec 13	answered	Slot Array and Total Page Size
Dec 13	wiki	created database-internals excerpt
Dec 13	answered	NEWID() In Joined Virtual Table Causes Unintended Cross Apply Behavior

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