AboutThis blog is mostly about my work, but expect an occasional home project, productivity tip and tooling review.
Most used tags
Tag Archives: sqlserver
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
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
Error 14274: Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server
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