Thanks, Luke. I appreciate the feedback! 🙂

Holy moly... good thing we're not doing deletes or it would also be deleting from a bazillion indexes (some with duplicate functionality). My recommendation would be to simply drop...

madhu.arda (12/2/2008)

---

thanks Jeff,

This script is giving the mdf and ndf file. But I would like to get the actual space allocated for datafile and the available space inorder to monitor...

Heh... Simple, effective, and fast... no chance...

Heh... two way street here, MD... share your solution. Where did you find...

philcart (12/3/2008)

---

Why you would want to do this in VB and SQL Server is beyond me. Like Jeff says, you don't need to go anywhere near the database for the...

John Barry (12/3/2008)

---

Jeff,

So are you saying that instead of creating a row at a time in the live table, stamping each one with a sequence number as you insert it,...

Yes... everything is possible... but what are you going to do if there are 40 rooms on the same floor?

umanpowered (12/3/2008)

---

Hi,

As a side question, do you know...

David Leaver (12/3/2008)

---

Yikes - Dip, Dive, Duck and Dodge! Doesn't pay to leave the forums for a few hours.

Here's the scenario - I'm taking an existing procedure that historically...

Trebuchet... the ultimate pork chop launcher... can launch the whole pig and makes statements followed by "When pigs fly" come absolutely true. 😛

I see a bunch of stuff in that code snippet that I think is working against you. Please post the real table creationtion statement for the table you're deleting...

I solved a post, last night, using the SIGN function instead of CASE for a pretty good performance gain. It reminded me of what my original programming mentor taught...

You bet... thanks for the feedback.

Bob Hovious (12/3/2008)

---

... and now I know there is a SIGN function... which of course returns just exactly what is needed for setting the "bits". Remind me never...