avatarWendy Scott

Free AI web copilot to create summaries, insights and extended knowledge, download it at here

3413

Abstract

zations-for-columnstore-compression">here</a>.</p><p id="fc40">An example of over-configured workload management is when resources are reserved for a workload group even when there are no active requests in it. When setting up a workload group, you can define the minimum % of resources that are always reserved for the group. This is very useful in cases when you have to ensure that SLAs are met, but it should always be done with caution. If such strict isolation of resources is not required, it’s better to use a shared resource pool in combination with different workload importances.</p><h2 id="3041">3. Using clustered columnstore index for staging</h2><p id="23d4">By default, dedicated SQL pool will set up tables using clustered columnstore indexes. These are highly compressed, column-based data structures optimized for analytical workloads on large tables, but they can be expensive to build.</p><p id="5dbe">When loading data into a clustered columnstore index, the rows are first split into row groups (batches) which then are separated into column segments before each of these segments get compressed.</p><figure id="c79e"><img src="https://cdn-images-1.readmedium.com/v2/resize:fit:800/1*NUSN2jBohgHVlSGhjbgToA.png"><figcaption><a href="https://learn.microsoft.com/en-us/sql/relational-databases/indexes/columnstore-indexes-data-loading-guidance?view=sql-server-ver16">Source</a></figcaption></figure><p id="0b0b">Because building a clustered columnstore index is a resource intensive process, using them for temporary staging tables creates an unnecessary overhead without providing any benefits. When comparing the throughput of bulk loading processes for clustered columnstore indexes and heap tables, a 2–3x difference can be observed (<a href="https://techcommunity.microsoft.com/t5/sql-server-blog/data-loading-performance-considerations-with-clustered/ba-p/305223">link</a>).</p><p id="1bcf">While avoiding the aforementioned 3 mistakes when working with a Synapse dedicated SQL pool can help you save cost by utilizing your resources more efficiently, finding the right combination of tools for your business needs can be challenging. We at Starschema can help you identify the technologies that will best serve your use cases and fine-tune them for optimal performance. <a href="https://starschema.com/contact">Reach out</a> — we’d love to talk.</p><p id="ed30">To learn how Synapse fares against Databricks, Snowflake, Redshift and BigQuery fare and scale in terms of query performance, cost per performance and differentiating feature value, see the results of our extensive testing in this white paper:</p><div id="2298" class="link-block"> <a href="https://starschema.com/kb/cloud-data-warehouse-benchmark-2023"> <div> <div> <h2>Cloud Data Warehouse Benchmark 2023</h2> <div><h3>As cloud data warehouse providers race to improve the scalability, performance and cost-effectiveness of their…</h3></div> <div><p>starschema.com</p></div> </div> <div> <div style="background-image: url(https://miro.readmedium.com/v2/resize:fit:320/0*QBnOLQvJ3CUAhQ_C)"></div> </div> </div> </a> </div><p id="28bd"><b>About the author</b></p><p id="a1e9"><i>Marton is a highly skilled data professional with experience in commerci

Options

