Published On: 6/30/2022
Monitoring and Performance Tuning Tips for SQL Server database
Performance tuning in SQL Server is essential topic and Microsoft defined set of process in back end to bring the data from database. This is interest chapter for developers and those should follow the Microsoft evolved rules to access the data from the database.
There are so many ways to achieve the performance tuning in SQL server and below topic…
Read More »
Extract the data from XML using OPENXML and XQuery in SQL Server
This post describes to read the data content from different XML elements and attributes by using OPENXML and XQuery methods. The XML file format is one of the best way to handle the large volume of data as single file.
T-SQL exclusively provides OPENXML and XQuery methods to extract or read the data content from XML file or XML text format.Below XM…
Read More »
Published On: 6/28/2022
Fill Factor in SQL Server: Optimizing Index Performance
When it comes to optimizing performance in SQL Server, one
factor to consider is the fill factor. The fill factor determines the percentage of space on each leaf-level page that is filled with data, leaving room for future growth. By setting an appropriate fill factor, you can reduce fragmentation and improve index performance.
What is Fill Fac…
Read More »
Published On: 11/23/2018
Experience SQL Server/Developer Interview Questions and Answers
Collection of recent, popular scenario based SQL Server/SQL developer Interview questions and answers for freshers, beginners and experienced candidate/professional.
SQL Server/Developer Interview Questions and AnswersWhat is the difference between ROW_NUMBER, RANK, DENSE_RANK and NTILE?
ROW_NUMBER, RANK, DENSE_RANK, NTILE are functions in SQL serve…
Read More »
Published On: 1/27/2018
Difference between ROW_NUMBER, RANK, DENSE_RANK, NTILE in SQL Server
ROW_NUMBER, RANK, DENSE_RANK, NTILE are functions in SQL server and returns numeric output by different sequence order. These functions are having some similarities and significant difference.
Similarity:
Should have OVER clause and ORDER BY clause inside the OVER clause.Can have PARTITION BY clause inside the OVER clause.
ROW_NUMBER: Returns the seq…
Read More »
Published On: 12/13/2017
Generate the data dictionary of SQL database Schema using SQL Query
What is Data Dictionary in SQL Server?Data dictionary in SQL server is collection of explanation about tables, columns/fields, data type, length, constraints, relationship between tables and data model to understand the participated objects in the database.
Data dictionary is an important one to developers/DBA to understand the database objects, a…
Read More »
Published On: 12/08/2017
Recover deleted SQL table data from LDF file using Query in SQL Server
We can recover the deleted SQL server table rows or data from transaction log file using stored procedure in SQL Server. This problem is happening in development environment while developing application, writing SQL stored procedure or scripts and sometime we faced this problem in production environment.
How to recover deleted SQL data using Stored…