BI Experts
Menu
  • Home
  • SQL
  • MSBI
    • SSIS
    • SSRS
    • SSAS
  • Data Warehouse
  • Teradata
  • Tableau
  • Other
Archive for 2017

Different Type of SQL JOINs

Vinod Kumar 12:58:00 AM Add Comment
Vinod Kumar
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

Vinod Kumar 12:17:00 AM Add Comment
Vinod Kumar
TERADATA’S COMPETITIVE ADVANTAGES • Unlimited, Linear Scalability. • Unconditional Parallelism. • Mature optimizer. • ...
Read More

INTRODUCTION TO TERADATA & HISTORY

Vinod Kumar 12:04:00 AM Add Comment
Vinod Kumar
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

Vinod Kumar 1:34:00 AM Add Comment
Vinod Kumar
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
Subscribe to: Comments ( Atom )

Archives

  • ▼  2017 ( 4 )
    • ▼  February ( 4 )
      • Different Type of SQL JOINs
      • ADVANTAGES OF TERADATA
      • INTRODUCTION TO TERADATA & HISTORY
      • Find History of queries executed on a SQL Server
  • ►  2016 ( 5 )
    • ►  August ( 1 )
    • ►  June ( 4 )

Find it!

Followers

Recent

Popular

  • SQL Logical Query Processing Order
    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...
  • Different ways to create a foreign key in an existing table
    Different ways to create a foreign key in an existing table
    Here are the 3 different ways to add a Foreign Key in an existing table:- By using ADD CONSTRAINT with update and delete cascade co...
  • Find a Keyword in all Stored Procedures or whole Database
    Find a Keyword in all Stored Procedures or whole Database
    Find all Stored Procedures that reference a Column, Table Name or any keywo rd. Using this Query You can search for a column/table nam...
  • Different Type of SQL JOINs
    Different Type of SQL JOINs
    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 ...
  • Create Data Dictionary in SQL Database
    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...
  • INTRODUCTION TO TERADATA & HISTORY
    INTRODUCTION TO TERADATA & HISTORY
    What is TERADATA ? • The Teradata Database is a Relational Database Management System (RDBMS). • It is deigned to run the worl...
  • Find Free Space by Database
    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...
  • Find History of queries executed on a SQL Server
    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...
  • ADVANTAGES OF TERADATA
    ADVANTAGES OF TERADATA
    TERADATA’S COMPETITIVE ADVANTAGES • Unlimited, Linear Scalability. • Unconditional Parallelism. • Mature optimizer. • ...

Comment

statistics

Sparkline

Subscribe

Formulir Kontak

Name

Email *

Message *

Powered by Blogger.

Categories

  • SQL
  • Teradata

About Me

My Photo
Vinod Kumar
Vast experience working in various BI Technologies like MS SQL, MSBI, SSRS, SSIS, SSAS, Tableau, Teradata etc.
View my complete profile

Label

  • SQL
  • Teradata
Copyright © 2015 BI Experts All Right Reserved
Blogger Templates Created by Arlina Design Powered by Blogger