Understanding XML performance pitfalls in SQL Server
A deep dive into how SQL Server processes XML, the performance impact of XQuery methods, and why proper indexing matters.
A deep dive into how SQL Server processes XML, the performance impact of XQuery methods, and why proper indexing matters.
I have seen at a customer that the SQL Server’s policy doesn’t follow the Microsoft’s recommendations about antivirus and databases(kb 309422), such excluding *.mdf,*.ndf and *.ldf files. In addition the policy for Oracle doesn’t exist in case of Forefront Endpoint Protection 2010 known as FEP 2010.
I have decided to create databases policies for FEP optimized by dbi
…
Aprés une migration de 10gR2 vers 11gR2, une application utilisant les packages DBMS_XMLQUERY pour générer des documents xml est en erreur. Le format des dates a changé qu’a fait le DBA ?