Troubleshooting problems with SQL Server 2008 R2 alerts If you have problems with SQL Server 2008 R2 alerts, review this troubleshooting checklist to find potential solutions. 1. Check that you use the latest SQL Server 2008 R2 service pack. Because some SQL Server 2008 R2 alerts bugs were fixed in SQL Server service packs, you should install the latest SQL...
Other News
Integrating Spring Batch and MongoDB for ETL Over NoSQL
(Ira Agrawal) In today’s enterprises, I deal with applications which are interactive or which run in batch mode. Interactive applications are like Web applications in that they require user input. By contrast, applications which need to start once and end after completing their required jobs are cal
How to do character based data manipulation in SQL and XQuery
(Frank Zhou) The following SQL pattern can be used to do character based data manipulation by utilizing the XQuery functionalities.
How to get started with jQuery
(Ryan Boudreaux) Getting started with jQuery is not a difficult task; in fact, it’s much easier than writing your own JavaScript code. However, it too does take some practice to get the feel of how to use it to take web documents to dynamic content.
Parameter Wednesday – DB CFG – LOCKLIST
(Ember Crooks) Specifies the maximum amount of memory to use for a list of locks within the DB2 database. DB2 stores lock information in-memory in this one location. The locklist is not written to disk.
What is DB2 for z/OS Accounting Class 2 Not Accounted Time? – – A follow-up
(Willie Favero) You would be surprised how many times a question comes up about DB2 Accounting Class 2 “Not Accounted Time”. People want to know what that other time is. You know, that time that is not talked about and ends up being unaccounted that makes up the rest of the Class 2 Accounting data.
A LINQ Style Range Generator
(Richard Carr) Language-Integrated Query (LINQ) provides the Enumerable.Range method that generates incrementing sequences of integers. This article describes a similar method that allows the creation of more complex ranges with the repeated application of a function.
TOO_MANY_ROWS and Variable Assignment
(Hemant K Chitale) When you have a cursor that is assigning a return value to a variable, you expect the cursor to return a single row. If it returns more than one row, the resulting error is a TOO_MANY_ROWS error. This can be handled as an Exception.
Truncating Tables in SQL Server
(Richard Carr) Deleting large amounts of data from a SQL Server table can be an expensive operation, in terms of transaction log space, memory usage and the creation of locks. When emptying a table completely, truncating the table can be a less expensive option.
SQL SERVER – Difference between DATABASEPROPERTY and DATABASEPROPERTYEX
(Pinal Dave) Earlier I asked a simple question on Facebook regarding difference between DATABASEPROPERTY and DATABASEPROPERTYEX in SQL Server.
