SQL Query Resources

Share

Related resources for SQL Query

Data Professionals to LLM/GPT Prompting for Everyday Tasks11/17/2024 10:52:39 AM. A guide for data professionals on leveraging Microsoft OpenAI with Python for efficient workflows and enhanced data analysis. Focuses on prompt design, including clear instructions, context, and tempe
How To Delete Duplicate Rows From A Table In SQL Server10/12/2024 5:29:23 AM. This guide explains how to delete duplicate rows from a table in SQL Server. Using common techniques like ROW_NUMBER() with PARTITION BY, you can identify and remove duplicate rows while keeping the o
How To Send Mail Using SQL Server: Part 210/8/2024 8:32:47 AM. This tutorial demonstrates how to send emails using SQL Server 2008. It covers configuring an email profile, selecting data from a student table (tblStudents), and binding that data to an HTML-formatt
How To Execute SQL In SharePoint 2013 And Office 365 Using Nintex WorkFlows9/27/2024 10:13:52 AM. This article guides you through executing SQL in SharePoint 2013 and Office 365 using Nintex Workflows. It covers creating a Dev Testing list, adding the "Execute SQL" action, and configurin
How To Get Unique Records Without Using Distinct In SQL Server9/26/2024 4:35:41 AM. In this guide, you'll learn how to retrieve unique records in SQL Server without using the DISTINCT keyword. We'll explore alternative methods like GROUP BY, ROW_NUMBER(), and Common Table Exp
Check Disk Space Utilization by Tables in SQL Server Database9/23/2024 8:53:17 AM. In this guide, learn how to effectively check disk space utilization by tables in a SQL Server database. We’ll cover essential SQL queries and techniques to analyze table sizes, identify storage usage
Data Virtualization from Azure Blob Storage in Azure SQL Database9/16/2024 5:17:34 AM. This solution enables Azure SQL Database to directly access and read files from Azure Blob Storage using External REST Endpoints, bypassing the need for physical data loading. It leverages database-sc
SQL Subqueries: Correlated, Scalar, and EXISTS/NOT EXISTS9/4/2024 9:30:54 AM. Subqueries in SQL are powerful tools for complex queries. They include correlated subqueries, which depend on the outer query’s results, scalar subqueries that return single values, and EXISTS/NOT EXI
Understanding ROW_NUMBER() in SQL Window Functions8/2/2024 4:46:39 AM. ROW_NUMBER() is a window function in SQL that assigns a unique number to each row within a partition of a result set. It’s useful for ranking, removing duplicates, pagination, and selecting the top N
@@ROWCOUNT in SQL Server7/29/2024 9:28:40 AM. @@ROWCOUNT is a SQL Server function used to retrieve the number of rows affected by the last executed statement. It provides valuable insights for data manipulation and validation processes, helping t
Understanding the SQL Query Execution Order7/22/2024 4:41:19 AM. SQL (Structured Query Language) is essential for interacting with relational databases, and mastering its intricacies can significantly enhance your data querying skills. One of the fundamental aspect
Store Locations and Retrieve Dropdown Data with Stored Procedure7/3/2024 6:06:48 AM. Explore efficient location data management with this guide on storing locations in a database table. Learn to utilize stored procedures for streamlined retrieval of dropdown data, ensuring optimized d
Query to find Table Name, Row Count, Column Count and Data Size7/2/2024 6:59:25 AM. This guide covers techniques to query and display table names, row counts, column counts, and data sizes efficiently. Ideal for database administrators and developers seeking to optimize data manageme
Comparison Of Different SQL Query Responses Of SQL Server On Windows And Ubuntu Linux6/14/2024 10:41:29 AM. The article consists of some benchmark tests of SQL Server on different Operating Systems, the parameters considered are CPU Time, Elapsed Time and Total Execution Time.
Understanding RANK vs DENSE_RANK in SQL6/14/2024 10:20:54 AM. Explore the nuances between RANK and DENSE_RANK in SQL with this comprehensive guide. Learn how these window functions order query results differently, impacting ranking assignment and handling of tie
Delete Duplicate Rows In SQL Server From A Table4/25/2024 8:49:52 AM. In SQL Server, delete duplicate rows from a table efficiently using techniques like DISTINCT, GROUP BY, or ROW_NUMBER(). Ensure data integrity by considering primary keys or unique constraints.
Difference Between Union & Union All In SQL Server 20174/3/2024 9:56:30 AM. In this article, you will learn the nuances between UNION and UNION ALL in SQL Server 2017. While both combine results from multiple queries, UNION removes duplicates, whereas UNION ALL retains them.
Understanding FORMATMESSAGE() Function in SQL Server3/6/2024 4:58:24 AM. In this article, we will discuss how to use FORMATMESSAGE() function in SQL Server, its advantages and usages with example.
SQL CTE to Rank Sales by Products using Fabric Data Warehouse3/5/2024 5:03:37 AM. This video shows how to author Common Table Expressions in Fabric Data Warehouse to Rank Sales by Products.
Analyzing Sales Data with a Comprehensive SQL Query in Microsoft Fabric Data Warehouse11/18/2023 4:28:22 AM. This SQL query is a powerful tool for in-depth sales analysis, utilizing joins and aggregations to break down sales data by account manager, payment type, and region in Microsoft Fabric Data Warehouse
Stored Procedure in SQL Server9/12/2023 7:29:06 AM. A stored procedure is a reusable collection of SQL statements stored on the database server. It simplifies code maintenance and execution. Stored procedures can be invoked by triggers, other procedure
How to Select Employees Who Were Born on the Last Day of the Month?8/10/2023 7:24:21 AM. To select employees who were born on the last day of the month from a database or employee records, you'll need to use SQL or a similar query language to filter the data based on the birth dates.
50 SQL Server Interview Questions Guaranteed to Help You In 2023 7/25/2023 7:16:19 AM. A complete guide of top SQL Server interview questions and answers that will help pass your SQL Server interview.
Query Optimization Techniques in SQL Server4/25/2023 11:20:30 AM. Query Optimization Techniques in SQL Server
Optimization Of Queries In SQL Server - HEAP TABLES3/8/2023 2:02:52 PM. This article will help you to understand how to start to think on optimization of sql queries and why use indexes in tables
Conversion Functions Using SQL Query in SQL Server3/6/2023 5:52:11 AM. In this article you will see how to use conversion functions using SQL Query in SQL Server.
SQL Performance (1), Optimized SELECT Query (A)2/28/2023 6:17:26 AM. This article discusses SQL performance on optimizing SELECT Query.
Merge Statement In SQL2/24/2023 8:52:32 AM. Merge Statement is a very popular clause in SQL. It handles Insert, Update and Delete in a single query no need to write different logics for each.
Some Important Tips For SQL Query Performance2/23/2023 4:57:16 AM. This article provides some important tips for SQL Query Performance.
Important Queries in SQL2/16/2023 8:48:04 AM. In this article we learn some interesting and useful SQL queries.
Optimizing Queries For Faster Performance In SQL Server - A Step-By-Step Guide With Examples2/14/2023 10:36:17 AM. In this article, you will learn about Query Optimization in SQL Server.
DATABASEPROPERTYEX Function in SQL Server2/13/2023 5:11:03 AM. In this article, I would like to show how to extract the metadata about a database in SQL Server.
Dynamic Query to Search by Column Value in All Referencing Tables in SQL SERVER2/2/2023 9:04:08 AM. In this article I'll show you how to search a column value in all the referencing tables.
Dynamic SQL Query Injection And Its Prevention Mechanism1/25/2023 6:27:00 AM. In this article, you will learn about dynamic SQL query injection and its prevention mechanism.
Tips to Increase SQL Server Query Performance: Part 21/25/2023 6:02:25 AM. This article provides more tips to increase SQL Server query performance.
Working with Date and Time in SQL Server1/20/2023 10:49:06 AM. In this article, I would like to show the similarity of SQL Getdate function and the C# DateTime class.
How To Optimize SQL Queries1/11/2023 11:30:29 AM. In this article, you will learn how to optimize SQL Query.
Delete Files with a SQL Job in SQL Server1/10/2023 10:55:29 AM. Here I am going to discuss deleting files using SQL Job.
T-SQL Query Performance Tuning Tips1/10/2023 8:52:11 AM. In this article, I will discuss some useful T-SQL query performance tips and tricks for SQL server developers.
Effective Paging, Sorting And Filtering Using SQL Server Stored Procedure1/6/2023 7:11:09 AM. In this article, I will cover and discuss the Effective Paging, Sorting and Filtering with Stored Procedure in MS SQL Server.
Searching, Sorting and Paging Using SQL Query1/6/2023 6:47:22 AM. This article shows how to use a SQL query to perform searching, sorting and paging by one query.
Iterate Through Array Of Data In SQL Query1/3/2023 4:06:37 PM. In this article we will see how to create a Array variable in SQL and how to iterate through it to process records in database.
Using Temp Table in SQL Server And Adding Columns Dynamically12/29/2022 8:34:12 AM. In this article we'll see how to use the Temporary tables, what are the necessary step to be taken while using them and moreover sometimes it's required to add column in Temporary tables dynam
Finding Duplicates Among Multiple Columns in SQL12/28/2022 8:21:54 AM. Here I show how to find duplicates and their frequency among multiple columns using the GROUP BY clause.
Get Months Within a Date Range With SQL Query12/28/2022 7:26:01 AM. This article shows how to get the months within a date range with SQL Query.
Find Nth Highest Salary in SQL Server12/26/2022 2:29:54 PM. In this article I am explaining various ways to get the Nth highest salary from an EMPLOYEE table.
The Most Important SQL Queries For Beginners12/17/2022 6:20:46 PM. How do you get the data from the table? How do you create or drop the table? How do you display the different records? Do you want to? You can easily do all of this by writing a simple SQL query.
Logical Query Processing In T-SQL7/19/2022 8:03:35 PM. This article demonstrates the practical values of knowing Logical query execution in TSQL.
Read Text File And Move Files To Another Folder Using SQL Server Query Instead Of ETL12/9/2021 7:46:26 AM. In this article, you will learn how to read text file and move files to another folder using sql server query instead of etl.
How To Import Data Directly From The SQL Query In Power BI1/6/2021 5:08:22 PM. In this article, you will learn how to Import Data Directly from the SQL Query in Power BI
Execute Long Running SQL Query Or Stored Procedure From .NET11/3/2020 12:47:34 AM. This article describes the asynchronous call to MS SQL statements from .NET environment using C# to avoid UI or main thread freezing.
Azure Cosmos DB With SQL Query Cheat Sheet PDF7/16/2020 3:01:50 AM. Microsoft Azure Cosmos DB supports querying documents using SQL (Structured Query Language) as a JSON query language. Cosmos DB is truly schema-free. By its commitment to the JSON data model directly
SQL Query Execution Plan Operations4/29/2020 8:27:56 AM. In this article you will learn about SQL query execution plan operations.
SQL Query Execution Plan4/27/2020 11:42:34 PM. In this article, you will learn about SQL query execution plan.
SQL For Beginners8/9/2019 11:42:01 AM. In this video series, we will learn dive deep into the concept of Structured Query Language (SQL) from the very basics. This article is ideal for beginners who want to learn SQL from scratch.
SQL Assessment API (Public Preview)8/6/2019 10:55:07 AM. Is your SQL Server configuration in line with Microsoft recommended best practices? If you want to know, check this latest video on SQL Assessment API.
On vs Where Clause in SQL Server 20127/18/2019 6:29:30 AM. Here, I will explain the difference between the On and Where clauses when used with a left join in SQL Server.
Calculating Factorial of a Number in SQL Server 20127/15/2019 4:16:13 AM. Here, I have constructed a query that provides a solution in SQL Server to determine the factorial of a specified number.
Count All vs Count Distinct in SQL Server7/8/2019 9:53:12 AM. In this article, you will see the SQL aggregate function count in two forms, Count All and Count Distinct.
Top 30 Important SQL Queries For Developers4/1/2019 9:21:52 AM. In this SQL article, I will introduce you to some important SQL queries and technical points. This article is a guide for you to learn the concepts related to SQL. It starts with the basic SQL queries
MySQL Fetch Array Function in PHP8/13/2018 1:46:27 AM. In this article I explain the MySQL_Fetch_Array() function in PHP.
Construct Readable XML Output From SQL Query From Two Or More Tables Using “For XML PATH” Statement9/4/2017 12:25:58 AM. In my previous article I discussed about how to get a XML format output from query and process that by using XML AUTO statement, and I give different types of “for XML”.
Transform XML Output Of SQL Query To HTML Using "For XML" AUTO Statement With XSLT In C#8/21/2017 4:37:24 PM. Normally, we execute the query using ExecuteNonQuery statement and fill the output into data table. This article describes how to transform the XML output of SQL query statements using FOR XML AUTO to
Find The 3rd Or Nth Highest Salary In A Table Via SubQuery8/1/2017 2:03:54 AM. This article describes how to find the 3rd or Nth highest salary in a table. To find the Nth highest salary, we need to create a table in the database containing some data and to do this use the follo
SQL Query Plans Each Developer Should Know5/26/2016 12:59:28 PM. In this article you will learn about SQL Query Plans for each Developer.
Various Approaches to Find Nth Salary in SQL Server 2008R28/28/2015 3:23:25 PM. This article describes various approaches to find the nth salary in SQL Server 2008R2.
Difference Between ROW_NUMBER () OVER () & PARTITION BY Clause7/29/2015 4:50:14 PM. In this article you will learn the difference between ROW_NUMBER(), OVER() and PARTITION BY clauses in SQL Server.
SQL Server Database Basics Query Command 5/3/2015 1:46:08 PM. This article provides some SQL Server database basic information including database creation, data table creation and basic query information.
SQL Query Performance - Functions and Indexes4/3/2015 11:29:51 AM. In this article we will learn why functions should be avoided on indexed columns in where clauses of select statements.
Query Notification in SQL Server6/11/2014 2:41:46 PM. This article explains QueryNotification and SQLCacheDependency in SQL Server.
Import Data From Database Using Native SQL Query in Microsoft Excel 20133/15/2014 2:48:46 PM. This article shows the powerful features of Excel 2013 to import data from a database.
LINQ To SQL2/24/2014 5:45:33 PM. Today in this article I will teach you the most interesting and new features of the C# programming language, LINQ-To-SQL.
Inventory Management Using SQL Trigger12/30/2013 9:58:41 PM. In this Article I explain how to create a simple Inventory Management transaction Using Insert, Update and Delete Trigger.
Query Notification in SQL Server12/12/2013 3:35:57 PM. Thisarticle dscribes Query Notification in SQL Server.
Publishing MySQL Data With PDO Extension In PHP11/16/2013 8:24:05 PM. This article is explain publishing MySQL data with PDO extension in php.
SQL Query to Get Details of Index Fragmentation in SharePoint7/26/2013 2:07:37 AM. This article explains how to get the details of index fragmentation in SharePoint and provides a script that can be used to rebuild and reorganize indexes.
SharePoint SQL Query to Get Details on Disk Utilization and IO7/24/2013 2:34:55 PM. In this article I will demonstrate SharePoint SQL Query to get details of Disk Utilization and IO.
Getting the Name of the Server and Databases in SQL Server3/19/2013 1:27:58 PM. In this article, I would like to show how to get the name of the server and databases in SQL Server.
Getting Some Useful Date and Time Information From Getdate Function in SQL Server 20123/6/2013 4:10:55 PM. In this article, I would like to show the utility of Getdate functions in SQL Server.
Insert and Update Stored Proc With Raw SQL Query Via EDF Framework12/31/2012 4:49:04 PM. Today, in this article let's play around with one of the interesting and most useful concepts in EDM Framework.
Delete and Update Data With Raw SQL Query Via EDF Framework12/31/2012 4:33:20 PM. Today, in this article let's play around with one of the interesting and most useful concepts in EDM Framework.
Insert Data With Raw SQL Query Via EDF Framework12/31/2012 12:27:14 AM. Today, in this article let’s play around with one of the interesting and most useful concepts in EDM Framework.
Delete Stored Proc With Raw SQL Query Via EDF Framework12/29/2012 12:40:30 PM. Today, in this article let’s play around with one of the interesting and most useful concepts in EDM Framework.
Using LINQ to SQL Query9/30/2012 3:08:05 AM. Here in this article, you will get very basic idea of LINQ to SQL Query using code.
Modifying a Database Checkpoint in QTP in Testing8/21/2012 4:12:26 PM. In this article we discuss how to modify a Database Checkpoint in QTP.
SQL Query Optimization FAQ Part 1 (With video explanation)5/20/2012 4:20:41 AM. In this article we will first try to understand what is a SQL plan, how is it created and then we will move towards understanding how to read the SQL plan. As we read the SQL plan we will try to understand different operators like table scan, index seek scan, clustered scan, RID lookup etc. We will also look in to the best practices associated with clustered and non-clustered indexes and how they function internally. We will practically see how indexed views increase performance and in what scenarios we should use the same.
Database Objects Information Using SQL Query in SQL Server4/22/2012 12:34:18 PM. In this article we will see how to get the Database objects Information using a query.
SQL Server Database Explorer12/16/2005 5:18:36 AM. This application connects to a running SQL Server 2000 and displays all the available databases in it.

Topics