The question could be slightly more specific. Backup compression existed before SQL Server 2008 R2 Standard Edition was released (it existed in SQL Server 2008 Enterprise).

Ben

Thanks Kevin,

The nice thing about using PBM or WMI like this for most DBAs is that you don't have to go around raising lots of change requests to install CPU-Z...

Ok an update: when I try with osql instead of SSMS it works. It seems SSMS overrides this setting unless you explicitly turn SET NOCOUNT ON in the query options...

Calvin Lawson (1/15/2010)

---

Thanks Ben, great idea for when you absolutely have to have those fast lookups with wildcards at the beginning of the search term. Which happens more often...

Peter Brase (1/13/2010)

---

Thanks for this, an excellent tip! I discovered that even if you skip the extra column and just run the reverse query, i.e., "where reverse(fieldname) like 'cba%'"...

peter-757102 (1/13/2010)

---

Note that indexes can only have a limited width (300 bytes or so , I believe).

Because of this, it makes sense to do a reverse of only the last...

Hi Varun.C,

Well spotted!

I have made the correction.

Many thanks,

Ben