No cc needed xxx Fat girls chat lines

He has a point but a second network packet wouldn't cause the same delay as the roundtrip latency because the packets would be sent in tandem and would not require acknowledgement.

So it may cause far less delay than the actual network roundtrip latency.

We use it everywhere and a quick google shows plenty of SQL Server MVPs agreeing too. Now, this means to me that the SQLData Adapter is limited to utterly simply CRUD processing because it expects the "n rows affected" message to match.

So, I can't use: In the question marc_s (who knows his SQL stuff) says do not use it.

NET's If you're saying you might have different clients as well, there are problems with classic ADO if SET NOCOUNT is not set ON.

One I experience regularly: if a stored procedure executes a number of statements (and thus a number of "xxx rows affected" messages are returned), ADO seems not to handle this and throws the error So "generally keep nocount on, except when you are actually returning a resultset".

When I changed the ISOLATION level inside a stored procedure, it didn't change the connection behavior for the next command.EDIT 2: Here is a very detailed analysis about insignificant overhead of I guess to some degree it's a DBA vs. As a dev mostly, I'd say don't use it unless you absolutely positively have to - because using it can break your ADO. And I guess as a DBA, you'd be more on the other side - use it whenever possible unless you really must prevent it's usage.Also, if your devs ever use the "Records Affected" being returned by ADO.I don't know any ways that this can break any client code, it means client code never needs to know anything about the proc internals, and it isn't particularly onerous.Regarding the triggers breaking NHibernate, I had that experience first-hand.

Edit 5: Breaks JPA, stored proc with table variables: Does JPA 2.0 support SQL Server table variables?

Please or register to post comments
If spammers comment on your content, only you can see and manage such comments Delete all
You stuck in the elevator with a sexy schoolgirl. Undress her, grab her nice boobs, play with the nipples, push your fingers into her mouth and fuck her hard. 
13-Jul-2018 18:34
Reply
FreeOnes Game - fuck horny cyberbabes in 3D Sex Villa! Check out the hottest adult games in realtime 3D ! Interactive sex games - the worlds best virtual sex ! 
13-Jul-2018 18:40
Reply
It took me a lot of digging to find real benchmark figures around NOCOUNT, so I figured I'd share a quick summary. If your stored procedure uses a cursor to perform a lot of very quick operations with no returned results, having NOCOUNT OFF can take roughly 10 times as long as having it ON. 
13-Jul-2018 18:45
Reply

No cc needed xxx introduction

No cc needed xxx

Recent posts

13-Jul-2018 21:50
14-Jul-2018 07:08
14-Jul-2018 15:16