November, 2007

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...

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...

KB Article 943525 (You cannot start the SQL Server Agent service of a failover cluster of SQL Server 2005 if the build of SQL Server build is 3179 or a later build), in its first revision (November 21, 2007), it enumerated three different workarounds...

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...

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...

One colleague asked me that question in order to answer one of his customer's multiple questions. The answer is four gigs (4GB), no matter whether boot.ini includes /3GB or not. In fact in x64 OS, that switch is simply ignored by the OS. In case what...

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 {    ...

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...

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...

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...

This is fixed starting with CU6. More info in this post . I recently analyzed an issue reported by one customer who had an SSIS package which was repeatedly opening connections against an existing and working named instance of Analysis Services 2005,...

Members of db_ddladmin fixed database role or users who have explicitly been granted CREATE TABLE permissions cannot alter the table using VDT. If you are connected to an instance of Yukon with a login whose mapped user in a given database is either a...

This is the story of a case which took me some time to diagnose, and which I considered worth sharing, not because it's potential to become a common problem in many customer scenarios, but more because how interesting the troubleshooting steps could be...

Yeap! Believe or not, I started blogging here. :-)