Search Sciweavers | Sciweavers

24

VLDB
1999
ACM

107views Database» more VLDB 1999»

The Value of Merge-Join and Hash-Join in SQL Server

14 years 20 days ago

Microsoft SQL Server was successful for many years for transaction processing and decision support workloads with neither merge join nor hash join, relying entirely on nested loop...

Goetz Graefe

claim paper

Read More »

29

click to vote

VLDB
1997
ACM

124views Database» more VLDB 1997»

An Efficient Cost-Driven Index Selection Tool for Microsoft SQL Server

14 years 16 days ago

Download wwwiti.cs.uni-magdeburg.de

In this paper we describe novel techniques that make it possible to build an industrial-strength tool for automating the choice of indexes in the physical design of a SQL database...

Surajit Chaudhuri, Vivek R. Narasayya

claim paper

Read More »

29

click to vote

DEBU
2008

139views more DEBU 2008»

Testing SQL Server's Query Optimizer: Challenges, Techniques and Experiences

13 years 8 months ago

Download sites.computer.org

Query optimization is an inherently complex problem, and validating the correctness and effectiveness of a query optimizer can be a task of comparable complexity. The overall proc...

Leo Giakoumakis, César A. Galindo-Legaria

claim paper

Read More »

23

click to vote

VLDB
1998
ACM

121views Database» more VLDB 1998»

Hash Joins and Hash Teams in Microsoft SQL Server

14 years 18 days ago

Download www.vldb.org

The query execution engine in Microsoft SQL Server employs hash-based algorithms for inner and outer joins, semi-joins, set operations (such as intersection), grouping, and duplic...

Goetz Graefe, Ross Bunker, Shaun Cooper

claim paper

Read More »

22

click to vote

ICCBSS
2004
Springer

76views Software Engineering» more ICCBSS 2004»

Software Fault-Tolerance with Off-the-Shelf SQL Servers

14 years 1 months ago

Download www.csr.city.ac.uk

Peter T. Popov, Lorenzo Strigini, A. Kostov, V. Mo...

claim paper