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..
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
4,168 total views
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
1,074 total views
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
2,318 total views
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
2,864 total views
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
1,759 total views
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
32,164 total views, 3 views today
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
2,737 total views, 1 views today
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
6,255 total views, 1 views today
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
6,103 total views, 3 views today
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
4,592 total views, 1 views today
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
5,513 total views
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
1,841 total views
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
8,728 total views
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
2,918 total views, 1 views today
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
1,649 total views, 1 views today
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
4,657 total views
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
5,550 total views, 1 views today
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
7,878 total views, 1 views today
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
6,281 total views, 2 views today
SQL JSON_QUERY is a JSON function which extracts an object or an array from a JSON string. JSON_QUERY function introduced in SQL Server 2016. You… Read More »SQL JSON_QUERY Function
7,482 total views, 1 views today