ebouras (8/23/2016)

---

N_Muller (8/23/2016)

---

If you have temp tables (#tables) with indexes in a stored procedure where ansi warnings are turned off for aggregation of null values, the procedure fails. Regardless...

If you don't like the warning, it's often easy to update the query to explicitly replace the default behavior. To be honest, I have used this setting when I...

Thanks. I've been collecting performance counters on several servers. The easy calculations like average, extreme, and deviation tend to wash out performance details. I want to get...

PS Microsoft announced some good news the day before April 1st: Xamarin will be free for users of Visual Studio. It was not a joke. Now back to...

One day a year, the joke is on them. The rest of the year, it is on us. When I saw Schrödinger's equation, I thought that Microsoft was...

We had a SQL Server failover cluster for many years because we "wanted" it to be available at all times. We have many servers and the cluster turned out...

Thanks. I tried to use maintenance plans sometime around SQL 2005. I remember writing T-SQL to manually edit the XML for a plan so that it could be...

Zidar (3/11/2016)

---

BTW, solving 1X = 2X has X = 0 as a solution. There is no contradiction as it's also a solution of the original degenerate equation which is 0=0...

roger.plowman (3/11/2016)

---

rstone (3/10/2016)

---

In the logical design, the business logic might require handling missing data and reasons for missing data. Using tokens -2, -1 , 0, etc. is one way of...

ZZartin (3/10/2016)

---

If a solution...

BTW, solving 1X = 2X has X = 0 as a solution. There is no contradiction as it's also a solution of the original degenerate equation which is 0=0...

kenambrose (3/10/2016)

---

why do the same flawed arguments keep popping up?

[[If you deal with a report and want all columns via left joins, then there will be nulls. ]]

We don't know...

In the logical design, the business logic might require handling missing data and reasons for missing data. Using tokens -2, -1 , 0, etc. is one way of handling nLvl...

Sounds like the requirements are missing. Null requirements? However, if the data is really missing, each column might require custom treatment because of business requirements. In this...

The SELECT clause can arbitrarily format the results. If it is a token, I would consider it an application token, not a database token.

Back to an earlier question....