We can compensate for badly written code with more badly written code. Excellent plan.

Correctly terminate all statements with a semicolon (they're statement terminators). The end.

If someone did not correctly...

!Gah !No

.A semicolon is a statement *terminator* .It is not something that gets placed at the beginning of...

Then you may just have to re-implement the code from Proc 1.

In procedure 1, create three temp tables. In procedure 2, insert into those temp tables. Back in Procedure 1, use...

It would need to be a temp table, because table variables have a scope of the current procedure only,...

You can't change the default trace.

What you can do is turn the default trace off and create your own trace which logs what you want. I recommend using Extended...

TomThomson (12/1/2015)

---

For a serious chunk of software, you need to star from "write five dozen tests" - and then use the one (ones if you are lucky) that tells you...

Caching's typically done either in the application server or a cache between the app server and the DB. Caching's not something you can just plug in and go, you need...

To be honest, I'd suggest debugging the backup solution. Transfer's not something that I'd recommend using except for downgrading a database. It's also a lot slower than backup/restore (it scripts...

You'll probably find the time difference to be utterly meaningless and under the error range for measuring duration of statements. Worrying about a couple microseconds here or there is likely...

No.

I said if there is no existing index on the Detail table on MasterID, create one on...

Ok, so either run the purging in quieter times, or in smaller chucks or fix the query and indexing problems that's causing queries to be slow.

Ah, I thought it was the other way around. Ignore them (they're harmless except for causing checkDB to fail) or rebuild the DB (script, export, recreate).

What object has an ID of 12331604?

And check all the other IDs being reported from CheckDB too.

If the trace shows it's coming from SQL, then it's coming from SQL. It's not bogus, the trace is telling you what application name the client is passing. Is there...