SSAS is a service for data warehousing.

Pre-aggregation of measures along dimensions makes querying the data faster. Dimensional cubes instead of normalized tables make analyzing the data more efficient and...

Neither. More like I wasn't watching my feet, tripped, and landed face-first on a big pile of DBA.

My first rude awakening on it was how unclear basic terminology was...

The easiest way would be to use a row_number, and odd rows on the left, even on the right. Thus, in a 3-element list: 1 & 3 on the...

Does PID somehow translated to "historical" versus "present" in your question?

Glad we could help.

Non-recursive CTEs, and CTEs that don't reference prior CTEs, are functionally identical to classic derived tables in the From clause. There's no difference between the two in those cases....

CELKO (8/5/2012)

---

I would have to do some digging for exact rules, but this is a T-SQL dialect error. The conversion should fail with a message that the string cannot be...

Does the sample I posted help?

The documentation is here: http://msdn.microsoft.com/en-us/library/ms175972.aspx

asm1212 (8/7/2012)

---

Guys,

This has gotten overblown...

When I first posted that sample code stuff and realized it wasnt formatted once I finished posting, I remembered that there was a specific way yall...

On the republish (7 Aug 12), the link is broken, but from the editorial and discussion make it clear enough what it was about originally.

If an interviewer tried the "you're...

Yes.

Of course, the amount it's decreased depends on...

Phil Parkin (8/6/2012)

---

GSquared (8/6/2012)

---

Abu Dina (8/3/2012)

---

Thinking about this more, I wonder if the following will work.

Street names in the UK tend to end with words like Street, Avenue, Crescent etc,...

vinu512 (8/6/2012)

---

Collation: SQL_Latin1_General_CP1_CI_AS

DataType: DateTime

GSquared (8/6/2012)

---

Dates in SQL Server aren't stored in any of those formats. ...

I guess it would depend on what you mean by "3 disks". If I only had access to three physical disks, I'd set it all up as a single...

Ewald Cress (8/7/2012)

---

GSquared (8/6/2012)

---

Complexities like these are one of the myriad of reasons I consider such systems horribly flawed in the vast majority of cases. They make documentation more...