SQL

Il corretto ordine per creare una Query SQL

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

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

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

Sql select statement

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

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.

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.

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

Starting with SQL Server 2008, the local Administrators group is no longer added by default during SQL Server setup; you even have to use a manual step to add the current user as a local administrator. This means that it is possible, especially if you don

Ever get tired of assigning server level permissions by adding a login to a predefined server fixed role and then assigning multiple permissions to that login? In SQL Server 2012 you now have the ability to create a User Defined Server Level Role.

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

Combine multiple rows into one string in SQL Server. Simple query in SQL Server to concatenate multiple rows Into single string.