Here you can find articles containing some useful technique or script. For example, automatic optimalization of indexes in the database (rebuild or reorganize), database email settings, various checking scripts, etc.

• This page this page has no other subpages
• View all posts from the category: List of Articles in Useful SQL scripts category »

Most read from category

Sorry. No data so far.

Basic SQL Queries – Overview For Beginners With Examples

• 3. 2. 2020
• Ing. Jan Zedníček - Data & Finance
• SQL Basics, SQL Clauses, Useful SQL Scripts

What I have here today is a article for beginners. It will be full of sql query examples. We will start from the most basic ones and continue up....

Číst »

SQL OFFSET Functions – LAG, LEAD, FIRST_VALUE, LAST_VALUE

• 13. 11. 2019
• Ing. Jan Zedníček - Data & Finance
• SQL Functions, Useful SQL Scripts

OFFSET functions are relatively new to MS SQL Server. They are available since SQL Server 2012 version. These functions enable a user to “list” through rows of a table....

Číst »