Monthly Archives: November 2012

Job creation template

Not so long ago we have faced the following problem while implementing SQL jobs to test and production environment: Job is developed be developer by deployed to test or production by DBA. E-mail lists, folders are different on each environment. … Continue reading

Posted in Database development, SQL Server, Technology | Tagged , , | Leave a comment

SCHEMABINDING – use or not to use

One developer from my team has made the following suggestion: why not to alter all views we have in ERP system with SCHEMABINDING option? His main argument was: this would help us to set additional control for changes in tables’ … Continue reading

Posted in Database development, SQL Server, Technology | Tagged , | 2 Comments

Change data capture. Practice experience. Part 3.

In this post I would like to finish my Change Data Capture practice.  So I had not described the update of history table. All details about database structure can be found in the early post https://borisfrolovsqlservertips.wordpress.com/2012/10/28/change-data-capture-practice-experience-part-2/. As I have told … Continue reading

Posted in Database development, SQL Server, Technology | Tagged , | Leave a comment

Query optimization. How it works – one optimization hour from my practice.

In this post I would like to describe step-by-step process how a query can be optimized. This is taken from real practice I faced not so long ago. So, I’ve got a query that joined about 20 tables, had ORDER … Continue reading

Posted in Database development, SQL Server, Technology | Tagged , , , | Leave a comment