OMG Ponies

top accounts reputation activity favorites subscriptions

Which is better: Bookmark/Key Lookup or Index Scan

sql sql-server sql-server-2005 tsql optimization asked Sep 8 '09 at 17:38

stackoverflow.com

20 votes

Indexed View vs Indexes on Table

sql sql-server sql-server-2005 tsql asked Aug 27 '09 at 19:34

stackoverflow.com

16 votes

SQL Server equivalent to Oracle's NULLS FIRST?

sql sql-server sql-server-2005 tsql asked Sep 21 '09 at 20:26

stackoverflow.com

15 votes

XML query() works, value() requires singleton found xdt:untypedAtomic

sql sql-server sql-server-2005 tsql xquery asked Aug 19 '09 at 19:15

stackoverflow.com

10 votes

Disc Brakes: Resurface your Pads?

maintenance disc-brake brake-pads asked Oct 23 '11 at 18:33

bicycles.stackexchange.com

8 votes

Death of Meta Tags revoked? Or why is there a beginner-guide tag?

support status-completed retag-request asked Feb 23 '11 at 17:07

meta.stackoverflow.com

7 votes

Benefits Of Using SQL Ordinal Position Notation?

sql sql-server oracle ordinals asked Feb 12 '10 at 15:53

stackoverflow.com

6 votes

Titanium bolts: Preventing bonding?

corrosion asked Oct 29 '11 at 3:34

bicycles.stackexchange.com

6 votes

Why haven't I received a tag badge and the Citizen Patrol badge?

support stackoverflow tag-badges asked Feb 10 '10 at 19:16

meta.stackoverflow.com

6 votes

Gaming the Question/Answer Editing

discussion reputation suggested-edits asked Jul 13 '11 at 6:58

meta.stackoverflow.com

Top Answers

129

SQL Server SELECT into existing table

stackoverflow.com

Select first row in each GROUP BY group?

stackoverflow.com

MySQL error: key specification without a key length

stackoverflow.com

What does =* mean?

stackoverflow.com

In MySQL queries, why use join instead of where?

stackoverflow.com

SQL Server: CASE WHEN OR THEN ELSE END => the OR is not supported

stackoverflow.com

How many rows in a database are TOO MANY?

stackoverflow.com

Why is SELECT * considered harmful?

stackoverflow.com

SQL Server: Can I Comma Delimit Multiple Rows Into One Column?

stackoverflow.com

Not equal <> != operator in T-SQL on NULL

stackoverflow.com

ROW_NUMBER() in MySQL

stackoverflow.com

Sql Server - INSERT INTO SELECT to avoid duplicates

stackoverflow.com

mysql too many indexes?

stackoverflow.com

mysql datetime comparison

stackoverflow.com

#1071 - Specified key was too long; max key length is 767 bytes

stackoverflow.com

How can I get the number of records affected by a stored procedure?

stackoverflow.com

Is there a combination of “LIKE” and “IN” in SQL?

stackoverflow.com

MySQL get row position in ORDER BY

stackoverflow.com

T-SQL - SET versus SELECT when assigning variables?

stackoverflow.com

SQLite Query in non case sensitive alphabetical order

stackoverflow.com

How do I Create a Comma-Separated List using a SQL Query?

stackoverflow.com

Use LIKE %..% with field values in MySQL

stackoverflow.com

Is the NOLOCK (Sql Server hint) bad practice?

stackoverflow.com

Delete sql rows where IDs do not have a match in another table

stackoverflow.com

Questions every good Database/SQL developer should be able to answer

stackoverflow.com

How do you use the “WITH” clause in MySQL?

stackoverflow.com

IndexOf function in t-Sql

stackoverflow.com

Update or Insert (multiple rows and columns) from subquery in PostgreSQL

stackoverflow.com

MySQL: Can't create table (errno: 150)

stackoverflow.com

How do you keep the order using SELECT WHERE IN()?

stackoverflow.com