Recently on Twitter I saw a question about what index maintenance you should be doing on your ColumnStore Indexes when it comes to maintenance. As I looked through DCAC’s blog posts I realized that none of us had blogged about this topic before.
The reason for this is pretty basic, there’s really nothing to do when it comes to maintenance on a ColumnStore index.
Normally we do maintenance on indexes to reduce fragmentation, but there’s no fragmentation on ColumnStore indexes as the data isn’t stored on the table in a sort order. Data pages that aren’t needed anymore are removed automatically (the same with dictionary pages). The other big thing that index maintenance does, it update statistics on indexes. Well, there are no statistics on ColumnStore indexes, so there are no statistics to maintain. Why aren’t their statistics? Because every operation is a scan of a ColumnStore index. Since everything is a scan, there’s no need for statistics.
The post Database Maintenance and ColumnStore Indexes appeared first on SQL Server with Mr. Denny.
I admit it, I still use SQL Profiler. I always have, and I will for the foreseeable future. My reasons are pretty simple.
- When it comes to troubleshooting I can spin up a Profiler session must faster than an Extended Events session.
- Usually, I’m troubleshooting something as a one-off. so having my session isn’t really something I care about.
- I usually can’t bring scripts into my client’s servers to setup Extended Events, so I have to go create everything manually. (See #1)
- Done correctly with filtering, there’s no risk of a production outage using Profiler.
- If I could bring in scripts to set up an Extended Events session (see #3) I’d have to modify the session which I can do faster in profiler than in Extended Events.
Should you be using Extended Events? Probably. Odds are you got a full-time job somewhere, so extended events sessions are going to make more sense for you as you can run them against your servers and easily jump on and see what the server is doing.
What would it take get me to use Extended Event sessions instead of Profiler? Speed. Whatever GUI Microsoft creates for Extended Events needs to be just as responsive as the Profiler GUI, and the data that is returned needs to be returned by Extended Events just as quickly as data is returned from Profiler.
The post Why Profiler For Life? appeared first on SQL Server with Mr. Denny.
If you’ve been thinking about submitting for the PASS Summit 2018 Speaker Idol, but you aren’t sure that it’s for you, we can solve that problem. On
August 30th, 2018 at 1600 UTC (4 pm) join myself, Karen Lopez, and Joey D’Antoni at the PASS Professional Development Virtual Chapter as we talk about Speaker Idol at the PASS summit. You can register for the session on the PASS Professional Development VC website. We look forward to seeing everyone at the webcast.
The post Get some behind the scenes information on PASS Summit Speaker Idol appeared first on SQL Server with Mr. Denny.
OCEANSIDE, Calif., Aug 2, 2018 /PRNewswire/ – Denny Cherry & Associates Consulting announced today the company has been named one of the “10 Best Performing Azure Service Providers 2018” by Insights Success Magazine.
A Microsoft Managed Gold Partner with a team of veteran Microsoft MVPs, Denny Cherry and Associates Consulting are renowned for their depth of knowledge in, and dexterity with, Azure solutions.
Principal and CEO Denny Cherry commented, “We’re really proud to be named to this list and thank Insights Success for nominating us. Azure consulting has become almost 50% of our business in the past 18 months and it’s great to be recognized for the work.
Every week brings us a new Azure challenge right now. We’ve just wrapped up a 50 Terabyte migration for a business that was going from a CoLo to Azure. Simultaneously, on behalf of a non-profit customer, we’re assisting with medical reporting for medical clinics in Africa using PowerBI. We’ve designed the system to include Azure Virtual Machines to load and scrub the data before moving the data into PowerBI for users around the world.”
About Denny Cherry & Associates Consulting
The vetted and certified experts at Denny Cherry and Associates Consulting assist companies with reliably attaining IT goals such as HA, scalability, SQL Server virtualization, Azure migration and acceleration, while finding ways to save on costs. With clients ranging from Fortune 50 corporations to small businesses, their commitment to each is the same: to provide a deft, high-speed IT environment that leverages every aspect of their platform: from architecture, to infrastructure, to network. http://www.dcac.co/
About Insights Success
Insights Success is The Best Business Magazine in the world for enterprises. Being a platform, it focuses distinctively on emerging as well as leading fastest growing companies, their innovative style of doing businesses and the way of delivering effective and collaborative solutions to strengthen market share. Here, we talk about the leader’s viewpoints & ideas, latest products/services, etc. Insights Success magazine reaches out to all the ‘C’ Level Professionals, VPs, Consultants, VCs, Managers, and HRs of various industries. For more info, visit: www.insightssuccess.com
SOURCE Denny Cherry & Associates Consulting