Jeff Moden (1/14/2011)

---

Actually, it's not quite so easy to pull off in the presence of DRI. You'll need code to identify dependencies and that's not always the easiest thing...

dajonx (1/14/2011)

---

Thank you, David!

I understand that all of the categories are important, but is there some sort of "ranking" that I could use as a guideline? In your example,...

Dj463 (1/14/2011)

---

Hello all,

I need a dynamic sql script to loop through all the tables in a database and delete records older than certain date.

Note: i dont want to use sp_msforeachtable...

@BaldingLoopMan: Loop code has its place, but when the OP specifically states things are taking too long, it's time for that method to move on. In general: if they're...

AndrewSQLDBA (1/14/2011)

---

Nope, not homework. I am a little old to be going to school. I like the ides that you gave for the design of the databases.

What I am wondering...

GilaMonster (1/14/2011)

---

This should do the same.

Index on row_id and it should be OK, though not great performance.

select *

from Table_1 a

inner join Table_1 b on a.rowid = b.rowid -...

This is a performance hog, and if this is something you need to regularly run rather than as a cleanup item for the next few days, I'd recommend looking into...

Something like this?

select

HandheldDeviceActivityID,

Device,

UploadDevice,

DownloadAppVersion,

UploadAppVersion,

REtry,

Received,

UploadFileGuid,

Processed,

Created,

ReceivedDate

from

HandHeldDeviceActivity

where

companyid = 1

and created > '2010-12-1'

--Absolute of diff in minutes between these two time fields.

AND ABS( datediff(...

pwalter83 (1/14/2011)

---

Hi Jeff,

Here is the updated scenario:

If POL_COUNTRY_CD or POD_COUNTRY_CD in NCV_BL_DHL_TEMP table begins with FR, then use POL_Location_CD / POD_Location_CD and join to MG_LOCATION table to identify continent. If...

djackson 22568 (1/13/2011)

---

Yeah, by the Brits! The Australians...

Party on, dude! Congratulations.

^ What he said, or alter your source table to store the data at the proper precision, which looks like you want decimal ( x, 2).

They were those things...

GSquared (1/13/2011)

---

The problem is it would break every single vending machine in the country. Yes, that's the actual primary objection to plastic coins. The Treasury did feasability studies,...

WayneS (1/13/2011)

---

You're in the LA area? I thought you were in...