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 are comparing a query SELECT which uses an indexed column than one that doesn't, you will see a big difference in performance.
Read More Clustered Vs Non-Clustered Index
A quick post to see how to launch an SSRS subscription from SSIS.
It can be used as in my case for example to send by mail a report on the execution status of an SSIS package. Of course after inserting the logs of this package in a table, create a restitution report of these logs as well as a subscription which sends the report by email.
So how?
Read More Run an SSRS subscription with SSIS
In this article, I will explain some general queries to you. I think every developer should be aware of these queries. These queries are not related to a specific SQL topic. But knowing about such queries can solve some complex tasks and can be used in many scenarios, so I decided to write an article about these queries.
After creating our DimTime table in the 1st 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 codification in yyyymmdd format should be generalized to all levels of our time axis: year, semester, quarter, month, week ... I therefore suggest that each level (year, semester, quarter, month, week, day) be made up of three distinct attributes:
Read More Create a Time dimension with SSAS (DimTime) - Part 2
Here is a small SQL script to remove all objects in a schema from a SQL Server database:
Read More Remove all objects from a diagram