It will change according the month days, couz some months has 30 days and some of them 31, even February has 28 or 29 so the differences can be little...

Simple, minus 30 days from today! - exactly!

Yes, the web interface of the oracle is very nice environment to work!

The TOAD has many tools, and sometimes you didn't know which one to use!

Brad M. McGehee (5/21/2009)

---

No, I'm not the narrator. I did everything else, including writing the script. This was...

pedro.ribeiro (5/21/2009)

---

Ok, thank you very much for the help.

About the truncate.

If i have the recovery model in Simple mode, do i get any think by making a truncate instead of...

Yep I'm going for the part 2!

Nice presentation here Brad!

One question: Narrator = you (Brad M.McGehee) isn't it!?

😉

You should use ( \ ) or ( / ) as script terminator instead of (;)! I'm not sure is "/" or "\" :hehe:

Yep I said No, but if you think little bit more about creating DB details, you will said yes...the default for data file was mdf, ndf and for log files...

Yea great idea, and very nice post here Chris!

This one is enable in Oracle from 10g version if I'm not wrong!

Anyway, thanks for the script and explanation!

😎

Losing the point! :w00t:

Any strong reason why 50 - 50 !? We have documentation that 50 - 16 failover cluster!

:w00t::w00t:

Jack you just done it ... Sure that we don't need cursor here the best solution here is with CTE!

Really I don't have any idea how to take that backup sure that you cannot do it couz everything is temporary and also what do you need it! :hehe:

Yep, my friend Grant...

The biggest source in the world is BOL, you can check these two links with much information about indexed views:

http://msdn.microsoft.com/en-us/library/dd171921.aspx

http://msdn.microsoft.com/en-us/library/ms191432.aspx

In SQL Server 2008 you have possibility to create filtered index...