Phil Parkin (9/27/2016)

---

Try to solve the various T-SQL problems that other people post here ... and compare your solutions with those written by others. You'll learn a lot if you...

They won't let me bring the bat to work...

Shared it on Twitter. I think a few people may have hurt themselves attempting to order one.

Ed Wagner (9/26/2016)

---

That's the direction I was thinking. It isn't really hiding, but filtering. If I inundated my boss with every little detail of everything that ever happened,...

xsevensinzx (9/26/2016)

---

Grant Fritchey (9/26/2016)

---

Thanks everyone for the feedback. I was hoping someone would come in and argue in favor of hiding information since it sometimes seems to be considered a...

dmbaker (9/26/2016)

---

Grant Fritchey (9/26/2016)

---

Thanks everyone for the feedback. I was hoping someone would come in and argue in favor of hiding information since it sometimes seems to be considered a...

kiwood (9/26/2016)

---

First, I agree that monitoring all the things that can go wrong should be done. And hiding things is generally a bad idea.

But let me play a little devil's...

Thanks everyone for the feedback. I was hoping someone would come in and argue in favor of hiding information since it sometimes seems to be considered a valid position.

If the issue is beyond someone's capabilities...

I would suggest setting up an Extended Events blocked process report. Here's a blog post[/url] on how to do it. You can also query sys.dm_exec_requests when the blocking is occurring...

If I can afford a full scan, that's better. Absolutely.

Mike Scalise (9/23/2016)

---

Actually, not to belabor the topic, but would it seem reasonable to update all (non-index) statistics as part of the maintenance plan?

So something like:

1) DBCC CHECKDB

2) Update all...

What was it? A startup trigger or something else?

Take a look at the SEQUENCE object. That's one way to have this without using IDENTITY. Plus, IDENTITY just using SEQUENCE under the covers anyway.

Actually, trivial plans are stored in cache. You...