Posts

Extraction part 1 - SP

Post a Comment

FOREIGN KEY - THINGS TO KNOW (MS SQL SERVER)

Post a Comment
Image

Primary key - things to know (MS sql server )

Post a Comment

Column adding -ms sql server

Post a Comment

Index- unique and non unique

Post a Comment

Index - Advantage and Disadvantage.

Post a Comment
Image

Index - Non-Clustered Index - similar to index of a text book's table of content which is always in separate page, similarly non clustered index creates sperate table to store the indexing

Post a Comment
Image

Index -Clustered Index- for faster Findings - similar to book index but not in separate page but for faster finding arranging the data into organized way from unorganized(mess).

Post a Comment

FOR XML CLAUSE IN SQL SERVER

Post a Comment

Limitations of views.- cant parameters, rules and default, Order by unless Top or For XML, cant temp table

Post a Comment

Views -- Indexed views-- not suitable for OLTP --suitable for OLAP

Post a Comment

Views --updatable view -- dont update view directly if the view is composed of multiple tables-- use instead of trigger for updating such table

Post a Comment

Disable trigger querry

Post a Comment
Image

LogOn Triggers. - limiting sessions anything you want regarding logon .. with this you can limit sessions

Post a Comment
Image

DDL TRIGGERS - stopping procedure table to be modified or created

Post a Comment

triggers-DML- instead of triggers

Post a Comment

Exit Control Loop -Do while

Post a Comment

Entry Control Loops

Post a Comment