SQL Server – Creating linked server in SQL Server Management Studio

In SQL Server environments the linked server functionality is commonly used to connect to another (remote) database or file (Xls, CVX) using SQL Server Management Studio (SSMS) and access and use the remote data and objects. Read More …

Setup Transaction Replication in SQL Server 2012

Transaction Replication is used when DML or DDL schema changes performed on an object of one database on one SQL Read More …

Diagnose and fix high DPC Latency Issues with WPA (Windows Vista/7/8)

Many audio/video problems on a computer can be caused by DPC latency. DPC stands for Deferred Procedure Call. In its Read More …

SET NOCOUNT ON Improves Stored Procedure Performance (SQL Server)

Problem One of the biggest things that [gs DBA]s try to do on a daily basis is to ensure that Read More …

How to search all columns of all tables in a database for a keyword? (SQL Server)

This stored procedure accepts a search string as input parameter, goes and searches all char, varchar, nchar, nvarchar columns of Read More …