null
Loading…
Skip to main content Skip to buy box

Holiday gifts by Fri, Dec 18? Order by Thu, Dec 3. Plan gifts Gifts by Dec 18? Order by Dec 3. Plan

Free shipping on most orders over $95 in the contiguous US

Specialists Mon–Fri, 8:30 am–5 pm PTSpecialists Mon–Fri, 8:30–5 PT866-522-6657

Printed to order
Analytics Optimization with Columnstore Indexes in Microsoft SQL Server: Optimizing OLAP Workloads
Paperback

Analytics Optimization with Columnstore Indexes in Microsoft SQL Server: Optimizing OLAP Workloads

by Edward Pollack

From $48.99 / copy at 25+ copies; lower per-copy prices at higher quantities (see Volume pricing) As low as $43.39 at 1,000+

Total $1,224.75

Paperback · 280 pages Apress · 2022

Format

Paperback
Volume pricing

The more copies, the less each one costs

Applied automatically in your cart. No code needed.

More than a box of books

Turn this order into a program

Groups that order together often pair the copies with something more. We handle the extras so you don't have to.

About the book

Analytics Optimization with Columnstore Indexes in Microsoft SQL Server

Meet the challenge of storing and accessing analytic data in SQL Server in a fast and performant manner. This book illustrates how columnstore indexes can provide an ideal solution for storing analytic data that leads to faster performing analytic queries and the ability to ask and answer business intelligence questions with alacrity. The book provides a complete walk through of columnstore indexing that encompasses an introduction, best practices, hands-on demonstrations, explanations of common mistakes, and presents a detailed architecture that is suitable for professionals of all skill levels. 

With little or no knowledge of columnstore indexing you can become proficient with columnstore indexes as used in SQL Server, and apply that knowledge in development, test, and production environments. This book serves as a comprehensive guide to the use of columnstore indexes and provides definitive guidelines. You will learn when columnstore indexes shouldbe used, and the performance gains that you can expect. You will also become familiar with best practices around architecture, implementation, and maintenance. Finally, you will know the limitations and common pitfalls to be aware of and avoid.

As analytic data can become quite large, the expense to manage it or migrate it can be high. This book shows that columnstore indexing represents an effective storage solution that saves time, money, and improves performance for any applications that use it. You will see that columnstore indexes are an effective performance solution that is included in all versions of SQL Server, with no additional costs or licensing required. 



What You Will Learn

  • Implement columnstore indexes in SQL Server
  • Know best practices for the use and maintenance of analytic data in SQL Server
  • Use metadata to fully understand the size and shape of data stored in columnstore indexes
  • Employ optimal ways to load, maintain, and delete data from large analytic tables
  • Know how columnstore compression saves storage, memory, and time
  • Understand when a columnstore index should be used instead of a rowstore index
  • Be familiar with advanced features and analytics


Who This Book Is For

Database developers, administrators, and architects who are responsible for analytic data, especially for those working with very large data sets who are looking for new ways to achieve high performance in their queries, and those with immediate or future challenges to analytic data and query performance who want a methodical and effective solution



Details

Publisher
Apress
Author
Edward Pollack
Format
Paperback
Published
Feb 27, 2022
ISBN-13
9781484280478
Pages
280
Printing
Printed on demand
Buying for a group

Analytics Optimization with Columnstore Indexes in Microsoft SQL Server for groups: pricing

Volume pricing applies automatically in your cart. No codes, no account needed.

CopiesPrice per copyYou save
25 – 99 $48.99 30% off list
100 – 249 $47.59 32% off list
250 – 499 $46.19 34% off list
500 – 999 $44.79 36% off list
1,000+ $43.39 38% off list
Ways groups use it

Popular for

1
Book clubs

A copy for every member, on one order.

2
Events and conferences

A book for every attendee, delivered to your venue.

3
Gifts

For clients, staff, members or volunteers.

Where can I buy 100 copies of Analytics Optimization with Columnstore Indexes in Microsoft SQL Server?

BookPal sells Analytics Optimization with Columnstore Indexes in Microsoft SQL Server in quantity. At 100 copies the price is $47.59 a copy, against a list price of $69.99, and the cart applies the volume tier automatically. Free shipping on most orders over $95 in the contiguous US. A specialist can quote a larger or mixed order.

  • New books only, straight from the publisher
  • Volume prices apply automatically in the cart, with no code needed
  • Order at least 10 business days before you need the books (11 from mid-November through December)

Ask a specialist about a larger or mixed order

What does Analytics Optimization with Columnstore Indexes in Microsoft SQL Server cost when I buy for a group?

Volume pricing applies automatically in your cart, with no code needed. Price per copy: 25 to 99 copies, $48.99 (30% off list); 100 to 249 copies, $47.59 (32% off list); 250 to 499 copies, $46.19 (34% off list); 500 to 999 copies, $44.79 (36% off list); 1,000+ copies, $43.39 (38% off list). Need a different quantity, or a quote to forward for approval? Ask a specialist and we will confirm pricing before you pay.

How fast can I get copies of Analytics Optimization with Columnstore Indexes in Microsoft SQL Server?

This title is printed on demand, so it needs production time before it ships. Need them by a specific date? Request a quote and we'll confirm timing before you pay.

Can you ship to several locations or people's homes?

Yes. We ship group orders to one address, to multiple sites, or to individual recipients, in the US and internationally. See fulfillment options.

Can I get a formal quote for approval before ordering?

Yes. Request a quote and we'll send a PDF you can forward for approval.

Do you accept purchase orders and tax-exempt orders?

Yes. We accept purchase orders upon approval, as well as cards, PayPal, ACH, wire transfers and checks. BookPal is a tax-exempt supplier in all 50 states. See purchase orders and sales tax exemption.

What if I find a lower price?

Send us the link. We match prices from other booksellers and distributors on a new copy in the same edition, available to ship in the quantity you need. Clearance sales and pricing errors are the exception, and we'll tell you quickly if that's the case. Start a price match.

Send for approval

Get a yes from your approver

Analytics Optimization with Columnstore Indexes in Microsoft SQL Server: Optimizing OLAP Workloads
Email it to my approver

Your approver gets a link to this page with the quantity set and an "Approve and order" button. Nothing is sent until you press send in your email app.

Log In
Review Your Cart
Your cart is empty Your cart is empty Your cart is empty

Menu

Recently Viewed Recently Viewed
Back to top Back to top