Thursday , April 18 2019
Home / DataBase / SQL SERVER


How to Identify Database memory in Sql Server

Identify database size in sql server

  If we run below script it gives us details about memory used by each of the databases . The script returns results in MB. Please remember that it retrieves the data from operating system’s buffer and it keeps on changing. However, this gives information at least relevant to the …

Read More »

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 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 »

ISNULL() Vs NULLIF() in sqlserver


In this article I will explain the differences between the ISNULL() and NULLIF() functions in SQL Server 2012. ISNULL() Function The ISNULL() function is used to replace NULL with the specified replacement value. This function contains only two arguments. Syntax ISNULL (check_exp, change_value) Example 1 : Select ISNULL(null,15) ‘ISNULL VALUE’ output: 15 …

Read More »

Free Ebook : Introducing Microsoft SQL Server 2016

sql_2016 ebook

Free Ebook : Introducing Microsoft SQL Server 2016 SQL Server 2016 is the latest addition to Microsoft’s data platform, with a variety of new features and enhancements that deliver breakthrough performance, advanced security, and richer, integrated reporting and analytics capabilities. Built using the new rapid-release model, SQL Server 2016 incorporates …

Read More »

AdventureWorks Database collection (2014,2012,2008,2005)

AdventureWorks Database

The AdventureWorks database is a fictitious company database that has existed since SQL Server 2005 as a means to show new functionality in each new version released. Because the Books Online TSQL samples leverage this sample database, AdventureWorks has become a vital aspect of learning new features/constructs within SQL Server. …

Read More »
Page 1 of 6
1 2 3 6