ACID properties in SQL Server
The ACID properties in SQL are a set of characteristics that ensure the reliability and consistency of transactions in a relational database. It is an… Read More »ACID properties in SQL Server
Home » SQL SERVER »
SQL Advance
SQL Server Advance Concepts includes Stored Procedures, Views, triggers, Complex SQL Queries, Index, Performance Tunning, Database Mail Configuration, SQL Server Agent Job Scheduling and so on..
Lost update problem in concurrent transations
A lost update problem occurs in concurrent transactions, when two transactions try to read and update the same column on the same row within a… Read More »Lost update problem in concurrent transations
SQL Return
SQL Return is a control-of-flow language keyword which is used to exit unconditionally from a query or stored procedure. It can be used at any… Read More »SQL Return
Export data from SQL Server to an Excel file
Sometimes you need to export data from SQL Server tables, views or the result of any T-SQL query into excel file, reason could be anything… Read More »Export data from SQL Server to an Excel file
Difference between clustered index and non clustered index
SQL Server indexes are used by queries to find data values quickly in tables and views. Basically it speed up the queries performance. You can… Read More »Difference between clustered index and non clustered index
SET STATISTICS IO
SQL STATISTICS IO is a set statement , when it is enabled it causes SQL Server to display information about the amount of disk activity… Read More »SET STATISTICS IO
How to insert the result of a stored procedure into table
Sometimes, you want to store the result of a stored procedure into table or temp table instead of returning the output. Storing output of stored… Read More »How to insert the result of a stored procedure into table
Object_Id Metadata Function
Object_ID is a SQL Server Metadata function which returns the database object identification number of a schema-scoped object. It can not be used for object… Read More »Object_Id Metadata Function
Dynamic Data Masking in SQL Server
Dynamic data masking also known as DDM is a security feature in SQL Server which helps you to prevent the access of unauthorize users to… Read More »Dynamic Data Masking in SQL Server
View Collation Information in SQL Server
Collations in SQL Server provide sorting rules, case, and accent sensitivity properties for your data. You can easily find SQL collation at the server, database… Read More »View Collation Information in SQL Server
PARSENAME Function
PARSENAME function is a SQL Server Metadata function which returns the specified part of an object name. The parts of an object that can be… Read More »PARSENAME Function
DROP IF EXISTS
SQL Server 2016 has released an optional IF EXISTS clause with DROP statement that can be used as DROP IF EXISTS. DROP IF EXITS verify… Read More »DROP IF EXISTS
Script table in SQL Server
You can script a table from database using a SQL Server Management Studio. SQL Server Management allows you to script out tables from database using… Read More »Script table in SQL Server
Generate Database Scripts With Data in SQL Server
You can generate a database scripts including the schema and the data by using the Generate Scripts option available in SQL Server Management Studio (SSMS),… Read More »Generate Database Scripts With Data in SQL Server
IDENT_CURRENT Function
The IDENT_CURRENT function returns the last IDENTITY value generated for any specific table or view on an identity column in any session and any scope.… Read More »IDENT_CURRENT Function
SQL Vulnerability Assessment
SQL Vulnerability Assessment (VA) is an easy to use tool that you can use to identify, track, and remediate potential database vulnerabilities. The VA service… Read More »SQL Vulnerability Assessment
SQL ROLLBACK Transactions
SQL ROLLBACK transaction statement rolls back an explicit or implicit transaction to the beginning of the transaction. If savepoint is specified then it rolls back… Read More »SQL ROLLBACK Transactions
Column Level Encryption Decryption using Symmetric Keys
SQL Server allows several options to protect sensitive data, and one of them is specifying a column level encryption. Using this option you can encrypt… Read More »Column Level Encryption Decryption using Symmetric Keys
How to Read SQL Server error logs using the xp_readerrorlog
Xp_readerrorlog is a SQL Server extend stored procedure allows you read the contents of the SQL Server error log files. It allows you to read… Read More »How to Read SQL Server error logs using the xp_readerrorlog
SQL JSON_VALUE Function
JSON_VALUE is a JSON function which is used to extracts scalar value from JSON string. It returns a single text value of type nvarchar. It… Read More »SQL JSON_VALUE Function