1. JOIN or INNER JOIN:- In this kind of a JOIN, we get all records that match the condition in both the joining tables, and ...
Read More
ADVANTAGES OF TERADATA
TERADATA’S COMPETITIVE ADVANTAGES • Unlimited, Linear Scalability. • Unconditional Parallelism. • Mature optimizer. • ...
Read More
INTRODUCTION TO TERADATA & HISTORY
What is TERADATA ? • The Teradata Database is a Relational Database Management System (RDBMS). • It is deigned to run the worl...
Read More
Find History of queries executed on a SQL Server
If you have ever wondered what SQL query was last executed by your users across all SQL Server databases on your server? Then don...
Read More
SQL Logical Query Processing Order
Generally, most programming languages process statement from top to bottom. But SQL Server is different in order of execution, SQL...
Read More
Find Free Space by Database
Using this query you can find out the free space available for each database. --create a Table variable to store database informatio...
Read More
Create Data Dictionary in SQL Database
This query will create a Data dictionary of a database which can be very helpful while doing the documentation of a project. select...
Read More
Subscribe to:
Posts
(
Atom
)