If sales are not progressing as expected the decisive point is to identify the problem area. Is it the sales force, the suppliers, or maybe an entirely different area? To make sense out of and establish causalities from raw data to ascertain why things have developed the way they have is precisely w

(Mike Gunderloy) Sometimes, buying software is simple. If you want a copy of a simple HTML editor, for example, you just go to the vendor’s Web site, find out how much it costs, fill out the online order form with your credit card number, and download your copy. But as you start dealing with more co

When you use the Transact-SQL BULK INSERT command in Microsoft SQL Server 2000, you may experience one or more of the following symptoms: • You may experience unexpected delays in query execution. • You may experience unexpected time-out situations. • You may receive error message 17883 in t

(Don Schlichting) This article will introduce Common Table Expressions (CTE) on SQL 2005, and compare them with related SQL 2000 methods such as Derived and Temporary Tables.

(Douglas Reilly) Euan Garden is clearly a database geek. He is a Microsoft group program manager for SQL Server, and is responsible for cross SQL Server projects relating to consistency and readiness. Prior to that he spent four years as the manager of Microsoft’s SQL Server Tools development team.

(graz) My interest in writing this article was started by an MSDN article titled SQL Server 2005: The CLR Enters the Relational Stage. The article shows how to write a function that returns the top three countries per category. That’s always been something that was difficult to do in SQL so I wa

(Serdar Yegulalp) Among the many highly touted features in SQL Server 2005, the one that probably has the most relevance for programmers who work with SQL Server is the Common Language Runtime, or CLR for short. CLR allows programmers to create stored procedures, triggers, user-defined functions, ag

When you try to parse a query in Microsoft SQL Server 2000, you notice that the query runs slower than you expected. This problem may occur when the following conditions are true: • Your query is based on a view that contains many aggregate functions. • You have a filter condition on your quer

(Muthusamy Anantha Kumar) SQL Server job schedule configuration is limited to a one-time occurrence: daily, monthly and weekly. [Refer Fig 1.0] There are many occasions when you need to run a job on certain dates in a year. Many Finance and pharmaceuticals companies have End of Month processing, End

In Microsoft SQL Server 2000, the Transact-SQL BULK INSERT statement silently skips insert attempts when the column is defined as NOT NULL for an INT, SMALLINT, or BIGINT data type.