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 …

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

Read More …

SET NOCOUNT ON Improves Stored Procedure Performance (SQL Server)

Read More …

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

Read More …