Fast Text Processing in SQL Server
Processing text or long strings usually reduces SQL to a prosaic procedural language. Learn a few techniques for facilitating speedy text processing in SQL.
2006-05-10
5,032 reads
Additional Articles
Scaling Out SQL Server 2005
This article explains the different technologies that are available for scaling out a SQL Server 2005 database application, focusing on the factors that go into deciding which solution(s) to use in your application.
2006-05-09
2,685 reads
Using XQuery, New Large DataTypes, and More
SQL Server 2005 introduces a lot of new features, but it also enhances the popular and oft-used Transact-SQL (T-SQL) language. Changes include the introduction of new datatypes to store large values using the MAX indicator, the integration of enhanced XML querying and data modification with XQuery, and the new XML datatype.
2006-05-08
2,508 reads
Conceptual, Logical, Physical:
As part of my research with the University of Melbourne, I asked 55 attendees of advanced data modeling seminars in the US (25 attendees) and UK (30 attendees) to list the stages in database design, including data modeling.
2006-05-05
3,422 reads
SQL Server 2005 Books Online Update
Download an updated version of Books Online for Microsoft SQL Server 2005, the primary documentation for SQL Server 2005. The April 2006 update to Books Online contains new material and fixes to documentation problems reported by customers after SQL Server 2005 was released. Refer to "New and Updated Books Online Topics" for a list of topics that are new or updated in this version. Topics with significant updates have a Change History table at the bottom of the topic that summarizes the changes.
2006-05-04
3,226 reads
Create Reports from Any Data Source Using SQL Server Reporting Service
SQL Server Reporting Services makes it easy to build reports from database data, but what if the data isn't in a database? This article shows you how to take advantage of Reporting Services' unique extensibility model to build reports from ADO.NET datasets.
2006-05-03
2,879 reads
Understanding SQL Server Full-Text Search, Part I
SQL Full-text Search (SQL FTS) is an optional component of SQL Server 7 and later, which allows fast and efficient querying when you have large amounts of unstructured data. This is the first of a two-part article that explores the full-text language features that ship with SQL Server versions 7, 2000, and 2005, with particular focus on the new language features in SQL 2005.
2006-05-02
3,641 reads
Getting Started with MDX Scripts
In this article, adapted from the just-published second edition of MDX Solutions that Chris co-authored with George Spofford, Siva Harinath, Dylan Hai Huang, and Francesco Civardi, Chris shows us how to start exploring the world of cubes and MDX Scripts.
2006-04-30
1,472 reads
Review: Red Gate SQL Bundle 5
When architects speak with database administrators, it is important they come forearmed. Tools can help. While Microsoft's own database management tools cover the most common database administration scenarios, they don't do anything about some of the most common pain points faced when you need to maintain and deploy SQL Server databases for projects under active development. That's where Red Gate comes in.
2006-04-28
1,984 reads
The Writing on the Wall
There is a world of difference between the business processes that really take place in a company and the management's understanding of those processes…
2006-04-27
2,351 reads
Blogs
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Forums
Windows logins for users migrated from DomainA to DomainB
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers