(Mohammad Azam) We all have used transactions in one way or the other. In this article, I will show you how you can make use of the SqlTransaction class, which is introduced in ADO.NET 2.0.
Author: SSWUG Research
Custom Paging in ASP.NET 2.0 with SQL Server 2005
(Scott Mitchell) A common pattern in web development is providing paged access to data. Rather than displaying the entire contents of a report or database table to an end user, developers often show only a subset of records per web page, with controls for moving from page to page. With ASP.NET 1.x,
Generating Restrictions in XML Schema Dynamically Using VB.NET 2005: Preliminaries
(Jagadish Chaterjee) This is the first article in a series concentrating on generating restrictions in XML Schema dynamically using Visual Basic 2005. The series is mainly targeted at those who are familiar with XML, XML Schema and the .NET framework.
SQL Performance and Tuning Considerations
(Andy Oppel) This final chapter covers performance and tuning considerations for making the SQL statements you write run faster and more efficiently. First, we’ll have a look at general things that can be done at the DBMS level, followed by guidelines for writing efficient SQL. The
Faster Batch Processing
(Mark Rittman) When you need to load millions of rows of data into a table, the most efficient way is usually to use an INSERT, UPDATE, or MERGE statement to process your data in bulk. Similarly, if you want to delete thousands of rows, using a DELETE statement is usually faster than using procedura
Asked & Answered
(Roger E. Sanders) Q: In your recent column on split mirroring [Distributed DBA, Quarter 4, 2005], you write that the SET WRITE RESUME command must be executed from the same database connection that has executed the SET SUSPEND command. What do you do when this session has abended? (The same problem
Enable OLAP report globalization feature using DB2 Alphablox with DB2 Cube Views
(Jin Ji Wen and Shen Yu) Today, many exciting business events take place in non-English speaking regions. For example, Arabs are leading in the petroleum business and the Chinese are leading in the textile space. Merchants from these countries or regions feel more at ease when communicating in their
‘Wouldn’t it be Nice’ (start humming the old Beach Boy’s song)
(Willie Favero) In 1966 “the Beach Boys” coined the phrase “Wouldn’t it be Nice” in one of their hit singles. Everyone has a “Wouldn’t it be Nice” list in the back of their mind for something. Some even have a list for stuff they would like to see someday in DB2. So, I thought an entry talking about
Data Warehouse ETL Performance Tuning – Case Studies
(Tao Zheng) As production data warehouse extract, transform and load (ETL) can be a very time-consuming and resource-intensive task, plus the fact that the ETL window has become increasingly shortened while data size is exploding, there is always pressure on data warehouse developers and managers to
Develop wireless apps with XHTML Mobile Profile
(Hany Saleeb) The focus of most mobile technology applications developers is to build new wireless technologies that conform to varying bandwidth and memory limitations. With XHTML Mobile Profile, you can build apps that adhere to hardware requirements for users on different devices and render on mu