Monday , December 11 2017
Home / Tips / Sql Server

Sql Server

sql server query pagination

From SQL Server 2012, Microsoft introduced a couple of T-SQL Enhancements. One of them is Query Pagination. In most of the applications, a common requirement is how to fetch the data from the database servers as page wise. In earlier versions of SQL Server like SQL Server 2005/2008/R2, we can implement …

Read More »

How to find locked tables in sql server

Locked Tables

In multiuser environments, sql server ensures the integrity of the data by setting write locks on all the tables(Locked tables) when you are updating. This prevents other users from making changes to the same tables. if the table is locked we cannot do any CRUD(insert/select/update/delete) operations on table until it …

Read More »

dbForge Studio for SQL Server – Ultimate SQL Server Manager Tool from Devart

dbForge-Studio-for-SQL-Server

dbForge Studio for SQL Server is a powerful IDE for SQL Server management, administration, development, data reporting and analysis.The tool will help SQL developers to perform complex database changes, version-control database changes in popular source control systems, and speed up routine tasks. dbForge Studio for SQL Server Features Overview: Devart’s …

Read More »