(Erland Sommarskog) Error handling in stored procedures is a very tedious task, because T-SQL offers no exception mechanism, or any On Error Goto. All you have is the global variable @@error which you need to check after each statement for a non-zero value to be perfectly safe. If you call a stored

(Carl Rabeler, Len Wyatt and Dave Wickert) Users can analyze data stored in Microsoft SQL Server Analysis Services with greater speed and flexibility than users can query the same data stored in a relational database. Analysis Services queries data more efficiently because it organizes data into mul

(Buck Woody) The basics of programming against databases requires a firm understanding of the language used to create objects such as tables and views, read data, update data and remove data and objects. You might see these commands referred to as CRUD—for CREATE, READ, UPDATE, and DELETE.

(Chris Kemp) SQL Server Stored Procedures are SQL statements saved in a database as an object. They can be called interactively through the Query Analyzer, and by other stored procedures.

(Bryan Watson) How can I fetch the first occurrnce of rows for each ID in my table?

(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

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

(Bill Hamilton) In this second part of a multi-part article covering the Notification Services framework, you will learn how to create a Notification Services instance and application, a delivery channel, and more.

Consider the following scenario. You try to restore an archive file for a Microsoft SQL Server 2000 Analysis Services database. The server on which you try to restore the archive file and the server on which the archive file was originally created have different regional settings or different langua

(Scott Mitchell) Last week I wrote an article on implementing custom paging in ASP.NET 2.0 aptly named Custom Paging in ASP.NET 2.0 with SQL Server 2005. In that article I covered how to efficiently page through large amounts of data using Typed DataSets, an ObjectDataSource control, and SQL Server