After using a SSIS for quite a lot I decided to develop a DTExec on my own. The reasons can be found in the feature set that I have I mind and I'd like to implement asap:
Read more →
To obtain all information on how a table has been partitioned I usually use two views:
The first just list all the partitened objects, showing the used partitioned scheme and function:
Read more →
In my previous post I said that "logging begins BEFORE validation and BEFORE package configuration". After talking with Mr. Kirk Haselden (who has been very kind and helped me to better understand how SSIS really works.
Read more →
I'm using SSIS in a big project and as any big project wants, I have to implement a quite extensive logging mechanism. "No problem" you may say. We'll, at least is what I said when I began to take care of logging.
Read more →
The implementation of the NTILE(n) windowing function is a little bit slow and requires a temp worktable that generates A LOT of I/O. Probably that because, as the BOL says, if you have a number of rows that is not divisible by your "n" bucket value, the function has to make the "Larger groups come before smaller groups in the order specified by the OVER clause".
Read more →
I'm proud to announce that I will participate to the SQL Pass 2006 Europe conference as a speaker!
Along with my collegue Alessandro I'll speak about advanced Reporting Services development. Here's the session abstract:
Read more →
If you're searching for Office Web Components rendering extension in the 2005 version of Reporting Services you may not find it. This is because is a deprecated feature.
If you need to re-enable it and/or you'd like to know what other features are deprecated you can read this document:
Read more →
This little snip of code allows you to list how many indexes are present on a table, their type and how big (kb and mb) they are:
select[name],type_desc,space_used_in_kb =(page_count *8.0),space_used_in_mb =(page_count *8.
Read more →
SQL Server 2005 Service Broker is a killer application...but you may get lost with all the configuration settings and objects you need to set up and manage so that you can use it effectively.
Read more →
For the 3rd consecutive year i'll be at the most important developers conference: WPC. I have four sessions and i'll talk about:
Indexes Reporting Services Integration Services Service Broker If you're interested you can find more detalis here (Italian language only).
Read more →
Yes it is true. And this bug has just been discovered by me and confirmed by the Query Optimizer Project Lead (Conor Cunningham) himself, that i have the chance to meet at SQL PASS 2005.
Read more →
While i'm was experimenting with Infopath and SQL Server 2005 ability to handle XML, i've found a not-expected behaviour (at least to me), that is better to explain a little bit so that no-one reading my blog will have the same problems.
Read more →
I've put online the second article of the three: you can find it here.
Read more →
wip
Read more →
<o:p></o:p>
After the introduction given in the article 1, we now have all the information we need in order to import data in a fast and non-locking way into our partitioned table.
Read more →
Ok, let's start with the basic; again, remember that I assume that you have read the SQL Server 2005 Partitioned Tables and Indexes whitepaper. Another document on partitioning (which explaing more deeply the differences between LEFT and RIGHT partitioning) is also this one.
Read more →
As you should have read in the fantastic Kimberly WhitePaper, partioning gives you an incredible opportunity to load data into your table minimizing locking and having the best performace you can imagine.
Read more →
A very interesting an powerful feature of Sql Server 2005 is called Partitioning. In a few word this means that you can horizontally partition the data in your table, thus deciding in which filegroup each rows must be placed.
Read more →
To know under which security context your job step will be run, go ahead and read the following:
The job step is a T-SQL stepIf the job owner is an account that is in the sysadmin fixed server role, than your step will be executed under the account used by the Sql Server Agent service.
Read more →
A lot of people mail me question about problem with sheduled DTS Packages. This article should explain *clearly* and *finally* which account is used to run job steps:
http://www.davidemauri.it/dasBlog/PermaLink.aspx?guid=bb70884a-32c8-4124-a0ab-4a33ba6d186d Update: As requested the article is also available here:
Read more →