DBA Rafi (1/30/2012)

---

Dears, I knew the problem of dirty-reads with 'WITH (NOLOCK)', but I heard from few people

saying putting NOLOCK is not a good practice sometimes.

As i was not...

jethrojet (1/30/2012)

---

I got a Table named ORDER_LINE and it has plenty of columns. One of them are CBM1 and CBM2. CBM1 is linked to a software and I cannot touch...

Any update that changes an...

Another example:

WITH

-- On the fly numbers table

N1 AS (SELECT N1.n FROM (VALUES (1),(1),(1),(1),(1),(1),(1),(1),(1),(1)) AS N1 (n)),

N2 AS (SELECT...

Shcherbunov Neil (1/29/2012)

---

The question is: what will be different if I use Turkish_BIN? Hungarian_BIN? Latin1_General_BIN? They all use the same algorithm: compare the byte value of char (code in ASCII...

XploreBI (1/29/2012)

---

This reminded me of a post some time ago by Marc Friedman where he talks about distinct aggregations and table spools. I took Paul’s solution and applied it (or...

LutzM (1/28/2012)

---

If the number of rows is really representative (a few hundred at max)...

Opinions vary on this, but my own view is that it is only worth creating extra equally-sized tempdb files if you are experiencing allocation contention. Some people prefer to...

Details help very much with this sort of question. As a minimum, please provide actual execution plans (*.sqlplan files) for quick and slow runs. Output from STATISTICS IO...

There is no one right answer to this...

Well new table A and new table B can be CROSS JOINed to give old table A...

Aha! Thanks for letting me know, I'll remember that.

Could be, I...

jbhatt2 (1/27/2012)

---

But I'm not quite getting round to what I require.. basically I have a Table A, Table B as example below and Table C should read as below. ...

The one at the end is awesome.