MSQLDBA (6/15/2011)

---

Hi Friends,

I have some questions which is based on interview questions. I would like to know and share with newbies how we can explain it in short/in detail.

1) Explain...

It's a style issue at that point.

If you do both sums in a single derived table in the From clause, instead of as a CTE or two derived tables, you'll...

Are these a full backup and multiple diff backups, or multiple log backups, or something else?

SteveOK, here are the current top posters:

SQLRNNR - 2567

GilaMonster - 1957

Lynn Pettis - 1775

Alvin Ramard - 1745

Steve Jones - SSC Editor - 1434

Grant Fritchey - 1427

Jeff Moden - 1258

GSquared -...

Try downloading it instead of running it from your browser. I think that's what you need to do to get it going.

In terms of a book to start out...

The bit at the end is the Windows version, so that part doesn't matter.

What you need to do is apply the latest service pack for SQL 2005 to that server....

Andy, I have to say, your flying ship phrase amused me.

One that I've misappropriated is "data stream", to indicate the flow of data from first arrival to final rest or...

Probably "The Thread" is.

Ben, the other thing you can do to get a list of the columns in a table is drag-and-drop the "Columns" header from the object explorer into the editor. ...

Just keep...

david.rowland (6/14/2011)

---

My coding method is more like the following:

SELECT

eggs

,cheese

,milk

,bread

,cookies

,salt

...

jasona.work (6/14/2011)

---

A comment, and a question:

Being a SQL newbie, I've (so far) made surprisingly few of these mistakes. I almost ran into the too many commas, because of copy-and-pasting...

Any Null in the string will render the string null.

Try this:

select 'Hello ' + Null + 'world';

That's why I enclosed "NULL" in single-quotes in my sample solution, to make it...

Jeff Moden (6/14/2011)

---

Heh... I agree. For most, it won't. For me, it was a different story......

An SSAS Developer would be someone who would develop SSAS solutions. Designing, building and optimizing cubes would probably be the main thing.

Edit: And writing MDX queries, of course.