Pages

▼
Friday, 12 November 2010

SQL11 (Denali): OFFSET and FETCH (New options for ORDER BY)

›
It is known that ORDER BY clause has been improved in 'Denali' (code name of the upcoming version SQL Server 2012) adding more optio...
Monday, 18 October 2010

SQL11 (Denali): How to migrate SQL Server 2000 databases to SQL Server 2012?

›
Having found 'SQL Server 2000 (80)' inside the compatibility levels supported by SQL Server 2012, I need to say that the upcoming ve...
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...