(Dinesh Priyankara) Definitely you must have read the article by James Travis’s called =NULL AND IS NULL that is very informative. After reading the article, I really wanted to gather more related information that are used in day-to-day operation and ended up with a couple of things. Then, as usual,

(Himanshu Khatri) Stored procedures can offer performance gains when used instead of regular queries. This article will start with the basics and give you the complete overview on stored procedures and how to use them. Have you ever thought what happens when your queries get to the database?. They a

(Brian Moran) Three of my last five performance-tuning clients faced problems associated with user-defined functions (UDFs). As SQL Server 2000’s customer base matures and becomes more comfortable with the product’s advanced features, more people are using UDFs without recognizing the problems they

If you run an UPDATE statement on the partitioning column of a partitioned view and the UPDATE statement includes an inner join to another table, a scan of each partition table may be performed. This problem occurs although a useful index exists on each table. Depending on the size of each partition

SQL Server 2000 has the option to save a DTS package to a Visual Basic file. If a Microsoft SQL Server 7.0 package is saved as a Visual Basic file by using SQL Server 2000 tools, it may cause several run-time errors if you execute the Visual Basic script on a computer that has SQL Server 7.0 and Mic

(Marcin Policht) In the concluding article of this series, we will discuss transaction support in SQL Server 2000 Data Transformation Services. Transactions within DTS packages serve the same purpose as in other SQL Server based operations – they provide the set of features described collectively us

(Chad Miller) few years I was troubleshooting an issue with share and NTFS permissions and I ran across a nice little utility called DumpSec from SomarSoft which generates reports on permissions and user accounts for an Windows based system. You can obtain DumpSec from SomarSoft (http://www.systemt

(Navneeth Diwaker Naik) One of the best features of SQL Server 2000 is its user-defined functions (UDFs). UDFs offer many of the benefits of both views and stored procedures, and more.

(Chad Miller) If you’ve noticed the Active Directory tab under SQL Server Properties in Enterprise Manager, you might have wondered how Active Directory (AD) relates to SQL Server and what the benefits are of adding SQL Server and its databases to AD. Network services such as file and printer server

(Muthusamy Anantha Kumar) In the typical IT environment, it is often necessary to import flat files to SQL Server tables. Sometimes it is necessary to import many files at the same time from same or different folders. In my previous article, I mentioned how to import such files using BULK Insert and