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...

Or you can use EXISTS:

SELECT

sno, sname, address,

CASE

WHEN EXISTS(SELECT 1 FROM dbo.StudentDrillEnrolled sde WHERE sde.sno...

Check out OBJECT_DEFINITION(). That returns a single nvarchar(MAX) that is the whole procedure, rather than 255 characters per row (artificial "line"?) that sp_helptext seems to do.

I find it useful...

In SQL 2008, if you want a specific user to be able to execute any stored proc (existing ones and newly created ones), you can do this:

USE <your_db_name>

GRANT EXECUTE TO...

Lynn Pettis (3/5/2013)

---

ScottPletcher (3/5/2013)

---

Lynn Pettis (3/5/2013)

---

ScottPletcher (3/5/2013)

---

Jeff Moden (3/4/2013)

---

I'd love to take the credit for it but it's not my code. It's Scotts (although I'd have done it the...

There's no physical db differences from Enterprise to Std, so if the SQL version numbers are the same, you should be able to restore all dbs, including system dbs, from...

Lynn Pettis (3/5/2013)

---

ScottPletcher (3/5/2013)

---

Jeff Moden (3/4/2013)

---

I'd love to take the credit for it but it's not my code. It's Scotts (although I'd have done it the same way).

I was...

Jeff Moden (3/4/2013)

---

I'd love to take the credit for it but it's not my code. It's Scotts (although I'd have done it the same way).

I was just curious as...

GilaMonster (3/4/2013)

---

ScottPletcher (3/4/2013)

---

Again, rigid overly-simplistic rules such as those will give you a poorly performing database with excessive nonclustered indexes to cover all the queries the clus index can't because...

Jeff Moden (3/4/2013)

---

@Scott,

Where in the world did I suggest using a format code...