I'm only fluent in American. I barely speak English. My French is beyond pathetic. I don't remember enough Classical Latin or Greek for it to be useful...

CirquedeSQLeil (2/12/2010)

---

Alvin Ramard (2/12/2010)

---

CirquedeSQLeil (2/12/2010)

---

Alvin Ramard (2/12/2010)

---

CirquedeSQLeil (2/12/2010)

---

Alvin Ramard (2/12/2010)

---

Hey Jason. I don't know what triggerred this thought, but the word Mentor just made me think of the French...

CirquedeSQLeil (2/12/2010)

---

While reading the thread for today's headline article, I thought of an excellent interview question:

"What is the most important data in the world?"

I think you could gain plenty of...

I'm not sure that's the tag you wanted, Wayne.

Dictionary definition: physic noun: a purging medicine;...

For me, it depends on the data loss policies of the company, and the ability to recover data.

For example, I used to manage a database that was just a tool...

The team version is best, but Visual Source Safe would probably work.

_UB (2/11/2010)

---

Thanks GSquared. I'll keep those questions in mind, while I think about a solution.

Be it VM or not, the ID must be unique. Even if the database is transferred...

Try this:

select case (select serverproperty('engineedition'))

WHEN '1' THEN 'Personal/Desktop'

WHEN '2' THEN 'Standard/Workgroup'

WHEN '3' THEN 'Enterprise/Evaluation/Developer'

WHEN '4' THEN 'Express/Advanced Services/Embeded SQL'

ELSE

'Unknown EngineEdition'

END as Engine

Can't you set up source control and a check-out/in process for the reports? That's even better than just auditing, and not hard to set up.

I can't get it to work with the maxrecursion option in the view definition. Works if I query the view with that hint, but not in the view definition...

Just be smart with that. It'll give you overlapping recommendations that end up being redundant in many cases.

Are you talking about the database engine tuning advisor?

_UB (2/11/2010)

---

Thanks GSquared.

I'll try to see, if I can explain our situation:

Our software will be installed at various locations in US. We need a way to uniquely identify...

"Best" is one of those fun words that doesn't have a real meaning. My favorite one of those is "soon".

On that goal, I'll have to say "fail". 🙂

What you have is the classic difference between "de...