MadAdmin (12/22/2015)

---

So far, it has only helped me rebuild index partitions on the last changing partition, reducing the maintainance window, giving me extreme savings in my rebuild window, but no...

Very unlikely. Partitioning is not for performance. It's for data management.

Will partition gain performance for data...

Ok, so why are you looking at partitioning?

Adrian Chapman (12/22/2015)

---

Ivanova (12/21/2015)

---

Slightly off-topic; while working for a large financial institution, I was approached by one of the security team. He was a highly-paid and allegedly very security-savvy contractor....

Why are you partitioning?

If you're partitioning for data loads and data archives, then the granularity of the data imports will determine what you want to partition by.

Edit: nm

Let's turn this into something more readable first and take out the invalid quotes.

SELECT Supplier_Details_tbl.Supplier_Name,

Documents_tbl.Document_Type,

...

Yes, the behaviour's correct. There's no predicate comparing a to b, and the predicate on b cannot filter the rows in a, therefore all rows qualify for the delete and...

Why? Parallel execution is good, it means SQL's using resources effectively to return results quickly. A parallel query is no...

From a *user's* perspective all that's important is speed, but you're not a user. To...

You would be wrong.

The first is a guaranteed table scan every time. The second is far...

I'm pretty sure mall security would have objected to a sabre with light-up blade.

I don't have one that's just the hilt yet.

If you mean a function that takes an undisclosed number of parameters, you can't create such a function. You have to define the parameters exactly when the function is created...

Scene from Friday evening

They've both got inherent performance problems. Take a read through https://www.simple-talk.com/content/article.aspx?article=2280