Paul White (6/7/2009)

---

2. The algebrizer checks the objects you have referenced and also that what you are asking for makes semantic sense (you can't execute a view for example)....

Does the SQL Server service account have full rights to the database files? The error implies that it doesn't.

SQL goes through three stages before executing the query. Parse, algebratise and compile. All three operate on the entire batch, regardless of whether the statements will actually run or not....

RBarryYoung (6/6/2009)

---

Though honestly, I've been finding both of these sites increasingly frustrating. The flaws of the "points for 'best' answers" systems they use becomes more evident the more I...

It's not your select that's the problem. You've got some orphaned DTC transactions that are holding locks.

To get rid of the locks, query sys.dm_os_tran_locks for rows where the requesting session_id...

Partial database availability (Enterprise edition only), read-only filegroups.

You can put files onto different drives, but you cannot specify that a table or index must be created in a specific file,...

Paul White (6/6/2009)

---

Understood. Though there may be practical considerations (probably pork related) which mean that removing/changing certain widely-used undocumented features is unlikely in the extreme. No guarantees of...

It does matter. That link's...

Paul White (6/6/2009)

---

Absolutely. I love it when someone brings up the 'if you use undocumented features your wife will leave you' type of argument, for exactly those reasons. ...

FreeHansje (6/6/2009)

---

I have suggested indices on the c1-c4 columns, my collegue told me they have removed those indices 6 months ago and so achieved a big performance boost. Maybe...

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic730231-146-1.aspx

Much appreciated.

Paul White (6/6/2009)

---

Having said all that, I do have some sympathy. And not just because of the (presumed) language barrier.

The requirement to alias a table variable for UPDATE is...

I know. Those darned updates are just so hard to understand. :hehe:

Correct link -...

Lynn Pettis (6/5/2009)

---

GilaMonster (6/5/2009)

---

Lynn Pettis (6/5/2009)

---

What I am thinking of doing in the future when I suggest to OP's to read Books Online is to add an additional statement that...