Thanks Grant

This fact (size of data to cache) was original reason I started to look for sql server alternative. Probably I need to try both ways- caching on server (with max...

Thanks, Steve.

Agree, I would rather try to speed up (tune) my queries for charts creation (calling main table) or saving dataset1 somewhere on web cache- will check what way is...

Sorry, I probably was not clear.

Data in myTbl does not belong to particular User bur rather denormalized storage for all Customers under our service. When UserA calls SP1 (to populate...

Frankly I thought almost same way, i.e. for each User_Customer pair (Portal User) create table with unique name and insert output from SP1 into it and use this table for...

Check BOL "Troubleshooting Orphaned Users"- probably this is what you are looking for

Great!

Thanks again, Yuri

Perry,

Yes, I know that TempDB is recreated each time Sql Server restarted but just to be sure I got you:

if I keep mdf TempDB file and for ndf one I...

jsturgeon 49541 (4/6/2011)

---

I have some reports that are for internal consumption only. Anyone in the company should be able to see them, however, the majority do not have access...

Rod,

Sorry for asking, but are you sure you need SSAS not SSRS (Reporting Services) to create these reports? From your description (queries, SPs) I did not get why do you...

One more option- use WAITFOR TIME 'time_to_execute' in your SP

Check here:

http://technet.microsoft.com/en-us/library/cc768048.aspx-

everything you need about PerMon counters. Good luck!

Just to share my experience (probably it can help you). A while ago I had same issue- could not get apps that updated data in a table. Therefore I added...

You can use DMV sys.dm_exec_requests, standard reports have a lot of useful info,

but I do not think sp_who2 can help you with blocking wait time

Just to share my experience- month ago I did this: 1) DB size- ~5.5 TB; 2) backup file size- ~1.3 TB (Red Gate Sql Backup 5, compression level = 2);...