18,162 reputation
453102
bio website sqlperformance.com/author/…
location New Zealand
age 45
visits member for 3 years, 4 months
seen 20 mins ago

Jul
27
answered In Microsoft SQL Server 2008, syntax generates the error “The Parallel Data Warehouse (PDW) features are not enabled.”
Jul
26
answered MS SQL Server 2005 DB backup with partitioned tables to non-partitioned SQL Server 2012
Jul
25
answered Expanding a dataset based on a weight field
Jul
24
answered LIKE uses index, CHARINDEX does not?
Jul
24
answered sys.fn_varbintohexstr returns NULL if varbinary data is more then 2000 as datalength
Jul
13
answered Check existence with EXISTS outperform COUNT! … Not?
Jul
12
answered Polling for new records in a table
Jul
4
answered When SQL Server uses Multi Page Allocations
Jul
4
answered Can I tell SQL Server to “do something” when a connection is closed?
Jul
4
answered -E startup option and SSDs
Jul
3
answered Partitioning / indexing an extremely large table
Jun
21
answered What are safe characters to use in SQL Server Full Text Search?
Jun
20
answered Why does selecting top 1 from composite index DESC also used to partition by month not select the top value?
May
28
answered query processor ran out of internal resources and could not produce a query plan
May
28
answered What Problems Does an Eager Spool Indicate
May
22
answered Why do linked servers have a limitation of 10 branches in a CASE expression?
May
21
answered Is there any way to prevent the memo structure from being pruned?
Apr
28
answered Add Contents in a Column and make them 0
Apr
27
answered How to determine cause of runtime increase given two query plans with SpillToTempDb warning
Mar
10
answered Type conversion in expression may affect “CardinalityEstimate” in query plan choice?