• SQL Server interview questions :- What are Sub Query and Co-related Queries ?
    Articles,  Blog

    SQL Server interview questions :- What are Sub Query and Co-related Queries ?

    In this video will talk about what is a subquery what are co-related queries and what’s a difference between subquery and co related queries so first let start the subquery subquery also termed as nested queries subquery is nothing but it’s a query inside a query many times you know you would like to you have series of SQL chained you know where output of one query is sent as the input to the other query for filtering and manipulation for example you can see in the figure you know we have two tables one table has the employee salary and the second table has phone numbers now let say…

  • SQL Server training :- When do we apply de-normalization ?(Interview question)
    Articles,  Blog

    SQL Server training :- When do we apply de-normalization ?(Interview question)

    In the previous part of the video we saw the benefits of normalization we also saw how normalization help’s you to avoid redundant data and error data enter into your systems now i am sure that somewhere in your mind the three normal forms have must becomes golden rules for database designing but that hang one there is other side of the story as well we need to understand before we go and apply this normalization as golden rules for database designing in order to understand the other part of the story let us first understand the larger classification of IT systems from the data perspective from the data perspective…

  • Articles

    Improve SQL Server performance using profiler and tuning advisor

    Lets start with point number 7 How can we improve SQL Server performance by using Database engine tuning advisor SQL Server performance largely depends on how you have created the index i.e your cluster index and non cluster index etc Most of the times developers do not even think about indexes By default SQL Server creates a cluster index on the primary key and that’s a only index you will find in most database by default non cluster index if you have not given thought of index or indexes I’ll say non cluster indexes far away When these default settings are taken to production It doesn’t workout for a long…

  • SQL Server interview question  :- What is use of Coalesce and ISNULL ( SQL Server training)?
    Articles,  Blog

    SQL Server interview question :- What is use of Coalesce and ISNULL ( SQL Server training)?

    In this video will try to understand what exactly is the use of ISNULL function and what is the use of Coalesce function Let me pronounce again coalesce I am not sure that if that pronounciation is right but english is my second language In case it is not right I am extremely sorry for that In this video we will try to demonstrate ISNULL and Coalesce function First start with ISNULL In order to demonstrate the ISNULL function I have created a very simple table here The table name is tblPerson and it has two columns first name and surname and if you go and fire select query over…

  • What is CTE ( Common table expression) in SQL Server ( Doubt solving sessions)?
    Articles,  Blog

    What is CTE ( Common table expression) in SQL Server ( Doubt solving sessions)?

    Hello welcome to doubt sessions of questpond so we have in this session you know will clarify the doubt about CTE or common table expression so here’s a email we have got from one of our users I want to clarify common table expression in SQL I have ask many times but did not respond to me please clarify okay so what I will do is let me just quickly go to first to MSDN and let’s just talk about definition and then with then will do some demonstration okay you can see that a common table expression nothing but it’s a temporary result set it’s a temporary table okay…

  • Articles

    SQL Server :- Can you explain First,Second and Third normal form in SQL server ?

    In this video will talk about three important database techniques First normal form Second normal form and Third normal form We have created a simple database called as University Inside the University we have created a very simple table called as tblSchool In this table we have some 7 fields The first field says this student is belong to which Standard The second column says what is the roll number of student The third column says what is the first name, last name and the surname of the student what kind of syllabus the student has taken How much marks has acquired till now The total number of subjects which…

  • Articles

    SQL Server interview training :-What are triggers , inserted and deleted tables ?

    In this video will talk about what exactly are triggers, and in what scenario we should be using them While we do that will talk about two important types of tables one is called as inserted table and the other one is called as deleted table Will talk about two different kinds of triggers i.e called as the Instead of trigger and the After trigger Triggers are logic like stored procedures which can be executed before the updation happens on a table or after the updation happens on a table If you want to execute pre processing or post processing logic after the updation or before the updation you can…

  • Articles

    Can you explain the concept of SQL Server 8 KB page ?(SQL Server interview questions)

    In this video we will try to understand how SQL Server stores and manages data internally. In order to understand how sql server stores data internally I have created a very simple database here called as test 123 and it has a very simple table here called as tblcustomer which has just one column called as customer name which is having a char datatype which is of length 1000 Whenever we insert update or delete data into the tblcustomer table or into any table of SQL Server At the end of the day all of these data is stored into the MDF file which is our physical file for our…