Nothing always works :-). FORCESEEK will result in a plan with a seek operation on the hinted table (or index...

Much of that 'information' is wrong. Might have been easier/better to have simply linked to BOL...

Application locks can be handy in all sorts of situations. One example that I use...

Hugo Kornelis (2/17/2012)

---

Can you explain what's going on? I played around a bit with the code. Adding an ORDER BY changes the results, of course - but the execution plan...

Hugo Kornelis (2/17/2012)

---

SQL Kiwi (2/17/2012)

---

John Mitchell-245523 (2/17/2012)

---

Got it right, but I think the answer should be "it depends". On what? The selectivity of the data in Col [...]...

It isn't true and there are many ways to disprove it. ...

John Mitchell-245523 (2/17/2012)

---

Got it right, but I think the answer should be "it depends". On what? The selectivity of the data in Col [...] Therefore, in the second...

In 2012 yes; the default shortcut is CTRL-Q, CTRL-I but that is customizable.

Or:

INSERT INTO period_dim (col1, col2, ..., coln)

SELECT ...

FROM ...

WHERE NOT EXISTS

(

SELECT 1

FROM dbo.period_dim WITH (HOLDLOCK)

WHERE years =...

I'm not sure I would agree. ...

shah.simmy (2/15/2012)

---

my table has 1 primary clustered key and 2 non clustered key.Now i want to rebuild cluster key,do i need to drop non clustered keys and rebuild ,or juts...

You beat me to it 🙂

A bit of a cheat, but:

SELECT

result =

...

This is an unreliable and unsupported construct, and should not be used or recommended:

CREATE TABLE #test (col1 tinyint, col2 char(5));

INSERT #test (col1)

VALUES (1),(2),(3),(7),(8);

DECLARE @sum...

It is certainly very good practice to match data types, but that is not the only way to obtain a seek here (assuming the default collation is a Windows one...