If your table is partitioned (only in Enterprise Edition if I'm not mistaken), you can easily swich out an older partition. This goes really fast.

Otherwise, you can use the DELETE...

Do you really need two topics for the same question?

Orginal topic can be found here:

http://www.sqlservercentral.com/Forums/Topic1044315-146-1.aspx

I've read it more times then you think.

But I'm still wondering why you are using mdf files and backup.

If...

Don't we all?

Brandie Tarvin (1/7/2011)

---

Don't forget the Mayans, Tom. While they didn't use it in actual math calculations, they understood the concept of zero, nothing, and the need for a placement device...

Ah allright, that...

How far does your cynicism scale go?

Or does it just go up to...

You forget to mention the TSQL Merge statement (if SQL Server 2008) in your blog post.

p.s....

In your first post you said you couldn't use management studio or other tools.

Is this still the case?

raj.lath-932078 (1/7/2011)

---

Now its a very elegant and simple solution for peoples who do not have enough knowledge of handling sqlserver.It takes under a minute to do the whole backup so...

qur7 (1/6/2011)

---

Hello All,

Yesterday my new boss gave me this assignment on SSIS , I am hoping some one of you might have gone through it or has an idea,...

When using .mdf files, isn't attach the preferred method instead of backup?

Backup is intended to restore .bkp or .trn files, if I'm not mistaken.

What makes you thinks there are jobs created?

Database mirroring uses endpoints to transfer messages with TCP.

See

http://msdn.microsoft.com/en-us/library/ms179511(v=SQL.90).aspx

http://msdn.microsoft.com/en-us/library/ms189852(v=SQL.90).aspx

TST1 (1/7/2011)

---

Hi,

I'm trying to drop and create a table but I am getting error:

"INSERT failed because the following SET options have incorrect settings: 'ANSI_PADDING'. Verify that SET options are...

If these doubts are not related to each other. Yes.

If you only have one topic, with...