how much memory on the server and what is the sql max memory configured as?

sql's max memory setting controls the buffer pool, not the memory used for the app domains...

Not True. The allocation contention in...

You can use a table valued parameter.

... And ( t1.c in (select id from @p2) or not exists (select * from @p2) )

It goes in the dimension. Sometimes prices act as a measure as well, but typically if you don't aggegrate them, they aren't measures.

Here is another pattern for "catch-all" queries:

select *

from t1

where (@p1 is null or @p1 =t1.c2)

option (recompile)

Not sure if better or not...

A cursor is fine. You'll end up calling sp_executesql for each row which will make the overhead of the cursor insignificant.

Though, for index maintenance, don't reinvent the wheel,...

Set based languages are declarative. You tell sql server WHAT you want not how to do it.

"I want the set of customers who ordered more than $100...

If you run your scripts in sqlcmd mode in ssms or using sqlcmd.exe, you can use :r to import files into the current script.

The tail of the log is the part of the transaction log that hasn't been backed up yet. if you take a log backup of the databse you...

Your query is using bitmap filters.

a bitmap filter is a way for sql server to eliminate rows earlier in the execution pipeline. This is a powerful performance optimization.

Bitmap filters...

Hernán Rojas (8/6/2012)

---

Thank you GSquared for your answer. I would like to ask something else:

If you only have 3 disk for organize your databases phisical desing, which option would...

Ok, a couple of things to look at

1. how expensive is [dbo].[fnRubricDomainScoresMarzano]() ?

2. you also might try adding OPTION (RECOMPILE) to the end of the query (parameter sniffing) ...

typical cursor flow is:

declare cursor ...

open cursor ...

fetch from cursor ...

while (@@FETCH_STATUS <> -1)

BEGIN

...

Ola hollengren, DB maint script.

Don't reinvent the wheel.

Download.

Run script (it creates sql agent jobs)

Edit job step as needed (number of days to keep, target directory, etc)

Schedule...

SQLKnowItAll (7/30/2012)

---

So the error is the "double hop." I don't think you can use the impersonate for remote connections to the server that is housing the linked server. Best...