No one? 🙁

GilaMonster (12/10/2010)

---

bas de zwart (12/10/2010)

---

Now I could leave the DB running the rest of the month with 65% free space but that wouldn't be very effective in terms of fragmentation...

Wow. I think I have to disagree for a part.. But that might have to do with the fact that we have different sort of environment than most. Once a...

Yup, that's the one. 🙂

Been using that to import millions of rows and very quickly at that.

You could try the Bulk Insert command, it has an option to limit the number of rows:

http://msdn.microsoft.com/en-us/library/aa225968%28SQL.80%29.aspx

Thanks everyone for your insights. I have to be honest and have been playing a bit of the devils' advocate. I often use the (top x *) statement too, especially...

What happened to "right click in SSMS > script to 'select'"??

Works like a charm, I still haven't seen any technical reasons for this option to be here besides being a...

Using Mixed mode is our company policy, simply because we want to be able to administrate our SQL servers even if the Domain Controller is offline. We make sure that...

I second this...

When I had made a backup schedule for our 85 databases in the network I had put all verification options 'on' in our external backup software program (that time we...

I almost can't believe that *any* recovery model is presented like this as a 'best practice'; and certainly not as WHY you SHOULD be using this or that recovery model.

It...

We've been using a different variant on this, first there's a job that runs every hour that mails us the results of the following view:

SELECT CONVERT(DATETIME,...