The most important performance-tuning technique available is having the needed indexes created on the tables to ensure that the SQL Server database engine is able to get the data that it needs to as ...

We've been exploring the usefulness of one of the best features of the upcoming version of SQL Server 2005 codenamed 'Yukon'. We've seen how you can create UDIs (User Defined Functions), Stored ...

Today I’m going to blog about persisting hierarchies (tree-like structures) in relational databases. Actually not persisting, but more retrieving — as you most probably know hierarchies are stored in ...