19,696 reputation
457109
bio website sqlperformance.com/author/…
location New Zealand
age 45
visits member for 3 years, 6 months
seen 9 hours ago

Aug
23
answered Dividing DBCC CHECKDB over multiple days
Aug
22
answered Optimizing complex join predicates
Aug
21
answered Msg 1833, File 'ABC.ndf' cannot be reused until after the next BACKUP LOG operation
Aug
21
answered Does the order of columns in a PK index matter?
Aug
17
answered Equivalents to `ora_rowscn` in other databases?
Aug
14
answered Distributed transaction and Read Committed Snapshot
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