Thursday , February 21 2019
Home / Tag Archives: sql server

Tag Archives: 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 »

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 »

sql server Startup Options in SSMS


Normally, after opening up SSMS and once logged in we will Open up a new query window manually to write our scripts but by configuring SSMS startup options we can open new query window or object explorer etc after logged into SSMS immediately Under the Options -> Startup -> At …

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 »

step by step Procedure for Creating DDL Triggers (Part-1)


DDL triggers: DDL triggers fire in response to a variety of Data Definition Language (DDL) events. These events primarily correspond to Transact-SQL statements that start with the keywords CREATE, ALTER, DROP, GRANT, DENY, REVOKE or UPDATE STATISTICS. DDL triggers are fired when user performs DDL events(CREATE,ALTER and DROP) in the …

Read More »
Page 1 of 4
1 2 3 4