Can you extend the log file, or allocate an extra log file?

Jason Coleman (2/5/2011)

---

They are actually date time columns.... MySQL allows storage of this in a date time column as a dummy value.

The problem just is how to query the...

GSquared (2/4/2011)

---

If the next ice age kicks into gear in a year or two (my personal expectation based on nothing but how cool I think it would be; you are...

this is really a family of recipes, as all quantities are variable by choice.

This works with pork fillet, or veal fillet, thinly sliced.

Cut the meat into strips about 1.5 in...

Tom.Thomson (1/20/2011)

---

Days are sunny but short. Temperature about 14C (57F) at 7am and the same late evening, rising to...

Ray K (2/4/2011)

---

Getting quiet here again. Let's toss out another geography-related topic here . . .

Hypothetical: you just won an all-expenses-paid trip to anywhere in the world. Where...

Nice easy question.

It will be interesting to see how many manage to get it wrong.

Steve Jones - SSC Editor (2/3/2011)

---

I'm not calling out any particular person, and I've certainly been guilty of posting a few less than professional things in my time. I'm just...

Brandie Tarvin (2/3/2011)

---

This leads to another question. How easy is it to get a future tech job when you...

Cuarante y tres tastes better and contains more alcohol. And every one knows that 6 times 9 is 43, not 42 (provided they have first supped sufficient...

Perhaps

MERGE INTO codes_table C

USING (

SELECT *,

ROW_NUMBER() OVER (

...

Brandie Tarvin (2/2/2011)

---

Next question:

How did you half-management / half-DBA types deal with the overload of DBA tasks?

I.E., say there's too much workload for the DBA team to handle in...

Nats007 (2/3/2011)

---

Hi

I've attached a SQL 2000 database to SQL 2008 (attached from backup files)

Compatibility mode is changed to: SQL Server 2008

Original database had replication on it and columns...

Here's an SQL 2005 version

UPDATE T SET T.PD_SeqNr = R.rnum

OUTPUT inserted.*

FROM Table T, (

SELECT PD_id, ROW_NUMBER() OVER (ORDER BY PD_id) as rnum...

Drat, I forgot it was sql 2005 ;-). I'll think about an update-based version