You can't, really. Where the data resides is a function of the engine and the default filegroup.

The best you can do for control purposes is to either create a...

Ville Lucander (9/11/2012)

---

Hello,

I'm setting up new ETL servers and I might need to install both 2012 and 2008 clients. Because I can't read 2000 server OK with 2012 atleast so...

I can't see your example. Can you post it another way?

Another thing I thought I learned and found out I didn't.

Thanks, Ravi.

Okay. That makes sense.

I guess the next question is, is there any method of prediction on lock types or does it literally just come down to what the engine is...

GilaMonster (9/10/2012)

---

No. The optimiser knows nothing about...

Ah. Thank you for pointing that out.

It would be easier for us to answer that question if you posted the requested DDL and sample data. The sample data doesn't have to be real. You can fake...

And apparently I don't remember how to read this morning. DUH.

Good catch.

Post your table DLL, an INSERT statement with sample data, and what you've written on the CTE. That will help us help you better.

I think I have found my issue. Details in this post: http://www.sqlservercentral.com/Forums/Topic1356750-391-1.aspx?Update=1

Anyone can answer if they still wish to, but I think I found my issue.

Estimated Plan pointed out some index seeks. I googled locks and indexes and stumbled across the...

sstteevvee22 (9/10/2012)

---

Here is my query:

SELECT dbo.RHeads.Branch, dbo.RLines.Part, dbo.Stock.Free AS [On Hand], dbo.RLines.CQty AS [Qty Last Received],

dbo.RHeads.DateTime AS Date,

...

Look up Common Table Expressions in Books Online. That's precisely what it was created for.

http://msdn.microsoft.com/en-us/library/ms190766(v=SQL.105).aspx

Check out this thread. I bet you have the same issue.

http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/f127d838-4a45-49bc-b925-d08886f066f9

I found it by googling your error message.