I'm running at 98+% of memory usage.

Sharepoint portal gets really, really slow every 30 minutes or so scheduled jobs kick in and need additional memory while they run.

I'm...

It's a sharepoint server.

No linked servers.

I'm unaware of any custom CLR routines, don't know if sharepoint uses them. Ditto on custom extended procs

What would you recommend as the max...

16GB RAM in the system.

Max memory set to 12GB

Using 14.5GB or more.

I inherited the system.

It was set to 8GB max ram plus awe enabled. The executable was...

When I got started in computers back in the early '80s, there was a business model called 'time-sharing'. Software was run on expensive mainframes and businesses shared those mainframes...

It is pointless to try to find the answer to the wrong question.

Gianluca Sartori (4/9/2010)

---

Really? I use it to build strings...

shujaahmad2004 (4/9/2010)

---

Hi guys,

I have a query in one of my reporting services reports which is based on a case statement that uses a wildcard. (e.g. HAVING DIRECTORATE_CODE LIKE CASE WHEN...

Technically speaking, I believe it is setting the variable once for each row returned.

So, if the query returned 500 rows, the variable would have received 500 different values.

Only the...

Glenn,

If you have one table that holds all your filters, why can't the views just join to it? It's that simple.

I'm clearly not communicating my approach to you.

one data table, one view to go with it.

The view has a where clause in it.

That where clause would apply whatever filtering is...

Thanks for clarifying.

But if I did the view, the query inside the view definition would be joined to the filter table, so the view wouldn't need to be changed.

At least,...

The example given uses dynamic sql.

The sql statement is held in a variable and is built by concatenating strings together.

At some point, you are going to be getting the name...

Can you cluster the tables?

It's a great way to partition your data into the equivalent of many smaller tables while keeping the advantage of having just one table.

Why this data model?

Are you stuck with it?

Because this does not sound like a relational model.

I suggest that you re-think the data model and make it relational.

Many...

What do you mean by "update statement is successful".

Updates 1 row? >= 1 row? Doesn't throw an error?