Microsoft SQL Server 2005 full-text search includes improved and updated noise word files. These noise word files are located in the following directory: $SQL_Server_Install_PathMicrosoft SQL ServerMSSQL.1MSSQLFTDATA
Author: SSWUG Research
Error Handling in SQL Server – a Background
(Erland Sommarskog) In many aspects SQL Server is a very good DBMS that permits you implement powerful solutions with good performance. However, when it comes to error handling… To be blunt: error handling in SQL Server is poor. It is a patchwork of not-always-so-consistent behaviour. It’s als
Wrapping Your Brain Around Oracle + Python
(Catherine Devlin) PL/SQL is ideal for programming tasks within Oracle Database. Most Oracle professionals, however, aren’t confined to working strictly within the database itself. You’ve probably encountered many tasks for which PL/SQL has proven clumsy or even unusable—such as manipulating files o
Oracle 10g Scheduler Enhancements, Part 2: Job Chains
(Jim Czuprynski) One of the last projects I worked on as a software developer before I became an Oracle DBA was to implement a complex upgrade to several stored procedures within my client’s DB2 database so that a new set of accounting rules could be applied to their commodities management applicati
Fetching the First Occurrence with SQL
(Bryan Watson) How can I fetch the first occurrnce of rows for each ID in my table?
DSN-Less Connection to Oracle with ADO
(Kirby)This sample simply presents a message box indicating the Record Count to demonstrate a DSN-Less Connection. The sample included in the project documented in my Oracle Tutorial Web Site is more detailed and extensive.
Access your MySQL database for maintenance without a password
(Vincent Danen) MySQL is perhaps one of the most popular database systems currently available. It has a lot of great features, it’s open source, and a lot of Web-based applications use it for their back-end storage.
OLAP SQL Part 5 – Windowing Aggregates
(Chris Eaton) To date, I have talked about a number of aggregate functions that can be pretty powerful with analytic queries. But what I find even more interesting is the windowing clause that you can add onto some of these aggregates. This is the part of the OVER () clause that I have not described
Creating MS Word Document using C#, XML and XSLT
(Sudipta Sankar Das) This simple program demostrate how to create well formatted MS Word documents using C#, XML and XSLT. Using XSLT to create Word document requires the knowledge of RTF key words. RTF specification is available in MSDN site.
Using the MultiView and Wizard Controls in ASP.NET 2.0
(Wei-Meng Lee) One task that is common in web applications is data collection. For example, you may need to create a survey page for collecting user inputs. On that page, you may want to collect a fair bit of information such as username, profile, and answers to survey questions (often used to colle