Paul White

less info
meta site favicon meta user | stack exchange network profile network profile
8,205 reputation
2459
bio website sqlblog.com/blogs/paul_white/…
location New Zealand
age 43
visits member for 2 years, 2 months
seen 19 mins ago
stats profile views 1,386

Rockstar Blogger SQL ServerMVP

Blog: SQLblog.com Twitter: @SQL_Kiwi


1,491 Actions

suggestions reviews revisions comments badges posts accepts all
23h
 comment Is there any way to prevent the memo structure from being pruned?
@JonSeigel We could discuss it in chat or by email some time if you like.
1d
 awarded  Nice Answer
1d
 reviewed Reviewed Does an index with multiple columns make a similar index redundant?
1d
 comment Is there any way to prevent the memo structure from being pruned?
@JonSeigel My answer is a qualified 'yes' to all of those :)
1d
 comment How to get a row_number to have the behavior of dense_rank
Is there a reason you want to use CASE rather than IF or dynamic SQL?
1d
 answered Why do linked servers have a limitation of 10 branches in a CASE expression?
2d
 awarded  Nice Answer
May
21
 answered Is there any way to prevent the memo structure from being pruned?
May
20
 awarded  Constituent
May
14
 awarded  Caucus
May
11
 reviewed Close Queries getting stuck on very simple COUNT queries
May
11
 reviewed Reviewed Oracle Hangs on Book Order Process
May
8
 reviewed Edit Can't login phppgadmin
May
8
 revised Can't login phppgadmin
added 23 characters in body
May
8
 reviewed No Action Needed ERD diagram may or may not statement
May
8
 reviewed Reviewed Restrict access for Windows administrator in PostgreSQL
May
8
 reviewed Close While restoring copy of SQL Server 2008 backup file in SQL Server 2008 R2 degraded performance
May
8
 reviewed Leave Open How to group by the data by monday to sunday as a week?
May
8
 reviewed Close Retrieve 5th highest salary in table
May
8
 reviewed Reviewed How to group by the data by monday to sunday as a week?
1 2 3 4 5 … 75