-
Introduction While attending a pre-conference session at SQLPass , I was captivated reading a slide regarding 'database capacity planning'. Paul Randal and Kimberly Tripp state that you should not rely on the 'arbitrary' autogrow (or even worse autoshrink) features of SQL server, but...
-
--------- QUERY withOUT XML nodes & EXIST SELECT Resume . query ( 'declare default element namespace "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume"; (/Resume/Name/Name.First)' ) FirstName FROM HumanResources . JobCandidate WHERE Resume . exist ( 'declare default element namespace...