Newsflash

We are back again for this month UG session.

Venue: Microsoft Training centre, Radhakrishnan Salai, Chennai
Landmark: Opposite to President hotel
Timings: 10 AM to 01 PM
Date: October 31 2009
Max Available seats : 25 (Please register, we will be closing the registration once we have 5 members registered)

Index fragmentation Report

Print
PDF

Written by Deepak | 01 March 2010

I had to prepare the list of tables having more than 60% fragmentation. I wrote this query to get those information. The below query will give the list of all the fragmented tables in a particular database having more than 60% fragmentation. This will work for SQL 2005 and beyond.

Read more... Add new comment

Function to Split Comma separated string to Integer

Print
PDF

Written by Deepak | 05 February 2010

 

There are cases where we need to pass the input parameter to the stored procedure as a comma-separated string in order to avoid multiple db calls from happening. This helps in reducing the db calls thereby reducing the load on the db server.

The below function will split the given comma-separated string into integers and process the results.

Read more... Comments (2)

Measure SQL Server Replication Latency

Print
PDF

Written by Sugeshkumar Rajendran | 21 January 2010

This script can be used to measure Latency in your Replication Subsystem. This script does not use TRACER TOKENS and there would be no negative impact to the system's performance.

Read more... Comments (6)

Change \ Transfer Schema for all Objects

Print
PDF

Written by Vidhya Sagar | 21 December 2009

In my working environment we will be using different schema for production and development environments. Our development apps are configured to Dev schema and Production apps are configured to Prod schema, so when we restore the db from production to development environment, all our dev apps stopped working since the objects \ securable will be using prod schema. Here I need to change the schema to dev from prod, so the syntax will be like below

Read more... Add new comment

Monitoring Replication using Scripts(Version 1.0)

Print
PDF
(9 votes, average 3.56 out of 5)

Written by Sugeshkumar Rajendran | 18 December 2009

This script can be used to monitor replication using scripts instead of logging into the server and using replication monitor. It gives information on Transactional replication status.

Read more... Comments (6)

More Articles...