Dev (12/9/2011)

---

So if I understand your requirements correctly, you are planning 10000+ DBs or schemas (1 per customer).

DBs: N (1 per customer)

Or

Schemas: N

Roles: 3 * N

Users:...

Dev (12/9/2011)

I believe you got me wrong. I just wanted to warn you and not at all underestimating you (or your skills).

Reading your explanation, I happily take my...

Perry Whittle (12/9/2011)

---

It's not a given, and in fact for...

I know quite well it's not my specialization,...

GilaMonster (12/8/2011)

---

okbangas (12/8/2011)

---

In my opinion, this is not a good solution at all. Unless I had extremely many customers, I would have a separate database for each customer, mainly to...

Just for the records, I was not writing any production code or trying to cumulate anything. Just testing what Mr. Ali said about the performance of memory table vs...

Those tests consists of calculating the running total for one field in the table. Both versions does exactly the same thing.

This is the cursor test ...

[font="Courier New"]DECLARE @StartTime datetime

DECLARE...

I totally agree with Kevin on the "Code Readability vs Performance" issue.

Readability should not be the sole selection criteria for a solution vs another. Performance of code that runs...

Just did some testing with a 300,000+ record table and following some advice from past post concerning cursor optimization, I was able to achieve the following stats:

CURSOR (LOCAL FAST_FORWARD) :...