Keys are generally properties applied to a column of a database table that signify it's worth in that table. Following keys will help you understand the similarities and differences in the various column key options presented by MS SQL Server. In simple words, key in database is something that can
Read moreIndexing in SQL is a simple topic when it comes to discussion with an SQL Expert, but over the past 10 years as a developer, I have seen people with good knowledge and experience fail to portray the primary meaning of indexes and their types. Indexes help in retrieving data faster
Read moreWhile working with dynamic queries or otherwise when we are not sure of the number of columns that will be returned from the query or simply due to laziness for typing the entire column name we can use the index of the column by whom we want our result set
Read moreIntroduced in SQL Server 2008, The SPARSE column is better at managing database size when null values are a plenty in that particular column.To declare a particular column as sparse we have to simply specify the keyword 'sparse' after declaring the column name and the data type. Please refer to the below
Read moreSQL - 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 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 more