Thanks for the response.

Yes, I'm connecting as an admin.

Thank you, I will try that.

Mani Singh (6/29/2008)

---

Well, you can check your Cube(s) (Analysis Services Database) Complexity against Performance.

If you have Many Dimensions and Fact Tables and Millions of Rows and it is a performance...

Jonathan Kehayias (6/28/2008)

---

More thn anything else, UDT's and UDF's are easily used out side of SQL. This is of great benefit for things like geocoding where the UDT is...

For the purposes of this debate, what is the point of invoking SQLCLR code outside a SQL context?

I'm wondering if this is even necessary.

What are the possible scenarios for this?...

Jonathan Kehayias (6/27/2008)

---

(1) Create a new schema that will hold the SQLCLR objects

(2) Create an asymmetric key from the assembly dll

(3) Create a login from the asymmetric key

(4) Grant EXTERNAL-ACCESS-ASSEMBLY...

Dan English (6/27/2008)

---

First of all you won't be limited to the number of processors you can utilize on the server. SSAS Enterprise will provide parallel processing capabilities, partitioning your...

The purpose of a SQLCLR assembly is for it to be invoked from within SQL code.

You don't need to call it from .NET code.

What is your assembly doing?

Yes, that was already in place.

We figured it out.

The server name of the server on which the query was running was added to the hosts file of the target server (the server pointed to...

Thank you for the response.

The queries we are using for inserting/updating data (thousands of rows) through a linked server are very slow at the moment, that's why I thought to...

dan griffin (6/23/2008)

---

I use WROX - Professional SQL Server Analysis Service with MDX. I've only started to design cubes, but the fundamental concepts in this book seem good. I still...

A good starting point is reading through this link:

Microsoft SQL Server Management Pack:

http://technet.microsoft.com/en-us/library/cc511079(TechNet.10).aspx

Out of the box SCOM monitors a limited subset of things, such as service and database availability and...

The sticky point with all this is that because of all the potential issues surrounding a move to 64-bit, many companies will hesitate to go ahead with it.

Sure, one...

Grant Fritchey (6/18/2008)

---

There's not a good source for this information. Experimentation is how I'm getting by.

I can recommend three sources that can help, in addition to posting here (althouth...