Parallel Data Warehouse Overview

Introduction SQL Server 2008 R2 Parallel Data Warehouse (PDW) is a highly scalable appliance for enterprise data warehousing.   The PDW works by using Massively Parallel Processing Software and Appliance hardware to control several physical servers each running their own instances of SQL Server 2008. This control process allows the PDW to scale out query processing…


Monitoring tempdb Transactions and Space usage

As the tempdb database is the common global resource for all the operations going on in SQL Server, so the DBA has to be bit cautious about the use of it. Because any unexpected operations by the applications running under the SQL Server instance or any adhoc query by the user can eat all the…


Ranking Functions in SQL Server

SQL Server introduced four different ranking functions either to rank records in a result-set or to rank records within groups of records of a result-set. With this inclusion we are no longer required to write several lines of code to get ranking. It does not only help in simplifying the query, but also improves the…


Storage Reporting Tool

If you have multiple servers and want to capture the space availability to plan for future, then this tool can be used collect those information.   This tool will only run in Windows OS and a SQL server installed in one of the machine to store the data.     Storage Reporting Tool.rar


Job Fails on Linked Server – Access to the remote server is denied because the current security context is not trusted. [SQLSTATE 42000] (Error 15274)

Problem: Having a SQL Agent Job, which executes a Stored prcedure to connect to a remote SQL server via linked server and extract/manupulate the data. The SP runs successfully in SSMS but get failed, if run through an agent Job. NOTE: A Windows a/c is used here to connect to remote server and the a/c…


Issues with Updatable Subscriptions for Transactional Replication

Careful with Replication type “Updatable Subscriptions for Transactional Replication” when your application does not use column names in INSERT and SELECT statements and has database triggers NOTE:This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use…