Thursday , April 18 2019
Home / DataBase / SQL SERVER (page 2)


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 »

what is Trigger and Types of Triggers in SQL Server


Triggers in Sql Server:- A trigger is a special kind of stored procedure that automatically executes when an event occurs in the database server.A trigger is executed implicitly whenever the triggering event happens, which performs their own operation when user performs any INSERT, UPDATE, DELETE operations on a specific table. …

Read More »

5 Tips for a Smooth SSIS Upgrade to SQL Server 2012


SSIS Upgrade Microsoft SQL Server 2012 Integration Services (SSIS) provides significant improvements in both the developer and administration experience. This article provides tips that can help to make the SSIS Upgrade to Microsoft SQL Server 2012 Integration Services successful. The tips address editing package configurations and specifically connection strings, converting …

Read More »

Free ebook: Introducing Microsoft Power BI

Microsoft PowerBI

Microsoft Power BI: Get started quickly with Microsoft Power BI! Experts Alberto Ferrari and Marco Russo will help you bring your data to life, transforming your company’s data into rich visuals for you to collect and organize, allowing you to focus on what matters most to you. Stay in the …

Read More »

Union vs Union All in Sql Server

Union vs Union All in Sql Server: UNION The UNION command is used to select related information from two tables, much like the JOIN command. However, when using the UNION command all selected columns need to be of the same data type. With UNION, only distinct values are selected. in …

Read More »

View All Databases Information In SqlServer


 View All Databases Information In SqlServer: There are different ways of listing all databases within an instance of SQL Server. 1.Sp_helpdb : Reports information about a specified database or all databases. Example 1: exec Sp_helpdb Output: Example 2: exec Sp_helpdb ‘Construction’ 2. sp_databases  : Reports all databases Names and Sizes Example: EXEC sp_databases  …

Read More »


DBCC SQLPERF (Transact-SQL): To increase sql Performance always we need to keep an eye on log File size. DBCC SQLPERF command will get size information about the transaction logs for all databases , so this command will useful in helping to monitor the growth of your transaction logs. Syntax: DBCC SQLPERF( logspace) …

Read More »
Page 2 of 6
1 2 3 4 6