al aviation and electronics manufacturing. He holds a Master’s degree in data science from Tilburg University and previously worked as a data scientist with the top management of a major European airline, where his transformational work helped save millions of euros for the company. In his current work as a data engineer at Starschema, he helps Fortune 500 companies build data platforms to unlock greater value from their data. Connect with Marton on <a href="http://www.linkedin.com/in/martonmesz">LinkedIn</a>.</i></p><p id="272c"><b>REACH OUT TO STARSCHEMA <a href="https://starschema.com/contact">HERE</a>:</b></p><div id="2f2e" class="link-block"> <a href="https://starschema.com/contact"> <div> <div> <h2>Let’s talk | Starschema</h2> <div><h3>We help your organization become data-driven</h3></div> <div><p>starschema.com</p></div> </div> <div> <div style="background-image: url(https://miro.readmedium.com/v2/resize:fit:320/0*JnBf22UiwDSON2-d)"></div> </div> </div> </a> </div><p id="742c"><b>READ MORE STORIES FROM STARSCHEMA:</b></p><div id="4934" class="link-block"> <a href="https://readmedium.com/find-the-balance-between-cloud-cost-and-efficiency-889958c39908"> <div> <div> <h2>Find the Balance between Cloud Cost and Efficiency</h2> <div><h3>Learn how to measure the ROI of a cloud migration and get clarity on the opportunities and challenges inherent in…</h3></div> <div><p>medium.com</p></div> </div> <div> <div style="background-image: url(https://miro.readmedium.com/v2/resize:fit:320/0*3onHo1F--Lp3oe9M)"></div> </div> </div> </a> </div><div id="a8c0" class="link-block"> <a href="https://readmedium.com/data-fabric-vs-data-mesh-find-the-right-fit-for-your-organization-40b37f4efba"> <div> <div> <h2>Data Fabric vs Data Mesh: Find the Right Fit for Your Organization</h2> <div><h3>Learn the differences between data mesh and data fabric architectures and find the right one for your data governance…</h3></div> <div><p>medium.com</p></div> </div> <div> <div style="background-image: url(https://miro.readmedium.com/v2/resize:fit:320/0*uR7nzrNVrfSbaH6x)"></div> </div> </div> </a> </div><div id="5263" class="link-block"> <a href="https://readmedium.com/from-guesswork-to-genius-how-to-get-maximum-value-from-marketing-data-and-automation-b7600346dee7"> <div> <div> <h2>From Guesswork to Genius: How to Get Maximum Value from Marketing Data and Automation</h2> <div><h3>See how one company used marketing data to learn more about their audience and run more effective campaigns — and how…</h3></div> <div><p>medium.com</p></div> </div> <div> <div style="background-image: url(https://miro.readmedium.com/v2/resize:fit:320/1*nJFWer2IZmGd2KJAGBR-3g.jpeg)"></div> </div> </div> </a> </div></article></body>

How I Found Love By Narrowing My Dating Criteria

Find a match by being clear about priorities

Photo by Hendo Wang on Unsplash

After my marriage broke up, I was single for ten long years. I dated via online dating sites, off and on, and became an expert on dating rather than finding love. I had a couple of relationships that lasted about six months, two of them with much younger men, but nothing serious.

When I started dating, I was pretty clueless. I had been married for 18 years and the dating world had changed while I wasn’t looking. I went on a lot of coffee dates. I had fun and met lots of nice men but wasn’t achieving my goal of finding a partner.

I’m an extrovert. I love meeting people and getting out of the house. Looking back, I don’t think my extrovert tendencies served me well. My usual approach of, ‘If it’s an outing, count me in’ and habit of liking everyone and believing the best of people until proven otherwise, didn’t translate to successful dating.

I was too willing to go on dates with men who didn’t match my ideal. Although it was interesting, it became a waste of time.

That’s when I decided to narrow down my search.

Reading about dating was one of my guilty pleasures in my single days. I enjoy a happy ending as much as the next person. Stop laughing.

I’d read about women who had written down a description of the ideal man and thrown it out to the universe. There was a lot of throwing things out to the universe then. It seems to have died down a bit now. Or maybe I just read different books these days.

Anyway, these women seemed to manifest their ideal man almost instantly so I thought I’d have a go.

After some brainstorming, the criteria I came up with was:

  1. Must be within five years of my age
  2. Lives less than 20 minutes by car from my house
  3. British
  4. No widowers
  5. Atheist
  6. Intends to stay in Auckland
  7. Non-smoker
  8. Cannot be racist, sexist or homophobic
  9. Sense of humor
  10. Kind

The universe didn’t respond immediately but respond it did. Maybe the universe was on a weekend mini-break or something initially. I did meet my partner quite soon after I instigated the new narrowed down policy, though.

Here is the rationale behind my thinking and how I got on.

1. Must be within five years of my age

I’d dated a couple lovely younger men, 21 and 23 years younger than me respectively, and although it was fun and a massive ego boost, they were just at different stages in their lives. The older men I met seemed very old-fashioned and stuck in their ways. They asked me whether I could cook and if I kept a tidy home. Maybe that was their criteria, which is fine, but I found it off-putting and old-fashioned.

How I got on: My partner is 18 months younger than me. Tick. He talked a lot about being my toy boy until I told him about the real toy boys. Now he contents himself with muttering darkly to my daughter, ‘Well, we all know your mother likes younger men’.

2. Lives less than 20 minutes by car from my house

