To expand further on Cognos:

Cognos generates SQL or MDX to access the data. In collaboration with SQL Server, these system-generated scripts can ... euh ... suck.

Performance can suffer if you...

No problem. Glad to help and that it all worked out.

I've used Cognos before, in particular Analysis Studio and Report Studio.

I would prefer Sharepoint above Cognos as a collaboration tool (can you have a wiki in Cognos?).

But Cognos has its...

I was thinking about the "beers and diapers" example during dinner, and maybe there can be some truth in it:

if beer and diapers are highly correlated, you should not set...

It is a classic example, used many times to explain data mining.

However, it is not...

Set the DelayValidation property of the dataflow to True. Furthermore, see that the table exists when you configure your dataflow.

janki_2886 (11/10/2010)

---

@OLD Hand: My Only intention, was to post a easy question(which , according to u was a dumb question),so that everyone can answer ...

Nice question.

And thanks to Carlo for the add-on.

Is the database compatibility level set correctly?

BOL says:

When PIVOT and UNPIVOT are used against databases that are upgraded to SQL Server 2005 or later, the compatibility level of the database...

cengland0 (11/9/2010)

---

Not saying it's a grammar mistake. ...

The question asked what the relation was between database snapshots and recovery...

Phil Parkin (11/9/2010)

---

da-zero (11/9/2010)

---

I don't have access to my code right now, but I'll post a script later that will check a given directory for files that match a certain...

Thanks for the question. Learned something today.

I don't have access to my code right now, but I'll post a script later that will check a given directory for files that match a certain filename, with wildcards...

SanjayAttray (11/8/2010)

---

Isn't it funny that when you say order by 1, sql server assumes 1 as column and gives result order by column 1 but at the same time...