19,055 reputation
456107
bio website sqlperformance.com/author/…
location New Zealand
age 45
visits member for 3 years, 5 months
seen 1 min ago

Aug
3
answered How to improve TempDb on RAMDisk showing performance on par with physical hard drive
Aug
3
answered How to optimise T-SQL query using Execution Plan
Jul
31
answered DBCC CHECKDB unfixable corruption: Indexed view contains rows that were not produced by the view definition
Jul
31
answered How to merge data sets without including redundant rows?
Jul
31
answered How to select from a table without including repeated column values?
Jul
30
answered How does SQL Server know predicates are correlated?
Jul
30
answered Full text query slow on first run
Jul
28
answered Updating a table efficiently using JOIN
Jul
27
answered Query tuning help needed (Hash Match and Table Scans)
Jul
27
answered Help with SELECT queries
Jul
27
answered Workaround for Anti-Semi Join bug
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?