How does a procedure have a USE statement inside it?

CREATE PROCEDURE Test

AS

USE master

SELECT * FROM...

🙁 EVE hasn't taken over my life. Not entirely anyway. 🙂

But I...

Why do you need to rename your objects? Do you have a naming standard that requires the server name to be part of table or procedure names?

The Dixie Flatline (7/8/2014)

---

Wolfkill needs to know if there are tanks in EVE Online, as well as bombers.

Tanks are very important. ...

Object explorer. Right click the DB, select the Files tab. Yes, it is advisable to change it if badly set.

Basically, buffer pool. SQL caches data in memory and works off that. It won't go to disk unless what it needs is not in the buffer pool.

You got lucky. If...

The function CallbackService_ufn_GetCallerData throws an error?

What's the definition of the function?

You can't parameterise table or column names. You'll have to build up the string with those values in (and beware SQL injection vulnerabilities)

Fail as in throw an error? Fail as in give incorrect results? Fail as in the server self-destructs?

No. It has one row for each index which has been used since SQL last started. If...

Not really much you can do other than remove the need to sort entirely, and that may not be acceptable. Sort needs a lot of workspace memory so it tends...

What operator?

From the Stack Overflow link:

Email...

C2 audit enabled?

Giova (7/7/2014)

---

I'll try to rise the parallelism threshold but I have hundreds of queries with incredible costs ( more or less, 50/60 have a cost between 10.000 and 15.000). So...