That's a problem. The default is 2000 TB. It's fine if the server has over 2000 TB of memory, but if...

Please say that's not the real password...

Other than possibly a nonclustered index on B.NANUM, not really much you can do.

What do you mean, you've set SQL's memory to max?

One other thing Melanie, unless there's more to the code than you've shown, the temp table isn't needed at all. This should be more efficient

SELECT '-1' AS EmpLogin, 'Please Select'...

Kristen-173977 (10/9/2015)

---

Your saying that made me wonder if it would be better just to add a unique number using ROW_NUMBER() OVER rather than IDENTITY - maybe it would be less...

Not a template, but...

Open Object explorer, navigate to a table/view, Drag the 'columns' folder to your query window.

SQLPrompt does all the column generation for inserts and selects. It's not free,...

Kristen-173977 (10/9/2015)

---

I'm sure you know this, but in case not: you can add an IDENTITY to a SELECT ... INTO #TempTable :

SELECT

[highlight="#ffff11"]MyID = IDENTITY(int, 1, 1),[/highlight]

EmpLogin,

AttorneyName = LastName + ',...

Ola's scripts create jobs, and Express does not...

Even in 2008, you could and would at some point get different ordering, since there was no order by on the outer select.

http://www.red-gate.com/community/books/accidental-dba

It was written for 2008, so a little out of date, but still very good.

That said, I suspect you left something out, as the original query, on SQL 2008 R2, returns

Msg 1033, Level 15, State 1, Line 15

The ORDER BY clause is invalid in...

You have no order by on that original query, so SQL is under no obligation to return the data to you in any particular order. I suspect the QO is...

Jack Corbett (10/8/2015)

---

WayneS (10/7/2015)

---

GilaMonster (10/6/2015)

---

#gloat Company's paying for the trip to the US. If I was speaking at Pass Summit, they'd be paying for hotel too. They paid...