Category: Articles
-
Running Adhoc queries against multiple servers using SSMS 2008
Getting information from multi servers for a query is a big process for DBAs and we don’t have a direct option available till SQL 2008 Client tools. We need to write our own manual batch file to execute the query against all the server to fetch the information. In SQL Server 2008 management studio MS…
-
Ten Minutes to configure Reporting Services 2008
In my previous webcast we have seen how to install reporting services 2008. Here is my next webcast on configuring reporting services 2008.
-
How to do Table Partitioning to an existing source table
In this article we are going to see how to partition a existing table in a database. In my working place I got a request from client to partition an existing table, I have searched in BOL but couldnt find the exact detail how to do it. Ive figured out that and Implemented successfully, Im…
-
Installing SQL Server Reporting Services 2008
In this webcast we are going to install SQL Server reporting services 2008. Watch the video and post your feed back incomments.
-
Activity Monitor
Activity monitor has been refreshed in SQL Server 2008 Management studio. Microsoft has recoded the activity monitor written for SQL 2005 to provide more information on SQL Server processes and how these processes affect the current instance of SQL Server. The first change which I experienced is the real time graphical view of processes, CPU…