by Alexander Chigrik – Useful information about full-text search, from software requirements to how to set up full-text search step by step.
Tag: sql server
Word wrapping with T-SQL
By Andrew Novick – Word wrapping isn’t the kind of task that is done in T-SQL very often. That’s a good thing. The SQL Server engine isn’t really the right location for formatting functions like wrapping. However, there are times when there isn’t a suitable front end that can perform the word wrappi
Retrieve an Identity Value
by Roman Rehak – Most objects in ADO.NET were designed to operate in a disconnected mode. The data is retrieved from the server and cached on the client in a DataSet or DataTable object. You make changes in the client application and use a DataAdapter to connect to the database and propagate the cha
Keeping Up with Web Releases
By Michael Otey – Microsoft offers a lot of functionality as free downloads, including the latest SQL Server 2000 XML functionality. If you ignore these updates, you’re leaving money on the table.
Case-Sensitive Comparisons
How can I program a case-sensitive comparison of a user-typed password on a case-insensitive SQL Server 7.0 instance?
SQL Server Hardware Resource Planning
by Robert H Chin – Planning on getting new SQL Server hardware, this article might provide some help.
A Set-Based Way To Find Specific Rows
I have a table that includes a single-column primary key called IdValue. Given a particular value for IdValue, I want to find the table rows that are immediately before and after my target value (assuming the result set is sorted by IdValue). How can I avoid using cursors and get the result I want w
Protegrity Delivers Database Encryption, Key Management
By Lisa Vaas – Protegrity Inc. is rolling out security packages for leading databases that combine software with cryptographic hardware to provide enhanced key management capabilities.
Java interaction with databases boosted
By Paul Krill – SOLARMETRIC released an upgraded version of its Kodo JDO tool, which enables a database to talk to Java applications without tedious coding and upkeep, the company said.
Second Wind for Database Market?
By Erika Morphy – The noise level has gotten louder in the corporate database market over the last several months. Analysts have been predicting that a growth spurt is due, and the vendors are positioning themselves for such an event: IBM’s (NYSE: IBM) DB2, Oracle’s (Nasdaq: ORCL) 9i and Microsoft’s