Great article. And nice example use of bitmask for searching.

If you approach the bitmask column for the purpose of high frequency searching, really for "reporting" then it does...

...Mirroring is one of those features.

Sure you might have known about it, but until you get it going, and realize, how little effort it really takes, and the comfort...

That's why you need an automated script. in a 24/7 shop, it does not make sense to do manual checks. Automate the process, that includes checking the level of defrag....

Are you saying that for the same product, it is different depending on the year?

if so, then you might want to look into how to manage slowly changing dimensions.

If...

For 24/7 systems, I highly recommend running a defrag at least daily. And I've had some databases that really needed it done more frequently.

If you have a solid procedure,...

Great article. Looks like for now, TDE is a one way process. Select wisely!

Thanks for a great review. For those of us who have been using sysprocesses as well as sp-who, sp_who2 for along time, it never hurts to have a review....

Great write up. Thanks for taking the time. Your Organizational Culture comment really caught my eye, such as:

This was so contrary to the corporate culture and belief system...

Have to agree, set based should be the required standard, with using server side cursor requiring an explaination as to why a set based approach is not warranted.

Folk legend has...

It's great! the next great villian... Plunderpal.

What started as a science experiment, PlunderPal soon realized its own AI, and broke free from human control. It then began...

Alex,

Nice article and thanks for taking the time to write this up.

And while SSRS's multi-valued approach is a bit laking, I think we all would choose having this option over...

Follow up:

Let's all thank Drew for the contribution. Monitoring is a necessary, but a neglected topic.

Getting a centralized monitoring server is a real must, even for smaller shops.

For those...

Step One - get a server.

Most people need to see it to believe it. No matter what the topic.

So, rather than spend time justifying a new server, I take the...

A big thanks to Brian, and all the others that give back and contribute. Contributing to make society a better place takes many forms. And thankfully, I see signs that...

This sounds like it could have many uses. Thanks for the contribution.