Thank you, that worked!

Why so complicated to get a simple setting back?? :w00t:

Lowell (5/26/2010)

---

is there a downloadable demo of this, even crippleware for using only the Adventureworks db or something?

this sounds too good to be true, so I'd like to see it...

Steve Jones - Editor (5/25/2010)

---

Hyperbac, owned by Red Gate now, does something similar. You can work with a backup file as though it were a real database. The Hyperbac demo...

Thank you for all the information;

I will certainly keep an eye out for upcoming news and documentation of the SQL Sentry Performance Advisor and will be visiting your blog.

This seems like a good starting point:

http://msftasprodsamples.codeplex.com/wikipage?title=SS2008!Readme_AMOAdventureWorks&referringTitle=Home

Thanks, I'll look around on the web.

It's frustrating that BOL has barely no code samples in the sections that describe the Analysis Services classes.

I find links like the one below...

stevefromOZ (4/26/2010)

---

Let's start with what is shown in SSMS. I right-click on one of my custom roles, select Properties and click on Dimension Data.

I don't think I understand what I...

stevefromOZ (4/26/2010)

---

Any hints on the discrepancies? (ie something is there in SSMS but not in the output of your insert; or perhaps the permissions themselves differ slightly) Not...

That's correct, I have opened a case with MS on this issue, still no resolution.

Elliott W (4/15/2010)

---

You could build a VB or C# app to open the packages one-by-one and examine the connections collection. I *think* you can read them directly from the...

Marios Philippopoulos (4/15/2010)

---

I need to find out which of the SSIS packages stored in msdb reference a specific shared datasource, dtsrc1.

System view sysssispackages does not seem to be the way...

Thanks both for the insightful answers.

Jeffrey Williams-493691 (4/9/2010)

---

First, you have to create the login on the secondary server with the same SID that exists on the primary server. Lookup CREATE LOGIN in BOL for...

Another consideration:

Lowering the fillfactors will reduce READ performance on index scans.

I guess nothing is for free... 🙂

Also look into lowering the fill factors of your indexes so that they do not get fragmented as often.

See discussion in http://www.sqlservercentral.com/Forums/Topic892938-1550-2.aspx#bm898207.

I use this query to find the usage statistics...