Viewing 15 posts - 706 through 720 (of 851 total)
Alvin Ramard (2/10/2009)
It's the DBA that is homicidal that you have to worry about.
[font="Verdana"]How do you distinguish them from normal DBAs?[/font]
February 10, 2009 at 2:10 pm
Jack Corbett (2/10/2009)
Of course you may be having your surgery done by a resident or intern that has not slept in 18 hours.
[font="Verdana"]I think everyone who has been involved in...
February 10, 2009 at 2:08 pm
[font="Verdana"]... especially if you factor in the cost of TOAD, which most Oracle shops seem to purchase. shudder[/font]
February 10, 2009 at 2:07 pm
GilaMonster (2/10/2009)
May I very politely and with the greatest respect suggest that it may be a better plan to read first and post second? 😉
[font="Verdana"]Fair comment. Shamefaced[/font]
February 10, 2009 at 1:52 pm
[font="Verdana"]True. I've used SQL Compare, or the schema compare as part of Visual Studio for Data Professionals. And it's not too hard to write a script to do...
February 10, 2009 at 1:48 pm
pparlapalli (2/10/2009)
set obsolete = 1
where c1+c2 IN
...
February 10, 2009 at 1:42 pm
[font="Verdana"]It's absolutely a new feature in SQL Server 2008. It's certainly not available in SQL Server 2005.[/font]
February 10, 2009 at 1:34 pm
[font="Verdana"]Gotcha. I did a little subsidiary reading on Books Online, and you're quite right -- cached query plans don't apply for views. Ah well. I learn something...
February 10, 2009 at 1:31 pm
[font="Verdana"]Oh, we are back to the unsubstantiated claims. 😀
One thing to bear in mind: Oracle is far more complex to set-up and administer from my personal experience than is...
February 10, 2009 at 1:26 pm
[font="Verdana"]have you tried using char(10) as the row terminator?[/font]
February 10, 2009 at 1:20 pm
[font="Verdana"]I suddenly got this mental image of a similar board for GPs, and the questions that get posted...
"Urgent! Urgent! Urgent! I have someone in my office who is sneezing!...
February 10, 2009 at 1:18 pm
[font="Verdana"]You're probably right as to why your trigger isn't working. I suggest you remove the joins.
Also, look at a different solution than a trigger. A trigger is the...
February 10, 2009 at 1:13 pm
[font="Verdana"]Invent a time machine. Sell me one. :D[/font]
February 10, 2009 at 1:06 pm
[font="Verdana"]Other than the issue of the "order by" already mentioned (with or without extra coffee), there's are a couple of other minor differences between using views and not.
You can create...
February 10, 2009 at 12:58 pm
[font="Verdana"]Some good answers. I would only add a couple of caveats.
SQL Server (by default: yes, you can change it) is case insensitive, case preserving. That means if you...
February 10, 2009 at 12:43 pm
Viewing 15 posts - 706 through 720 (of 851 total)