And then you have this. I don't think the desert is big enough to hide in anymore.

And, am I still Saint?

Edit: The original post linked here has been...

Mangal Pardeshi (3/4/2009)

---

Sooner the better.

The rating thing, hard to know. I think if you consistently answer poorly,...

Jeff Moden (3/3/2009)

---

nwinningham (2/17/2009)

---

I have just spoken with the person who created this function. He said that he runs this report at night. So, since he runs this...

Here is some code you may want to try in a test environment. You will need to finish the code as the BACKUP LOG statement is incomplete.

declare @RowsDeleted int,

...

Jeff Moden (3/3/2009)

---

Lynn Pettis (3/3/2009)

---

Oh, wow. Looks like I may have beat Jeff. But of course, he is probably setting up a million row example to demonstrate his...

Oh, wow. Looks like I may have beat Jeff. But of course, he is probably setting up a million row example to demonstrate his code, where I just...

Samuel Vella (2/26/2009)

---

mh, your solution is fine but when you test it with a lot of data against a cursor, the cursor is orders of magnitude faster

I adapted your query...

The simple answer, no. You can't tell SQL Server which processor to use when a stored procedure is run.

Slightly...

I have to agree with both of you, little bit demanding. I'd say that Jeff is also correct in that the OP wants to audit all INSERT/UPDATE/DELETE activity on...

I know you said you had a solution, but I think you should also give the following a try:

CREATE TABLE...

Michael

If you read post numbers 666817, 666826, and 667164 above, you will see that on Moday you return the previous Monday through Friday. On Tuesday through Friday...

Yep, your right, I had a slight mistake in my code. Here is the corrected code:

declare @pDate datetime;

set @pDate = getdate();

select

dateadd(wk, datediff(wk, 0, @pDate -...

Have you tried turning your script into a stored procedure that you can then execute in a scheduled job?

If your partitioned tables are in separate filegroups you can do filegroup backups. You should check out BOL for more information on this.