george sibbald (6/27/2011)

---

I think you have to accept that in most shops devs will own the code but not the environment (and certainly not production). The DBA is needed to...

That's cute, the detailed Express license is AWOL from here:

http://www.microsoftvolumelicensing.com/default.aspx

It's not offered here:

http://www.microsoft.com/sqlserver/2008/en/us/express.aspx

or here (basically same link as offered above):

http://www.microsoft.com/sqlserver/en/us/editions/express.aspx

Or here...

http://www.microsoft.com/sqlserver/2008/en/us/licensing.aspx

Okay, that's getting rediculous. Anyone installed R2 Express lately...

repicurus (6/27/2011)

---

From MSDN:

The 4 GB database size limit applies only to data files and not to log files. However, there are no limits to the number of databases that...

george sibbald (6/27/2011)

---

A DBA never owns code, Devs own code, the DBA is responsible for the environments the code runs in, especially prod. Ownership and responsibility could be getting mixed...

Oh lord no. The thread will never die...

As Promised: http://www.sqlservercentral.com/Forums/Topic1132391-391-1.aspx?Update=1

Be aware:

This...

Eric M Russell (6/27/2011)

---

You are right, the result of a CTE is not persisted; it's just a way to make multiple references to a derived table, each with it's own...

aarunkumarreddy (6/26/2011)

---

Craig Farrell (6/26/2011)

---

In SQL Server? That sounds like an Excel question.

Check out BoL. It's not a hard limit for columns, but a size one. There's no...

In SQL Server? That sounds like an Excel question.

Check out BoL. It's not a hard limit for columns, but a size one. There's no row limit other...

Jeff Moden (6/26/2011)

---

They're very useful for things other than xp_CmdShell. A simple example is where you want someone to use a proc that truncates a real table without giving...

Eric M Russell (6/25/2011)

---

Craig Farrell (6/24/2011)

---

...

Just to confirm, you're familiar with the fact that a CTE is nothing more then a subquery, and has no optimization value? It's merely...

Sure my little marketing annoyance: http://www.HowNotToBeAShmuck.com

Yeah, he forgot the dd component.

Use:

DATEDIFF(...

Eric M Russell (6/24/2011)

---

The decision of temp table vs table variable vs CTE or etc. depends on how this intermediate resultset will be leveraged within the stored procedure.

Where I've mostly...