Pages

▼
Friday, 25 July 2014

SQL Server Transactional Replication Error: Could not find stored procedure error and how to recover it by using sp_scriptpublicationcustomprocs

›
Today my tip about how to fix the “SQL Server Transactional Replication Error: Could not find stored procedure” has been published online in...
Monday, 23 December 2013

Error: Index was outside the bounds of the array

›
It is said that we may work on SQL Server connecting to Object Explorer by using the SQL Management Studio tool (SSMS) of an older version. ...
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 ...