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 →
Inner join can lead to misleading result set which sometimes can cause mess if they are not handled meticulously.
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 →
Perfect one shot for the difference between INFORMATION_SCHEMA and the SYSTEM VIEWS
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.VIEW_TABLE_USAGE vs sys.dependencies
View original post 483 more words
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 →
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 →