Pages

▼
Sunday, 12 December 2010

SQL11 (Denali): New object SEQUENCE

›
SQL Server 2012 CTP1 is coming up with a new object named SEQUENCE which allows to manage sequence numbers between 2^31 – 1 and 2^31 –1. SEQ...
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...