Viewing 15 posts - 316 through 330 (of 789 total)
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...
May 22, 2009 at 5:55 am
shanila_minnu (5/22/2009)
DATEADD(d,-30,GETDATE())..please explain me the parameters of this sql date function...wat will it return
Simple, minus 30 days from today! - exactly!
May 22, 2009 at 5:53 am
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!
May 22, 2009 at 3:29 am
Brad M. McGehee (5/21/2009)
Dugi (5/21/2009)
Nice presentation here Brad!One question: Narrator = you (Brad M.McGehee) isn't it!?
😉
No, I'm not the narrator. I did everything else, including writing the script. This was...
May 22, 2009 at 12:27 am
pedro.ribeiro (5/21/2009)
About the truncate.
If i have the recovery model in Simple mode, do i get any think by making a truncate instead of...
May 21, 2009 at 7:46 am
Yep I'm going for the part 2!
May 21, 2009 at 6:51 am
Nice presentation here Brad!
One question: Narrator = you (Brad M.McGehee) isn't it!?
😉
May 21, 2009 at 6:46 am
You should use ( \ ) or ( / ) as script terminator instead of (;)! I'm not sure is "/" or "\" :hehe:
May 20, 2009 at 6:29 am
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...
May 20, 2009 at 3:13 am
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!
😎
May 20, 2009 at 3:01 am
Losing the point! :w00t:
Any strong reason why 50 - 50 !? We have documentation that 50 - 16 failover cluster!
:w00t::w00t:
May 20, 2009 at 2:54 am
Jack you just done it ... Sure that we don't need cursor here the best solution here is with CTE!
May 12, 2009 at 7:03 am
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:
May 7, 2009 at 1:41 pm
Grant Fritchey (5/6/2009)
You can call it from the command line. If you had to do it through TSQL, you could use xp_cmdshell, but I wouldn't recommend it.
Yep, my friend Grant...
May 6, 2009 at 5:51 am
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...
May 4, 2009 at 5:46 am
Viewing 15 posts - 316 through 330 (of 789 total)