select dateadd(day, -3, dateadd(week,-4,getdate()));

Sqlism (3/11/2013)

---

Hi Experts,

Is this is the Best Practice to select E: for the SQL Server root directory? Please let me know the Pros/cons and the practices to be followed.

Thanks a...

Maybe code below will do what you need.

I haven't tried for efficiency, just to get the result you want.

select

a.a, a.b, a.c

from @a a

left outer join (

...

opc.three (3/8/2013)

---

No, not unless RECURSIVE_TRIGGERS is ON. It...

Hmm, seems to me that in this case the query is the same either way, with exactly the same WHERE clause structure.

The only difference is that the WHERE comparison value,...

Sure, that's easy, as long as you have unique column(s), such as an IDENTITY column, you can use to identify a specific row in the table. SQL provides a...

Lynn Pettis (3/7/2013)

---

ScottPletcher (3/7/2013)

---

Sorry, not to rain on the parade, but to me now is not the time to celebrate.

Getting the job is good, but it's just the start. ...

Sorry, not to rain on the parade, but to me now is not the time to celebrate.

Getting the job is good, but it's just the start.

Dedicate yourself to...

Gazareth (3/7/2013)

---

ScottPletcher (3/6/2013)

---

To confirm, try writing the results returned by OBJECT_DEFINITION() to an nvarchar(max) column and checking the length of that column: I think you'll find that the entire code...

SAinCA (3/6/2013)

---

@ScottPletcher

Not sure if what you are saying is that "it didn't happen the way I said it did..."

READ_COMMITTED_SNAPSHOT isolation is set ON for the database in question.

In order to...

SAinCA (3/6/2013)

---

Please, if you're on SQL2005, watch out that you have sufficient TEMPDB space to accommodate all those deleted rows.

When a row is deleted, it is stored in TEMPDB as,...

Edward.Polley 76944 (3/6/2013)

---

Agreed the count method consumes resources so initially against huge tables I hard code the count. Say the table has 50 million rows to remove, no point...

sqlnaive (3/6/2013)

---

Yuvipoy/Lynn,

I agree with both of you. Infact i'm checking my code that way only. However my concern is if SQL is giving such an efficient way of checking a...

Like some others here, I'm not in favor of the "count" method of doing these DELETEs. In particular, if the process has to be stopped and then resumed later,...

Below is a start. Please don't skimp on the design phase, it will bite you later. Foreign key relationships are indicated by matching column names.

Be prepared, though: when...