SQL - Structured Query Language is further categorized on the basis of various commands and functionality types done by a particular set of keywords and the overall impact on a particular set of database objects. They are as follows:DDL - Data Definition LanguageDML - Data Manipulation LanguageDCL - Data Control
Read moreA trigger is an event based stored procedure that automatically executes when an event occurs in the database server. DML triggers execute when a user tries to modify data through a data manipulation language (DML) event. DML events are INSERT, UPDATE, or DELETE statements on a table or view. DDL trigger is executed
Read moreJSON is a data-interchange format that is both Human and Machine readable. It is easy for developers to interpret and pinpoint the issues, if any, during debugging when working with JSON. If the data is sent from our database to the application in JSON format. It will definitely make developers life
Read moreEver wondered why it takes so much time to get the count of rows in an SQL table with millions of records? In case when the table is large and fragmented the 'select count(*) from large_table_name' may take seconds to minutes to return an output. Re-indexing can also take up considerable
Read moreAs an T-SQL Developer, we always tend to wonder why my query takes considerately more time when everything is set on the server including indexes, fragmentation, fill_factor, etc,... Well, these things are important for the performance of your query but another important thing that we usually miss is the structuring of
Read moreNow this is tricky and pretty impulsive when you try to send emails from database using SendGrid and the mail fails to get send and the log reads out a generic message as 'The mail could not be sent to the recipients because of the mail server failure. (Sending Mail
Read moreCommon issue generally every developer faces in his initial days of development is how to generate connection string that connects my application to the database. Especially when we don't have sql management studio installed or if we are facing licensing issues.Well, a text file can come to a rescue. To overcome such
Read moreAs a layman or a novice, when we come across the concept of local temporary tables, global temporary tables, table variables or common table expressions; we tend to think that they function similarly i.e. they all store data in them in a tabular format. So whats the difference in them
Read more