Search

Mavin world

Elegant short notes on technical concepts

sys.objects vs INFORMATION_SCHEMA

I often got stuck in the jargon of technical words and how are they related. For those who are struggling like me to comprehend the technical buzz of words, this post illustrates the basic difference between the INFORMATION_SCHEMA, sys, sys.objects,... Continue Reading →

Advertisements

INFORMATION_SCHEMA the un-sung system views

Perfect one shot for the difference between INFORMATION_SCHEMA and the SYSTEM VIEWS

 

SQL Studies

I spend a reasonable amount of time looking through various forums, answering some questions and reading the answers to others. One of the things I’ve noticed is that while I frequently see system views referenced I only very rarely see the INFORMATION_SCHEMA views mentioned. This seems rather strange to me since I think most (although by no means all) of the people who work with system views know about the INFORMATION_SCHEMA ones.

For those who haven’t seen them before I’m going to show a few examples, comparing each INFORMATION_SCHEMA (owned by the INFORMATION_SCHEMA schema) view to the more common sys (owned by the sys schema) system view I see. Note: I’m only showing the base sys system view. In most (if not all) cases retrieving the same information will require joining several sys system views and/or functions together.

INFORMATION_SCHEMA.TABLES vs sys.tables
INFORMATION_SCHEMA_TABLES

INFORMATION_SCHEMA.COLUMNS vs sys.columns
INFORMATION_SCHEMA_COLUMNS

INFORMATION_SCHEMA.VIEWS vs sys.views
INFORMATION_SCHEMA_VIEWS

INFORMATION_SCHEMA.VIEW_TABLE_USAGE vs sys.dependencies

View original post 483 more words

Her smile…

It's her blissful, true, humble, loving, enthralling smile that radiates the innocence and affection she has for everyone she gives smile. Her smile make my day and my life. For her I'm the world and for me she's the life

Entity Framework Concepts made easy

Conceptual model, entity, context ....in Entity framework. Confused?? Say No to confusion now, since I have made this blog post to throw a perfect illusion of how all these things relate to each other. Let's begin... I begin with simple... Continue Reading →

Basic understanding of Merge Clause in Sql server

Merge Me using You  on You.obidient=Me.obidient When Matched  Then Party time When Not Matched By Me Then Sorry  When Not Matched By You Then Unfortunate  Viola Viola A quick and charming poem, Isn't it?  Merge clause may seem daunting at... Continue Reading →

Formatting SSRS in simple ways

Assalamualaykum Wr Br. Today we discuss few more things of SSRS formatting which pretty simple but I want it to be here for future references. Lets have a look on below report where report have three columns with name SID,... Continue Reading →

A First sight on cast and convert functions in sql server

I often get messed up myself when it comes to use cast and convert functions. No matter how many times I use them still I get stuck around at the basic syntax difference between the two. So lets make it... Continue Reading →

A simplified Glance ROW_NUMBER and OUTPUT clause in Sql Server

This post elucidates the concepts for the beginnners in an elegant way.The table chosen is simple for comprehending the concepts in a better way.

Value Type and Reference Type in C#

There are value types and reference types in c#. Value types hold the direct data i.e value  or object where as the reference types store the reference to a location in memory of the data or value or object. Value... Continue Reading →

Create a website or blog at WordPress.com

Up ↑