In Microsoft SQL Server 2000, when you try to assign a binary large object data type from an application to an input parameter of a stored procedure, the assignment operation may fail when the data is large. This behavior occurs when the data type is image, text, or ntext. When you try to assign the

(Stefan Prodan) If you made an application that is using an SQL database that needs to be located on the client server, VS.NET Setup Project doesn’t help too much, you could go for InstallShield or other product that will make things easy but the costs will get higher. So searching for a free soluti

(T.K. Anand) Learn about common data integrity issues, and see how Analysis Services 2005 gives you the tools to handle them.

(Larry Chesnut) The other day, I got an interesting email. The jest of the question was, “When you partition a table, and the associated index, where are the statistics stored? If you swap a partition in/out, does that cause all the statistics to be recalculated?”

(Jamie Thomson) Surrogate keys are generally considered fundamental building blocks of a data warehouse. They are used as identifiers for dimensional members and enable us to manage slowly changing dimensions.

(Michael Balloni) Relational databases like Microsoft’s SQL Server use locks to prevent multiple users from making conflicting modifications to a set of data: when a set of data is locked by a user, no other users can modify that same set of data until the first user finishes modifying the data and

(Teo Lachev) Regardless of the alphabet soup of terms and acronyms that are popping up like daisies almost every day and that have probably become a part of your IT vocabulary—terms such as BI (business intelligence), OLAP (online analytical processing), data mining, DSSs (decision support systems),

(Arthur Fuller) SQL Server ships with a variety of templates designed to simplify the most common tasks. The author explains how you can customize these templates, or create new folders in the SQL Query Analyzer folder and populate them with your own templates. (R)

(Brian Walker) A table of sequence numbers consists of N rows with each row containing a unique integer value from 1 through N. In some cases it may be more convenient to have the values X through Y where Y-X equals N-1. A table of sequence numbers can be very useful for a variety of purposes. See L

(Bogdan Crivat) Learn more about the new APIs for data mining in SQL Server 2005, and get an introduction to several common development scenarios.