Pages

▼
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...
Tuesday, 10 January 2006

Exploring ROW_NUMBER function in SQL Server 2005

›
Some of the SQL Server 2005 new features are the Ranking functions which are used to analyse data. Among these functions we have, for instan...
Wednesday, 7 December 2005

The power of PIVOT in SQL Server 2005

›
With the arrival of SQL Server 2005, we have many new features available to make the most out of it. Today's post is going to be about o...