DBA From The Cold (6/30/2015)

---

Hey guys, going a bit off topic here but would like some advice please as I know pretty much all of you are writers/bloggers.

I've had a...

Congrats Alan. That's awesome.

Put in a feature request.

Unfortunately, there isn't an alternative to CHARINDEX and LTRIM. You need to not use functions, at all, of any kind, on your columns. If your data requires you to pull...

What Kevin is referring to is this:

LTRIM(P.partnerSqlId) + '-' + LTRIM(P.partnerIncId) = @PartnerKey

That is going to destroy your performance and there's no way around it. You need to remove the...

Please don't cross post into multiple forums. Most of the people answering questions here read across many of the forums. Cross posting just leads to confusion as different people answer...

better than what? I've reformatted it so that it's more readable and use the IFCode Shortcuts in the post screen of this website to highlight it as SQL.

SELECT a.emp_id,

...

SPOILERS....

Alvin Ramard (6/26/2015)

---

Grant Fritchey (6/26/2015)

---

Alvin Ramard (6/26/2015)

---

Any maintenance plans you're running that look at all online databases would have less work to do if you took those databases offline. That...

Alvin Ramard (6/26/2015)

---

Any maintenance plans you're running that look at all online databases would have less work to do if you took those databases offline. That might help if you...

Any plans or data in cache would be removed. But, if they're not being accessed, then the standard processes within SQL Server would also remove them over time, so... it's...

Nope. Nor should you want to. Gathering the extra bits of data that separate an actual plan from an estimated plan can be costly. You can quickly pull the plan...

For those who do read on the Kindle, if you're ever desperate for a new book, in trouble with the significant other over money spent, or are just interested in...

Glad to hear it worked out. Sorry I couldn't be specific. To help troubleshoot this in the future, capture the execution plan now while the query is running fast. Then,...

yb751 (6/25/2015)

---

SQLBill (6/25/2015)

---

Brandie Tarvin (6/25/2015)

---

So... at risk of alienating a potential fan base for my own ensemble-cast novel-in-progress.

Why did you hate his books (aside from him killing off favorite characters)?

Was...