Oracle – Dynamic Queries and Reporting

There are various tools to provide enterprise-level reports. But what to do if you need yo create reports for yourself? In this article I’m going to describe how to manage simple reports using Oracle 10g.

Read the rest of this entry »

Microsoft SQL Server – Complex Cleanup

Today my team manager asked me to create small interesting sql script.┬áThis script recieves time interval on input, splits given time interval into smaller parts (let’s say 24 hours per interval), counts total number of records for each interval, outputs this information and deletes records. Script mustn’t delete top”fresh” records though. E.g. manager would like to specify offset parameter, so records from interval [today-offset;today] mustn’t be deleted. Read the rest of this entry »

Microsoft SQL Server – statistics

I’ve recieved interesting task from my boss. I need to prepare a few stats for MS SQL Server so let’s do it.

Read the rest of this entry »