memory_consumer_id bigint Internal ID for memory consumer. memory_consumer_type int An integer that represents the type of the memory consumer with one of the following values: 0 - Shouldn't be ...

Ask the publishers to restore access to 500,000+ books. Can You Chip In? We’re celebrating our 1 trillionth archived web page. If you find our library useful, learn how you can help us fundraise! Can ...

This script enumerates all SSAS databases and backups them using a MSOLAP linked server. Especially usefull if your BI dudes don't allways tell the DBA they added a new SSAS database, but *do* expect ...

I realized how much easier my life would be if SQL had a mode() aggregate function. (I'm using it in the mathematical sense). I'm guessing that either I use SQL in a wierd way or there is a good ...