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.

SQLCMD (Server command line) – Run SQL query via cmd

• 13. 8. 2023
• Ing. Jan Zedníček - Data & Finance
• SQL Administration, Useful SQL Scripts

In this short article I will introduce the possibility to run a sql script outside of SQL management studio using SQL server command line utility (sqlcmd for short). This...

Číst »

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 »