(Marcin Policht) So far in our series of articles, we have been discussing relatively generic SQL Server 2000 security related issues that every database administrator is likely to encounter on a daily basis. Now it is time to look into less common scenarios that deal with one specific area of manag

(Stephen Lasham) A table contains a column (particulars) consisting of a semi-colon-delimited string of text, for which the text between the first and second semi-colon needs to be extracted. The extracted text will be no longer than 99 characters. The position of the first and second semi-colo

(Vinod Kumar) This is yet another fequently asked question in the public newsgroups. Here is a simple script that will allow you to do the same easily. In this script I’ve used the truncate clause rather than the delete operation because trucate is faster and doesnot get into the logging process tha

In SQL Server, Performance Tuning can be achieved through many avenues: hardware, software, the database and the client. While there are many pathes that yield gains, finding the imporvements that give the greatest gain with the least impact on your current systems is a must. In SQL Server there

(Itzik Ben-Gan) T-SQL programmers often use user-defined functions (UDFs) to encapsulate algorithm implementations. However, several aspects of UDFs constrain programmers’ capabilities. In “UDF Back Doors” (April 2004, InstantDoc ID 41845), I discussed some UDF limitations and some back doors th

(David Poole) Imagine a contacts database where we need to indicate whether or not a particular contact has a particular attribute of a dynamic list of attributes. For example our contact may be a student who has to choose a set of topics within a course. We may have a table structure similar to

(Mark Frawley) Many SQL Server developers eagerly anticipate the long-awaited release of SQL Server 2005, formerly code-named “Yukon.” Major goals for Business Intelligence (BI) in the 2005 release are better integration of the somewhat loosely-coupled BI components of SQL Server 2000, provide enter

(William Pearson) As most of us that work with MSAS are aware, dimensions as defined in Analysis Services contain many properties, one of which is the default member. The default member can have far-reaching effects from the perspective of information consumers, because they are often not even aware

(Vinod Kumar) The fundamental Pros of storing the images in SQL Server are pretty simple: You gain all the “ACID” properties of a database system. This is something we donot intent to capitalize fundamentally. But the application demands have made us think so and we have unknowingly have used the da

This step-by-step article discusses how to add Microsoft SQL Server 2000 Stored Procedures to Visual SourceSafe (VSS) by using the Source Control feature in Microsoft Visual Studio .NET. There are two types of configuration for adding Stored Procedures by using Source Control: –The VSS database i