SQL

Il corretto ordine per creare una Query SQL

A SQL trigger ensure actions, such as updating an audit file, are completed regardless of which program update a database table.

This document provides SQL queries to solve common interview questions involving complex queries on tables. Some examples include queries to retrieve alternate records, find the nth highest or lowest salaries, select the first or last n records, find records that exist in one table but not another, and aggregate functions like counts and sums grouped by columns. - Download as a DOCX, PDF or view online for free

Learn how to determine the SQL Server Permissions Granted to All Users By Default in the public role, in system databases and user defined databases.

I was recently asked if we are going to see performance differences if we explicitly drop temporary tables. I couldn’t remember the specifics, but I said it actually didn’t matter. However, that answer has bugged me, so I set up a quick test. Explicitly Drop Temporary Tables We could make this a crazy set of […]

The document provides a comprehensive list of SQL queries designed to retrieve various employee and department-related information from a database. These queries cover displaying employee details, calculating salaries, filtering by job titles, and aggregating data based on specific criteria. Additionally, it highlights functions for string manipulation, grouping, and advanced selection techniques to meet different data retrieval needs. - Download as a DOC, PDF or view online for free

ETL and SQL developers often import files with invalid data in those files. This has limited challenges with small file sizes, but as files grow to gigabytes worth of data, this task can be tedious. One of these forms of invalid data are lines with extra

Pivot SQL tables with CASE or FILTER. Turn rows into columns for the entity-attribute-value model (EAV).

Sql select statement

It is a best practice to pre-allocate databases and not to rely on autogrow to expand your database. Often times during a server migration, or setting up a new SQL instance, or during disaster recovery where downtime needs to be minimized you need to crea

Here is the SQL cheat sheet. You can use it as quick reference guide to prepare for the interviews.

The document provides a comprehensive list of SQL queries designed to retrieve various employee and department-related information from a database. These queries cover displaying employee details, calculating salaries, filtering by job titles, and aggregating data based on specific criteria. Additionally, it highlights functions for string manipulation, grouping, and advanced selection techniques to meet different data retrieval needs. - Download as a DOC, PDF or view online for free

In this tip, I show how to interpret the Lift Chart found on the Mining Accuracy tab of a SQL Server 2014 Analysis Services Data Mining structure.