http://msdn.microsoft.com/en-us/library/bb326290.aspx

yes, if sql is patched to sp1 cu8, but functionality limited to features SSRS supported in Sharepoint 2007.

DerbyNeal (11/10/2011)

---

Hi,

I am running a SSRS program that selects data across 2 linked servers.

The process has to be completed in 2 stages otherwise I get a 'NT AUTHORITY\ANONYMOUS LOGON' message.

SSRS...

Extremely, extremely unlikely that you'd get a bad plan from a dirty read during a stat recalc. Remember that your million row table is going to get condensed...

Here is a query to return the row counts for every user table in the database:

select s.name schema_name,

t.name table_name,

...

No.

And, if you see the share on the passive node, delete it. Cluster service creates it when...

You shouldn't see the share on the passive node if the cluster is configured correctly.

Did you create the share in cluster admin, or in windows explorer?

Do you have dependencies setup...

Can you post the query plans from before and after creating/dropping the index?

This does sound like statistics...

Also try updating stats on the table before creating the...

Knowledge Hunter (10/24/2011)

---

Hi All,

We have a fact table containing 28489211 rows and 18997272 KB.

We have created a few non clustered indexes based on the queries those are regularly used.

But there...

I wasn't involved in that decision, but my guess is the size. I believe our corporate full backups are 10-15 TB.

(duplicate post)

LearningSSAS (10/25/2011)

---

Logically speaking you are correct. However, the bigger issue is I intend to perform a COUNT on this column and I understand that whether it is NULL or...

dajonx (10/24/2011)

---

Thank you, David, for explaining your environment!

After reading your response, I do have to agree with you that SAN to SAN replication is outside of the backup and restore...

LearningSSAS (10/24/2011)

---

This query on my Fact Table works just the way I want:

SELECT COUNT (DISTINCT ORDERNUMBERUNIQUE) AS COUNT

FROM FACTTABLE1

WHERE NOCHARGEAMOUNT > 0 AND NOCHARGEAMOUNT IS NOT NULL

My plan is...

Here's a script to identify the effected indexes and estimate how many MB would be moved by a shrinkfile operation. It can help you identify non-clustered indexes that could...