I get quite anxious when driving. Having to negotiate unfamiliar roads and find parking for a date with, what was essentially a stranger that I may never see again, became a pain in the neck. After a lot of putting myself out to find obscure cafes, with no resulting boyfriend, I got a bit lazy. Or maybe I just put in some boundaries.

How I got on: My partner lived a 10-minute walk away. Now he lives with me. Tick.

3. British

I went on dates with Kiwis, South Africans, Brits, Indians, Canadians and Australians. I came to realize that, for me, a shared culture does matter. Non-Brits struggled with my sense of humor. I struggled to understand them. Eventually, I decided it was OK to stick to Brits.

How I got on: My partner is from Newcastle and grew up in Wales. Tick.

Photo by Roméo A. on Unsplash

4. No widowers

I know it’s a bit weird, but I didn’t want anyone who idolized their first wife. Dead spouses tend to turn into saints overnight. Plus I had visions of my prospective soul mate slinking off with wife number one in the afterlife. And I’m not even religious. Just weird.

How I got on: No dead wives. Tick.

5. Atheist

I can’t do religion. I just can’t. It doesn’t make any sense to me. There is no way I could have a relationship with someone who is a believer. I have friends of many different faiths, that’s fine by me. We don’t talk about religion and they don’t expect me to go to church on Sundays. But I couldn’t cope with a religious partner. I imagine they wouldn’t be able to cope with me either.

How I got on: My partner is an atheist. Or so I thought. A friend of mine invited us to a (non-religious) talk in a local church hall. An elderly lady welcomed us in and gave us tea. We were chatting away like a house on fire when she asked if we were churchgoers. All fired up by Richard Dawkins (I was reading ‘The God Delusion’ at the time), I said ‘No, I’m an atheist’. “What about you?” she asked my partner. ‘I’m a Presbyterian’, he said proudly. What? It turns out he doesn’t like upsetting old ladies and instantly reverted to his childhood religion. Hmm! Not sure if he deserves a full tick for this one.

6. Intends to stay in Auckland

After moving around a lot in my twenties and emigrating to NZ in my thirties, I’m fed up with moving. My family and friends are here. I like cities. I don’t want to move. I stressed this on my profile but still got men contacting me who wanted to move to a life-style block (NZ code for a house in the country with land and maybe animals) in the middle of the South Island.

How I got on: My partner had already tried a life-style block and concluded he hated it. No-one is a more avid critic. He also likes cities and Auckland. Tick.

7. Non-smoker

No, not doing it.

How I got on: Tick.

8. Cannot be racist, sexist or homophobic

No-one is going to admit to being racist or any other ‘ist’ on their dating profile. If they do, it’s easy to screen them out. Sadly, many of the men I met did hold views which to me are unacceptable.

How I got on: Tick. No racism, sexism or homophobic points of view in our house. Though we do wind the kids up sometimes. Don’t panic, they are 21 and 20 and live at home, so fair game in my opinion.

9. Sense of humor

This one was a biggie for me. We Brits are renowned for our sense of humor. I didn’t understand what that meant to me until I met people who didn’t have it. Zombieland, Shaun of the Dead, Hot Fuzz and Paul are my favorite movies. We spend hours at home talking in silly accents. Sometimes we get stuck and can’t get back to talking in our normal voices.

How I got on: Tick. He’s just as bad as I am.

10. Kind

Suddenly, with the advent of Covid, kindness is all the rage. Here in NZ, Jacinda goes on about it all the time. I agree with her. I was onto kindness years ago. I met some kind and decent men in my dating career. I also met some stinkers (I’m trying not to swear, plus I like the word stinkers. It reminds me of Stephanie Cole and Margaret Rutherford).

How did I get on: He brings me tea in the morning, finds my glasses when I lose them, heats the car in winter before I get in. He does the food shopping and cooks me dinner. Tick.

Final Thoughts

Narrowing down what I wanted in a man helped me find that man.

My criteria won’t be yours and may even seem a bit odd. You will have to make a list that meets your requirements.

Being clear about what I wanted saved time which I spent with friends, relaxing or doing what I wanted to do. By the time I met my partner, it took a lot to get me out of the house on a date.

If you are looking for love, I hope you find it soon …

Love
Dating Advice
Dating Tips
Personal Development
Life Lessons 101
Recommended from ReadMedium