----------------------------------------------------------- New Message on AhmedabadUserGroup
----------------------------------------------------------- From: jacobseb Message 1 in Discussion SQL Server SET Options, XQuery Labs and System Catalog Views I wrote a few SQL Server blog posts this week and I thought some of you might find them interesting. You can find the posts here: 1. How to find the amount of space used by data (.mdf, .ndf) and log (.ldf) files using TSQL - http://www.sqlserverandxml.com/2008/10/how-to-find-space-used-by-data-mdf-ndf.html 2. SQL Server 2008 SSMS Enhancements - http://www.sqlserverandxml.com/2008/10/sql-server-2008-ssms-enhancements.html 3. SQL Server SET Options: Do not depend on the DB level settings - http://www.sqlserverandxml.com/2008/10/sql-server-set-options-do-not-depend-on.html 4. Understanding SQL Server SET Options 4 - SET ARITHABORT ON | OFF - http://www.sqlserverandxml.com/2008/10/understanding-sql-server-set-options-4.html 5. Understanding SQL Server SET Options 3 - SET ANSI_PADDING ON | OFF - http://www.sqlserverandxml.com/2008/10/understanding-sql-server-set-options-3.html 6. UNPIVOT Example 2 - http://www.sqlserverandxml.com/2008/10/unpivot-example-2.html 7. XQuery Lab 38 - Delete elements having date value older than 30 days - http://www.sqlserverandxml.com/2008/10/xquery-delete-compare-date.html 8. XQuery Lab 37 - Working with multiple namespaces - http://www.sqlserverandxml.com/2008/10/xquery-with-multiple-namespaces.html I would love to hear your comments Regards Jacob Sebastian SQL Server MVP ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/AhmedabadUserGroup/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]