At this point I am not sure. I would have to research it, but hopefully, someone else here know the answer and will chime in.

Well, if we're looking for examples, a Fourier Transform would proabably be a good candidate for CLR.

I know it's redundant, but I think that my earlier post really bear repeating here:

rbarryyoung (6/2/2008)

---

I'll just add that you really should have an experienced DBA or DB developer involved...

Well said, Steve.

I often wonder how may people in our industry realize that their jobs, careers and the whole or IS and the Software industry is dependent on intellectual property...

See my post here, for some background... http://www.sqlservercentral.com/Forums/Topic514855-1291-1.aspx#bm515159

grevesz (6/10/2008)

---

Thanks guys for the responses! I haven't had time to test this yet, but I will tomorrow.

In the mean time, could you please direct me to some reading material...

Jack is right, of course. So I wanted to take a minute to highlight the difference between these two suggestions.

My two suggestions (called Snapshots or Row Versioning) allow users...

kaykay005 (6/10/2008)

---

But how can we move the indexes from these tables. I know we can script the indexes and run at the new location . But is there any other...

Use either:

ALTER DATABASE {yourDB} SET READ_COMMITTED_SNAPSHOT ON;

Or,

ALTER DATABASE {yourDB} SET ALLOW_SNAPSHOT_ISOLATION ON;

And then have the Deleting proc start its transaction like this:

SET TRANSACTION ISOLATION LEVEL SNAPSHOT;

BEGIN TRAN

The first...

Yes, please do.

I had considered that as an option, but was concerned that I would be taking on even more problems.

bump.

Steve Jones - Editor (6/10/2008)

---

We definitely need a GUI for Service Broker. I'm not sure one's coming in SQL 2008, but there is a lot of work being done on...

If you prefer your own editor, that's great. Many do still use custom editors. But the Wizards are another story, ultimately, they are just limiting.

Yes, you have to...

Ah, yes. You are using the View wizard as GSquared surmised.

Here's how to fix that: Never use the View wizard. Use query windows instead.

The View wizard is...