Search

Mavin world

Elegant short notes on technical concepts

Category

SQL SERVER

DatePart Demystified

DatePart when used to retrieve WeekDay, its settings depends on the Set DateFirst . The current value of the DateFirst Can be queried as select @@DateFirst which will return the value between 1 to 7 each representing a day of... Continue Reading →

Advertisements

Data Providers! What’s it?

Data provider is the most common term as a developer, we often hear it. But to be exact, what does it mean? Let's simplify things up with SBerry Data Provider is a software library consisting of numerous classes which provide... Continue Reading →

INDEX in SQL SERVER simplified

Let's learn Index with Sberry and unravel the different types of indexes in sql server. An index is an on-disk structure associated with a table or view that speeds retrieval of rows from the table or view. Index contains keys... Continue Reading →

Hints in SQL SERVER

Hint, Hint Hint SBerry out to execute it's task. Let's explore SQL SERVER hints with SBerry Basic and Simply put: A hint is a sort of suggestion or order given out to the SQL Server query processor to follow the... Continue Reading →

A Hard Digest with Inner join in Sql Server

Inner join can lead to misleading result set which sometimes can cause mess if they are not handled meticulously.

Quick Note on Apply Operator in Sql Server

  Hello Welcome to Sberry blog. This post gives you a quick snap of what APPLY operator in sql server. Learn now with Sberry. APPLY operator in a Transact-SQL query is used to join a table to a table-valued function... Continue Reading →

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 →

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

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 →

Create a website or blog at WordPress.com

Up ↑