SQL Server Database Development

SQL SERVER tuning tip:

A query with OR clauses in many cases can be rewritten as a series of queries that are combined with a UNION statement in order to boost the performance of the query.
Although we need to make sure that for every column used in OR expressions we have an index. This way indexes will be used instead of table scan.

	SQL Server Database Development

When high level architecture and design are done, the most important part is how well it is implemented. This is where you need great database developer. Poorly written code or simply bad implementation can easily ruin your database performance and will require a lot of maintenance and re-development in the future. Some people say: "I am not that rich, to buy cheap things so they will break tomorrow". I say, that you can have your code to be written the right way and only once, saving you time and money.

While our main focus is highly optimized efficient code, we are using full power of SQL Server:

Latest T-SQL features
XML functionality
Partitioned Tables, Materialized Views
CLR functions, procedures, triggers
Service Broker
Fulltext Search
Geo Spatial
Optimization hints etc.

Depending on the task we choose the best out of the tools offered:

SQL Server Intergation Services
SQL Server Reporting Services
SQL Server Analysis Services
Replication
etc.