Stefan Krzywicki (5/17/2012)

---

Steve Jones - SSC Editor (5/17/2012)

---

Thanks to new data mining abilities I think I read that they have the ability, to 75% or 90% or something like that,...

Just to jump on the bandwagon: I've been performance tuning SQL Server for 11 years now, and I'd never use this "own optimizer" solution. Lots of better, more standard,...

And on the subject of "what is big data", I define it as any data where quantity has more of an impact on performance than normalization does. In other...

CrankyRat (5/16/2012)

---

"Relational database technology is pretty much obsolete and archaic.", Geoffrey P. Malafsky, Ph.D. from the Karen Lopez link.

What an idiot. Saying relational technology is obsolete is like saying algebra...

Format the data into an XML block, insert into a log table with an XML column. You can do that in a trigger pretty easily.

Michael Valentine Jones (5/15/2012)

---

I had an interesting experience recently where I was being interviewed by someone without the technical experience to be able to evaluate my skills at a company...

Not clear on what you're asking for.

opc.three (5/15/2012)

---

GSquared (5/15/2012)

---

Because of all of those kinds of exceptions, and dozens more, I don't recommend doing this in T-SQL, and don't recommend doing this at all without serious research...

I found a suggestion that says that if you want a default, use 1=1 as the test, and put it last. Haven't tried that, but it would go where...

What you want is probably sp_send_dbmail. Look that one up, play with it a bit, and see if it'll do what you need.

Another possibility, of course, is SSRS. ...

Check layers between the user and the table. Proc, code that calls the proc (or inline SQL), connection, et al. The problem will be in one of those.

Lynn Pettis (5/15/2012)

---

ByronOne (5/15/2012)

---

Sorry for being stupid but do you mean like the following:

=Switch(sum(Fields!YTDBudget.Value)/sum(Fields!YTDActual.Value) -1 <-2.5, "Green", sum(Fields!YTDBudget.Value)/sum(Fields!YTDActual.Value) -1 <=-5.0, "Yellow", sum(Fields!YTDBudget.Value)/sum(Fields!YTDActual.Value) -1 <-5, "Red")

I've tried this but it seems...

Here's an all-TSQL version:

;

WITH Seeds(Seed)

AS (SELECT *

...

Change the function to <-5 instead of >-5, see if that does what you need.

Lynn Pettis (5/15/2012)

---

I am going to just say we are going to have to agree to disagree. I am not going to say that the Primary Key should most...