Welcome to Sign in | Join | Help

februarie 2013 - Posts

SQL Server 2012 installation has the potential to leave an msiexec.exe installer process running after the installation finishes, as described in Windows Installer starts repeatedly after you install SQL Server 2012 SP1: After you install SQL Server 2012 Read More...
SQL Server 2012 SP1 has shipped a great enhancement to XML: Selective XML Indexes. When properly used these indexes can speed up the searching of XML columns tremendously, at little disk/size cost: The selective XML index feature lets you promote only Read More...
The SMO object model for SQL Server ServiceQueue does allow one to enable or disable a queue, but the property that modifies the queue status is not intuitive, it is IsEnqueueEnabled: Gets or sets the Boolean property that specifies whether the queue Read More...