SQL Feeds - All your SQL feeds in one place.

Monday, March 09, 2009

Understanding the error “An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full.”

by SQL Protocols via SQL Protocols on 3/9/2009 8:11:00 PM

This error message, which is associated with the Winsock error WSAENOBUFS and actually comes from Windows rather than SQL Server directly, has two well-understood root causes. However, it still stumps people today, probably because  there is no single source which explains both root causes and offers solutions for both. Here is a description of the two common situations where you may see this error and quick solutions for each: OS runs out of memory for TCP buffers When a powerful clie ...

[ read more ]

Tipping Point Queries - More Questions To Really Test You!

by kimberly.nospam@nospam.sqlskills.com (kltripp) via Kimberly L. Tripp on 3/9/2009 8:28:00 AM

OK, so this is interesting. I've got a few answers to my last survey (Tipping Point Query #1) and well, there's a good mix of answers (and, yes, some are correct! ;)). Be sure to go back and review that last post so that you can evaluate it and these two tipping point questions completely. So, now I want to see if people really know the basis of "the tipping point". Try these two: Tipping Point Query #2 Table1 (t1) has 1 million rows at 100 rows per page. The table ha ...

[ read more ]

Subscribe

New Feed

Product Spotlight

Recently Updated Sources

Legal Note

The content of the postings is owned by the respective author. SQL Feeds is not responsible for the contents of the postings. This site is automatically generated and cannot be reviewed for abusive content. If you find abusive content on SQL Feeds, please contact us. Designated trademarks and brands are the property of their respective owners. All rights reserved.

Advertise with us