Clustered Vs Non-Clustered Index

The difference between the index clustered et Non-clustered in a database is one of the most popular questions in SQL.

Indexes are a very important concept, it makes the execution of your queries fast and if you compare a query SELECT which uses a column indexed to the one that does not, you will see a big difference in performance.

Read More Clustered Vs Non-Clustered Index

Run an SSRS subscription with SSIS

A quick post to see how to launch an SSRS subscription from SSIS.

It can serve as in my case for example to email a report on the execution status of an SSIS package. Of course after inserting the logs of this package in a table, create a report of return of these logs and a subscription that sends the report by mail.

So how?

Read More Run an SSRS subscription with SSIS

Useful SQL queries

In this article I will explain some general queries. I think every developer should know about these queries. These queries are not related to a specific topic of SQL. But knowledge of such queries can solve some complex tasks and can be used in many scenarios, so I decided to write an article about these queries.

Read More Useful SQL queries

Create a Time Dimension with SSAS (DimTime) - 2 Part

After creating our DimTime table in the 1ages part of this article, we will now make some improvements on our dimension.

From experience, I would recommend using a key PKDate int type in format yyyymmdd.

This type of key will allow you to get better performance.

This coding in the format yyyymmdd should be generalized at all levels of our axis time: year, semester, quarter, month, week ... So I suggest that each level (year, semester, quarter, month, week, day) be composed of three distinct attributes:

  • Code
  • Date
  • Name

Read More Create a Time Dimension with SSAS (DimTime) - 2 Part