(Darren Green) One of the new tasks in SQL Server 2005 is the For Loop Container. In this article we will demonstrate a few simple examples of how this works. Firstly it is worth mentioning that the For Loop Container follows the same logic as most other loop mechanism you may have come across, in t

(Sharad Nandwani) GUID is a way to ensure uniqueness of the values. It finds use in various scenario’s. GUID is produced by using a combination of Time and Network Address so there is no chance of getting a duplicate GUID. Microsoft guarantees GUID’s to be unique for the next century. (R)

(Robert Westervelt) Improved business intelligence tools, enhanced memory management components and the ability to easily debug scripts has Don Watters, a senior database administrator with the Walt Disney Internet Group, feeling good about the newest version of SQL Server 2005 database management s

(William Pearson) In this lesson, we will expose another popular function in the MDX toolset, the .Item() function. The general purpose of the .Item() function, as we shall see, is twofold: to return a member from a tuple, or to return a tuple from a set. We will consider each variation, to which I

(Allan Mitchell) To do some of the stuff we wanted in SQL Server 2000 DTS we had put together some serious glue code and to be honest it wasn’t pretty. One of the things that we used to have to do this way was if we wanted to implement using workflow constraints a Logical OR. Well that has changed a

(Rodney Landrum) As a DBA and data analyst, no matter how hard I try, I can’t always avoid writing code to solve complex problems or take advantage of the wealth of management tools that SQL Server provides. Over the years, I’ve scripted solutions for all kinds of SQL Server-related projects, from c

(Andy Warren) In a recent article I discussed some potential performance issues that result from doing a case sensitive join on a column that is not case sensitive and offered one alternative. This time I’m going to look at whether it would make sense to change the collation on the column to cas

(Deac Lancaster) This chapter covers the building blocks available to the database designer and database user to create and modify database objects and data. The SQL Data Types will be covered along with data representation as literals (constants) and expressions. Also covered are methods to display

(Darshan Singh) SQL Server 2005 introduces new and improved features for both, developers and database administrators. Developers now can write stored procedures using any of the managed .NET language, work with XML and XQuery, Web services-enable their T-SQL code, create scalable asynchronous messa

(Luis Martin) As a DBA, it is our regular task to review our databases and see if there is any way we can boost their performance. While adding new or better indexes to a database is one of the primary ways we can boost performance, an often forgotten way to help boost database performance is to rem