SQL Kiwi (9/14/2012)

---

GSquared (9/14/2012)

---

SQL Kiwi (9/14/2012)

---

Rather than trying to navigate all the quirks of the interpretation of strings as dates, use an explicit style:

-- Style 103 = dd/mm/yyyy

SELECT DATEPART(DAY, CONVERT(date,...

I have about a dozen with various IT-related products/companies/whatever marketed on them.

My current favorites aren't IT though. I recently got a couple of custom t-shirts with:

Front:

Vote Illuminati

No matter...

Stefan Krzywicki (9/14/2012)

---

GSquared (9/14/2012)

---

Stefan Krzywicki (9/14/2012)

---

Brandie Tarvin (9/14/2012)

---

Stefan Krzywicki (9/14/2012)

---

GilaMonster (9/14/2012)

---

Anyone get the increasing feeling people are looking for the 'eazy button'?

Case in point:

"I read through those articles [on index...

Or ANSI/ISO...

Stefan Krzywicki (9/14/2012)

---

Brandie Tarvin (9/14/2012)

---

Stefan Krzywicki (9/14/2012)

---

GilaMonster (9/14/2012)

---

Anyone get the increasing feeling people are looking for the 'eazy button'?

Case in point:

"I read through those articles [on index column ordering], but...

Or "by design because they hoped it would never come up and couldn't figure out a good solution for it". I've seen that one before too. (As opposed...

Like this:

DECLARE @StartDate DATE = '20120101';

WITH Seeds(Seed)

AS (SELECT *

...

Brandie Tarvin (9/14/2012)

---

The execution plans on both of them are identical. Same objects, same percentages. (Once I swap the tables in the FROM clause, that is). Same results, same everything.

But...

Gazareth (9/14/2012)

---

They are equivalent, but I don't think you can mix the two types of join in the same query.

It's the where clause that's causing the difference in the results,...

What isn't working about it. Do you get an error message? Get the wrong results? Something else?

Yep. Knowing which forum/site to use isn't helped by the fact that they're all "SQL". Definitely feel for you on that one.

Partial recompile.

Statement-level, not proc-level.

Example here: http://sqlserverplanet.com/sql-optimization/temp-table-recompiles/

Excellent article on table variables and temp tables and other options: http://www.simple-talk.com/sql/t-sql-programming/temporary-tables-in-sql-server/

Gazareth (9/14/2012)

---

They are equivalent, but I don't think you can mix the two types of join in the same query.

It's the where clause that's causing the difference in the results,...

PL/SQL doesn't declare variables with @ symbols on them, per the samples I found. Here's an example: http://www.plsqltutorial.com/plsql-variables/

The problem you're running into is that T-SQL (Microsoft's version of SQL)...

I couldn't find an answer to this guy's question: http://www.sqlservercentral.com/Forums/Topic1359181-391-1.aspx?

I always thought that "," and "CROSS JOIN" were identical, but he found a case where they aren't. "," generates...