tailieunhanh - Defensive Database Programming with SQL Server

The goal of Defensive Programming is to produce resilient code that responds gracefully to the unexpected. To the SQL Server programmer, this means T-SQL code that behaves consistently and predictably in cases of unexpected usage, doesn't break under concurrent loads, and survives predictable changes to database schemas and settings. Inside this book, you will find dozens of practical, defensive programming techniques that will improve the quality of your T-SQL code and increase its resilience and robustness. . | High Performance SQL Server Defensive Database Programming with SQL Server Alex Kuznetsov Defensive Database Programming with SQLServer By Alex Kuznetsov Technical Review by Hugo Kornelis First published by Simple Talk Publishing 2010 Copyright Alex Kuznetsov 2010 ISBN 978-1-906434-44-1 The right of Alex Kuznetsov to be identified as the author of this work has been asserted by him in accordance with the Copyright Designs and Patents Act 1988. All rights reserved. No part of this publication may be reproduced stored or introduced into a retrieval system or transmitted in any form or by any means electronic mechanical photocopying recording or otherwise without the prior written consent of the publisher. Any person who does any unauthorized act in relation to this publication may be liable to criminal prosecution and civil claims for damages. This book is sold subject to the condition that it shall not by way of trade or otherwise be lent re-sold hired out or otherwise circulated without the publisher s prior consent in any form other than that in which it is published and without a similar condition including this condition being imposed on the subsequent publisher. Technical Review by Hugo Kornelis Technical edit by Tony Davis Cover Photography by Paul Vlaar Photodynamic Typeset Designed by Matthew Tye Gower .