tim.cloud (7/23/2012)

---

I think your right about that. Not sure if 32GB is the right number, but maybe 34GB for SQL maximum memory which would give the MPA+OS+Other Processes 6GB...

In cases where a filtered index is available, you can force SQL to recompile the statement, which should pick...

I'd suggest reducing SQL to 32GB rather than 36GB. Remember that Windows needs some RAM to manage the other RAM. I think you're cutting it too close initially.

First,...

If you don't use...

rupes0610 (7/20/2012)

---

Thank you, but I am now getting this error:

Column 'dbo.IIRPS_HPOO_LPAR.OnlineMemory' is invalid in the HAVING clause because it is not contained in either an aggregate function or the GROUP...

john.arnott (7/20/2012)

---

Re: Myth that @Table variables are only in memory.

It never made sense to me that people would think that MS would develop an open-ended methodology to manage data in...

I suspect the MERGE time could be reduced by clustering on the ProductID, but with it being nvarchar(60), that's not particularly appealing.

If you can go to just varchar(60), and the...

>> ON (t.ProductID = s.ProductID) <<

So is ProductID...

hisakimatama (7/19/2012)

---

First, I could have a table with a row for each item, and columns for each month. ...

Alternatively, I could create a table for each month, and track sales...

You have to use DBCC SHRINKFILE to reduce a file below its initial allocation.

USE <your_db_name>

-- get the file#s / names of all the db's files

EXEC sp_helpfile

Then choose the file# or...

It provides continuous availability of the data, with no...

SELECT

[Database Name],

[Compression Ratio]

FROM (

SELECT

b.database_name 'Database Name',

...

Sounds like RCS (Read-Committed Snapshot) is what you need here.

takilroy (7/17/2012)

My intent is to see if anyone has been able to or knows of a way to create a global constant variable or use a sql function to determine...

I really think you're going to drive people crazy trying to follow this because no one else does it.

Almost universal is to use NULL to mean "no value was passed...