SQL Tuning author Dan Tow outlines a timesaving method he's developed for finding the optimum execution plan rapidly and systematically regardless of the complexity of the SQL or the database platform being used. You'll learn how to understand and control SQL execution plans and how to diagram SQL queries to deduce the best execution plan for a query. Key chapters in the book includes exercises to reinforce the concepts you've learned. SQL Tuning concludes by addressing special concerns and unique solutions to "unsolvable" problems.

The Windows Sockets specification defines a network programming interface for Microsoft Windows [1] which is based on the "socket" paradigm popularized in the Berkeley Software Distribution (BSD) from the University of California at Berkeley. It encompasses both familiar Berkeley socket style routines and a set of Windows-specific extensions designed to allow the programmer to take advantage of the message- driven nature of Windows. The Windows Sockets Specification is intended to provide a single API to which application developers can program and multiple network software vendors can conform. Furthermore, in the context of a particular version of Microsoft Windows, it defines a binary interface (ABI) such that an application written to the Windows Sockets API can work with a conformant protocol implementation from any network software vendor. This specification thus defines the library calls and associated semantics to which an application developer can program and which a network software vendor can implement. Network software which conforms to this Windows Sockets specification will be considered "Windows Sockets Compliant". Suppliers of interfaces which are "Windows Sockets Compliant" shall be referred to as "Windows Sockets Suppliers". To be Windows Sockets Compliant, a vendor must implement 100% of this Windows Sockets specification. Applications which are capable of operating with any "Windows Sockets Compliant" protocol implementation will be considered as having a "Windows Sockets Interface" and will be referred to as "Windows Sockets Applications". This version of the Windows Sockets specification defines and documents the use of the API in conjunction with the Internet Protocol Suite (IPS, generally referred to as TCP/IP). Specifically, all Windows Sockets implementations support both stream (TCP) and datagram (UDP) sockets. While the use of this API with alternative protocol stacks is not precluded (and is expected to be the subject of future revisions of the specification), such usage is beyond the scope of this version of the specification.

This is the Winsock Programmer's FAQ, a more-or-less official continuation of the original FAQ by Mark Towfiq et al. This FAQ will try to answer the most commonly-asked questions on the alt.winsock.programming and comp.os.ms-windows.programmer.tools.winsock newsgroups.

In recent years there has been a growth in the availability and popularity of both undergraduate modules and taught postgraduate courses in the broad field of forensic psychology. Indeed the term ‘forensic’ has been increasingly juxtaposed with a range of areas of academic study e.g. analysis, anthropology, archaeology, computing, engineering, investigation, measurement, psychobiology, psychology and science (UCAS, 2008). This is also evident in much professional practice, both within the field of health (e.g. psychiatric nurses, psychiatrists, occupational therapists and social workers) and beyond (e.g. accountants and computing specialists).

Will 'making a Living' remain a dream for the deprived and excluded? Jobs are one of Europe's most important problems. Employment provides the basic means of distributing wealth in society, in providing for families, and ensuring pensions for the elderly. Yet unemployment, and increasingly 'non-employment', continues at near record levels in the European Union. Making a Living in Europe shows how the culture of work has been transformed in the industrialised nations of the EU. Exploring the relationship between employment change, society and economic restructuring, the shift toward 'flexible' work for women in services, away from traditional industrial jobs for men, is demonstrated within three key sectors: business services, retailing and tourism. The outcome of change is discussed in terms of shifts of people and jobs from urban to rural areas. Europe must be understood in the context of the new Europe, of change in the USA and of global change. Drawing on examples from UK and European Regions and USA, the author challenges long-standing assumptions about changes in economy and society and highlights the need for stronger local and European policies to reduce inequality at large and contribute positively to local people's struggles to make a living in Europe.