You really should learn anything about DBs. I mean: anything. Sorry, but asking such question you only shows, that you don't understand the very basics. Don't ask about cooking if you can't boil water. You are asking: "should I use purple bucket or ceramic flowerpot"?
No, definitely not a usage ...
@dezso I'm not saying that they can't find the answer by themselves, I jus twould hope that the tool would assist them sometime in not having too -- and thus being more productive, and that if they were here answering questions they would also contribute with their own, likely being more capable to word the question then others
I mean as far as net impact, my greatest contribution is probably asking and not answering questions on the site.
Impact at Android.SE a StackExchange I almost never use, is ~673k, my impact here -- a site I use all the fucking time -- ~690k. I'd say the amount of time spend on Android.SE is <1% of the time I've spent here.
Paternosters look fun, but (as far as I know, at least in Western Europe) they have almost all been replaced by regular elevators for safety reasons. Are there any publicly-accessible paternosters left I can ride in? Wikipedia mentions a few, but they seem to be in private buildings.
If you ca...
Oracle - DBMS_OUTPUT.PUT_LINE does not print anything and SET SERVEROUTPUT ON is not working.
It would be really useful to test PL/SQL programs. Is there any other way to see this output, other than creating a function and seeing output from a select?
@paulw - yah, I get that, just was wondering why you'd setup the database for RCSI but then try to use read committed. When I wrote .Net code against RCSI-enabled databases, I never specified any isolation mode, since I wanted the RCSI behavior. — Max Vernon42 secs ago
@MaxVernon I'm struggling to understand what you're saying tbh.
What does "try to use read committed" mean?
@MaxVernon One cannot specify RCSI explicitly. Ask for read committed and you either get the locking or row versioning RC implementation, depending on the database setting READ_COMMITTED_SNAPSHOT. — Paul White ♦45 mins ago
Well the comments will go away of course, but I want to understand the point.
> I do actually want to use read committed snapshot isolation, but don't know how to set that in dotnet (client).
That's like saying one wants to use RCSI, but don't know how to set it in SSMS or sqlcmd or osql etc.
There is no setting. You request the read committed isolation level and SQL Server gives you RCSI or locking read committed depending on the database config.
Paternosters look fun, but (as far as I know, at least in Western Europe) they have almost all been replaced by regular elevators for safety reasons. Are there any publicly-accessible paternosters left I can ride in? Wikipedia mentions a few, but they seem to be in private buildings.
If you ca...
Oracle - DBMS_OUTPUT.PUT_LINE does not print anything and SET SERVEROUTPUT ON is not working.
It would be really useful to test PL/SQL programs. Is there any other way to see this output, other than creating a function and seeing output from a select?
