August 2009 - Posts

0
Comments

Commercial-Ready but Free Momentarily for SQL Server Development Tools from Cogin by Kasim.Wirama

Commercial-Ready but Free Momentarily for SQL Server Development Tools from Cogin By : Kasim Wirama, MCITP, MCDBA I find SQL Server Development tools at Cogin website and it has DbOctopus product. The product targets to all SQL Server versions. It has...
Filed under:
0
Comments

Displaying One Item Randomly for Each Group in SQL Server 2005/2008 by Kasim.Wirama

Displaying One Item Randomly for Each Group in SQL Server 2005/2008 By : Kasim Wirama, MCITP, MCDBA You might ever find request to display only one item randomly for each groups as given below script. CREATE TABLE test (cola int, colb int); GO INSERT...
Filed under:
0
Comments

Assigning Row Number without Specific Ordering by Kasim.Wirama

Assigning Row Number without Specific Ordering in SQL Server 2005/2008 By : Kasim Wirama, MCITP, MCDBA As database developer or application developer, sometimes you need to assign row number from SQL Server. In SQL Server 2000 or earlier, you need to...
Filed under:
0
Comments

Extended Index Query Hints in SQL Server 2008 by Kasim.Wirama

Extended Index Query Hints in SQL Server 2008 By : Kasim Wirama, MCITP, MCDBA Kimberley’s blogs titled “The Tipping Point Query Answers” is informative to explain why you get table scan though you have nonclustered index on columns in WHERE clause. Have...
Filed under:
0
Comments

Transition to Database Developer is One Step Higher from Application Developer by Kasim.Wirama

Transition to Database Developer is One Step Higher from Application Developer By : Kasim Wirama, MCITP, MCDBA An application developer should be a database developer. The reality, some application developers are not conversant in database development...
Filed under:
Copyright © INDC, 2006. All rights reserved.
Powered by Community Server (Commercial Edition), by Telligent Systems