EVE Online

That's one of his more comprehensible posts.

CXPacket is not a problem. CXPacket is a sign that you have queries running in parallel, nothing more. Since as soon as a query goes parallel there's a controller thread...

Restore from backup. then check your IO subsystem for problems.

For anyone that gets frustrated with our posters here, here's a quote from a poster over on a gaming forum...

I was thinking about reactivating my bomber but it occurred to...

TheSQLGuru (7/7/2014)

---

TSQLLearner2014 (7/7/2014)

---

Given the situation where we had to put a hot fix asap... This worked brilliantly. We have now time to fine tune the code.

I will now try using...

It's several caches including plan cache and data cache.

Max server memory sets the size of the buffer pool. SQL can and does use a small amount of non-buffer memory in addition to that.

I love it when someone asks for the differences between two completely disparate things....

Errrr.... Asking for the similarities would result in a much shorter list, an empty one.

Update statistics is a command which you can run to update the statistics which record data...

Worst case, you go to restore a diff and SQL tells you that it's the wrong one, so you get the correct one and restore that.

Practice with scripts, the GUI...

Sean Lange (7/7/2014)

---

info 58414 (7/7/2014)

---

Hi,

in a StoredProc I want depending on whether a parameter is passed formulate the Where clause accordingly.

If parameter IS NOT NULL

...

Grant Fritchey (7/7/2014)

---

After you restructure it as was suggested already, this needs to be addressed:

(RTRIM(pc.CODE))

That will lead to scans which will seriously hurt performance. You shouldn't have functions on...

It doesn't matter if they run simultaneously.

If you really don't want the full & diff to run at the same time (only one that makes sense to worry about), then...

Then don't waste your time looking at partitioning. Indexing along with tuning the queries should be your approach there.

No.