(Steve Herbert) One of the least understood Query Execution operators is the Bitmap. I’d like to give a fairly brief overview of how Bitmap filters are used, as well as some technical details about their limitations and functionality. Bitmap filters are often mistaken as Bitmap indexes. The two a

(Gregory A. Larsen) When dealing with data you run into all kinds of different situations. For each different occurrence you might need to have a different technique to produce the results you require. Last month I discussed a couple of different comma separated data situations. This month I will de

(Pop Rivett) A lot of people come up to me and say, “Pop, you’ve been around a bit, how do you ensure that your standby SQL Server is always in synch with your production one?” Usually I sigh wearily and tell them that it takes a lifetimes experience and a natural flair for the task, and would take

(Jeremy Kadlec) Data warehouses are typically the largest databases at any organization. Building and managing systems is a large undertaking and these projects can quickly become unwieldy with numerous users providing incompatible input. Boosting the system’s query performance is possible but takes