Viewing 15 posts - 8,446 through 8,460 (of 9,248 total)
SQL developer can be used with Microsoft databases you just need to obtain and install the java library
February 10, 2009 at 5:29 pm
maybe you're confused. You select from a view not execute. As noeld said just grant select on the view to whatever role\user
February 10, 2009 at 2:43 pm
Gift Peddie (2/10/2009)
I have used most and Oracle's SQL developer is not as good as SQL Server Express management studio.
snigger, and you think my statement was emphatic ROTFL
February 10, 2009 at 2:38 pm
Bruce W Cassidy (2/10/2009)
[font="Verdana"]One thing to bear in mind: Oracle is far more complex to set-up and administer from my personal experience than is SQL Server.
no one could argue...
February 10, 2009 at 1:39 pm
out of interest, what are your current min and max memory settings?
how many instances of sql?
February 10, 2009 at 7:00 am
Steve
yes i read into it that he just wants to test and sanitise the actual restore processes required so if he ever has to do it for real he'll have...
February 10, 2009 at 6:10 am
hey dont get me wrong i like SQL server and as you say price\performance you cant beat it. By flexibilty i am referring to the scalability of the Oracle cluster,...
February 9, 2009 at 4:35 pm
for your user databases, yes. Either backup and restore to the 64bit server or detach\attach the database files.
February 9, 2009 at 4:14 pm
Andrew Reilly (2/5/2009)
yet when the redundanies came it was all of the most experienced staff (and highest paid presumably) that got the chop.
i've worked for 2 software houses now in...
February 9, 2009 at 3:47 pm
Oracle is by far the most powerful and flexible of the two.
In Oracle RAC the distributed cache memory is shared between the cluster nodes and this offers failover and...
February 9, 2009 at 3:42 pm
Steve Jones - Editor (2/9/2009)
February 9, 2009 at 2:57 pm
jbloes (2/9/2009)
I couldn't find a free MS Virtual Server...do you have the link?
http://www.microsoft.com/technet/virtualserver/software/default.mspx
you will need to register, thats the only requirement.
Steve (2/9/2009)
February 9, 2009 at 2:47 pm
select * from ::fn_trace_getinfo(default)
peace2007 (2/8/2009)
My traceid is 2 and fn_trace_getinfo shows nothing for that;)
using the exact command above what traces does it show?
February 8, 2009 at 4:03 pm
SQLBOT (2/8/2009)
My advice is when going 12 GB or higher to ditch the /3GB switch..
the official standpoint is 16GB RAM but i have seen situations where systems with a lot...
February 8, 2009 at 3:53 pm
i wouldnt personally enable\use xp_cmdshell
schedule a windows task to run a batch file. The batch simply copies the file from one location to the other (maybe a mapped drive to...
February 8, 2009 at 3:15 am
Viewing 15 posts - 8,446 through 8,460 (of 9,248 total)