Por acaso voçê nao esta a lêr o meu blog so porque nao esta traduzido ao português?

Se for assim, so tem que me deixar um comentário para eu saber. Desde o início do blog, eu já pensei na posibilidade de fornecer o conteúdo tudo nao só em inglês mais também em português. Mas só estou com vontade de traduzir, se isso vai ajudar alguem da comunidade lusófona que na verdade tiver…

2

¿Hay alguien que esté dejando de leer este blog porque no está traducido al español?

Si es así, por favor, házmelo saber mediante un comentario. Desde el principio he barajado la posibilidad de proporcionar el mismo contenido en inglés y español, pero sólo si esto va a ser de ayuda a la comunidad hispanoparlante que realmente estuvieran interesados en seguir este blog de cerca.   ¡Gracias por vuestro apoyo!

1

Is SQL Agent manipulating the errors raised by SQL Server, before dumping them to the output file?

One customer reported that when he was executing the following batch use master exec sp_updatestats from SQL Server Management Studio (SSMS) he was getting different results than when the same stored procedure was ran from a SQL Server Agent’s Job. Specifically from a step of the T-SQL subsystem.   SSMS was showing the following output:…

3

Multiple Core and Hyper-Threading enabled CPUs and SQL Server 2005

One colleague recently asked me, is the information in this article 914278 (How SQL Server 2005 Express Edition determines the CPU count and uses the CPUs during processing) was also applicable to the Standard Edition of SQL Server 2005? And following is what I answered to him. The short answer is: Yes, it is applicable…

3

ExecuteCaptureLog doesn’t work with ErrorConfiguration

One colleague reported to me that the following code snippet (as it was being used by a customer) failed as explained in Connect -> AMO – ExecuteCaptureLog doesn’t work with ErrorConfiguration:   namespace MySamples.SqlServer {     class Program     {         /// <param name="args">The Analysis Services server to connect to (as args[0]).</param>         static void…

0

Unexpected "Tuning indexed views requires SQL Server 2005 Enterprise Edition"?

One day this week, I received the following query from a colleague. Run ScriptToPrepareRepro.sql in order to backup and drop a couple of indexes AdventureWorks. Start the Database Tuning Advisor and create a new tuning session. Select the Workload.sql script as workload file to run against AdventureWorks. On the “Tuning Options” tab, make sure that…

1

Flat File Provider and Decimal/Numeric data

Last week I received the following message from a colleague:   From: <Intentionally_Removed> Sent: Tuesday, November 13, 2007 2:30 PM To: <Intentionally_Removed> Subject: Flat File Provider and Decimal/Numeric data Hi All, I hope someone of you can help me in explaining the following behavior to customer J. Although I think it is by design, I…

0

Order in which DTS Packages are displayed from SQL Server 2005 GUI

Earlier this year somebody raised the following concern:   From: <Intentionally_Removed> Sent: Wednesday, April 18, 2007 10:23 PM To: <Intentionally_Removed> Subject: SQL 2005 : DTS Packages order of display… We noticed the following when trying to open DTS Packages in SQL 2005. It seems the order of display for all the versions of the package…

0