Tag Archives: sqlserver

EF query optimisation

Posted on June 7, 2017 by

We have a view that is very slow when you don’t use a filter on the name field. Everywhere in our stored procedures and (sub)queries we have this applied. In our web applicatie we use Entity Framework. The business layer … Continue reading →

Posted in Development | Tagged , , , | Leave a comment

Update statistics from stored procedure (needs alter table permission)

Posted on May 24, 2017 by

Today instead of the beautiful information our reports displayed this ugly error An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset ‘StoredProcedure’. (rsErrorExecutingCommand) For more information about this error navigate to the report server on the local server … Continue reading →

Posted in Development | Tagged , , , , , | Leave a comment

Error 14274: Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server

Posted on April 12, 2017 by

We use SSIS packages to import files. These SSIS packages are run with sqljobs. During deployment the sqljobs are created with a script. That is the plan. While running the script to create the sqljobs we got an error: Error … Continue reading →

Posted in Development | Tagged , , , | Leave a comment

Start-SqlJobAndWait

Posted on November 9, 2016 by

We have some SqlJobs that we run in our regression tests. To automate this we need something that can start the job and wait for it to finish. Based on this post we know we need to poll the sysjobhistory … Continue reading →

Posted in Test, Tooling | Tagged , , , | Leave a comment

Performance tuning EF, ASP.NET and loadtest

Posted on December 14, 2015 by

We are developing webservices for accessing data in SQL Server. The performance requirement was not met until we started to tune our solution. TLDR: use table in stead of view EF First we added the AsNoTracking() extension from EntityFramework to … Continue reading →

Posted in Development | Tagged , , , , , , | Leave a comment

XML data type for storing messages

Posted on September 7, 2015 by

We want to store xml message in a database for batch processing, logging and retention. For some time now Sql Server offers the xml data type for columns. This way we could index the xml, validate it with an xsd … Continue reading →

Posted in Development | Tagged , , , | Leave a comment

Allow incompatible platform in schema comparison

Posted on June 4, 2014 by

Schema comparison of SQL Express 2012 database and SQL Server 2008 gives an error A project which specifies SQL Server 2012 as the target platform cannot be published to SQL Server 2008. Set the allow incompatible platform in the options … Continue reading →

Posted in Tooling | Tagged , | 2 Comments