I appreciate all you do for the SQL community and #SQLFamily. You're in my thoughts and I hope you get better soon.

If only the code had been

declare @sql nvarchar(max)

set @sql = 'IF OBJECT_ID(''TempDB..[' + CHAR(31) + ']'') IS NOT NULL DROP TABLE TempDB..[' + CHAR(31) + ']'...

farooq.hbs (11/16/2012)

---

1) There is a table variable called @benList. I would try converting this to a temp table. The optimizer will only count a table variable as having one row.

Ans:...

A couple of things to add

1) There is a table variable called @benList. I would try converting this to a temp table. The optimizer will only count a...

For Pre Aggregation try to aggregate separate tables in separate steps. For the query you have there are several options. You'll have to test each to see which...

That's 14 billion rows in two table spools. That's a lot of work for TempDB.

I would try to pre aggregate the two UseDate columns on the customer ID (for...

Have a look at the URL below.

http://www.brentozar.com/sql/sql-server-san-best-practices/

I would highlight the following section

http://www.brentozar.com/archive/2009/05/san-multipathing-part-2-what-multipathing-does/

I suspect you are having problems with the table value constructors. Try what I have below.

IF OBJECT_ID('TempDB..#TBL1') IS NOT NULL DROP TABLE #TBL1

CREATE TABLE #TBL1

(Prod CHAR(2) NOT NULL,

Region...

qew420 (11/1/2012)

SQL Server is not eating any memory : it stays on 65GB but CPU consumption is high "75 to 88%"

Just to test: I stopped the reporting services...

For much more information:

http://www.sqlservercentral.com/articles/T-SQL/63681/

I can give you some quick pivot operator code:

IF OBJECT_ID('TempDB..#TBL1') IS NOT NULL DROP TABLE #TBL1

CREATE TABLE #TBL1

(Prod CHAR(2) NOT NULL,

Region CHAR(2) NOT NULL,

YEAR INT...

Pull your top 20 dates with a subquery first.

SELECT E.cStudentId ,

E.iSchoolCode ,

...

This is interesting. Do you know if its allowing parallel processing of the partitions?

You need to make sure that your development environment edition in BIDS is set to match your production environment. See the link below:

http://www.mssqltips.com/sqlservertip/2150/edition-specific-ssas-development-using-bids/

Because of the left join you need to change the order of the tables in the from clause.

Select M.name, F.name, B.name

From ROLE F, Worker M

LEFT JOIN Worker B...

You should see the same formatting with the same rendering extension. This means that a report exported to PDF should look the same between reporting services and report builder....