Pages

▼
Wednesday, 5 May 2010

Geo-Replication Performance Gains with Microsoft SQL Server 2008 Running on Windows Server 2008

›
MSCOM Ops Team has done a tremendous and excellent work in testing the performance of SQL Server 2005 replication environments on Windows ...
Sunday, 21 February 2010

How to schedule a SQL Job to run every second in SQL Server 2005

›
It is well known that it is not possible to schedule a SQL Job to run every second or some seconds in SQL Server 2005 by using the wizard (I...
Saturday, 16 February 2008

SQL Server 2008: Row Value Constructor

›
Definitely, we were sometimes in a need of a new technique to insert data massively in SQL Server 2005 and previous versions. We used to do ...
Saturday, 5 August 2006

SQL Formatter Tool

›
Being asked sometimes about a good tool for formatting T-SQL code, I would like to share one of them known as 'SQL Formatter tool'. ...
Sunday, 21 May 2006

Installing SQL Server 2005 Service Pack 1 on all SQL instances via CMD

›
When it comes to installing SQL Server 2005 Service Packs on various instances rapidly, we can do it by executing the Service Pack setup wit...
Friday, 14 April 2006

How to remove 'sa' account from 'sysadmin' fixed server role in SQL Server 2000

›
When it comes to securing the databases, we need to have a small number of accounts with 'sysadmin' fixed server role, which means t...
Tuesday, 14 March 2006

How to uninstall SQL Server 2005 instances successfully

›
With the passing of days, the number of people asking me how to uninstall SQL Server 2005 instances successfully is on increase. I would lik...
Sunday, 5 February 2006

Improving the performance by using 'Boost SQL Server Priority' option

›
Boost SQL Server Priority is one of the many options that we can configure at SQL Server instance level in order to improve the performance...