Aaron Bertrand

I am a passionate technologist with industry experience dating back to Classic ASP and SQL Server 6.5. I am a long-time Microsoft MVP, speak frequently at conferences, and write at SQLPerformance and MSSQLTips. I recently joined the team at Wayfair and hope to blog about some of the scale challenges I've already started helping to solve.

6 Responses

  1. rider says:

    Any details on http://support.microsoft.com/kb/2711683 available? Seems like this bug manifests itself under very general conditions. According to the description it can occur for any CS index at all.

  2. DERRICK says:

    I just installed Microsoft SQL Server 2012 to be used with my Primavera  6.  During the setup Primavera is asking to configure sql server connection by requesting host name and database name.  I DO NOT know how to set these up on SQL Server, and anyone help…..

  3. AaronBertrand says:

    Derrick, did you try localhost? When you installed SQL Server did you install a default instance or a named instance? How can anyone know what the Primavera database name is? (Sorry, I have never heard of this application.) Have you talked to Primavera support at all? That is where I think you should take this. This blog post isn't a support forum. 🙂

  4. Mal says:

    Primavera db = PMDB

  5. Mark says:

    Last monday I installed cumulative update 2 for SQL Server 2012.
    While developing a BISM I wanted to add an extra column, so I added the extra column in the query of my source data. After validating the query, I pressed "Ok". When the load was done, all my measures where gone.
    Does anyone know a solution for this? The only way for me to add colums at this time is to generate a new table with the additional coluns, copy-paste all measure formulas to the new table and then drop the old table afterwards (don't forget to connect the new table to your dimensions), which takes about 100x more time.

  6. Helmut says:

    Hi All,
    The discovery report doens't get updated with the correct version number after installing CU2  (Ful-Text component):
    Microsoft SQL Server 2012 MSSQLSERVER MSSQL11.MSSQLSERVER Database Engine Services 1033 Developer Edition 11.0.2325.0 No
    Microsoft SQL Server 2012 MSSQLSERVER MSSQL11.MSSQLSERVER Full-Text and Semantic Extractions for Search 1033 Developer Edition 11.0.2100.60 No
    Update will not re-run.
    Any thoughts?
    TIA,
    HElmut