Recent Postsyou can find the full data dictionary of AdventureWorks database. I will specially recommend you to check xml columns and how they are treated in this database to better understand the usage of xml columns in SQL Server 2005
This article describes how sql server query plan caching works. It gives you working examples of how to write cache efficient dynamic sql queries.
When we talk about dynamic sorting or sorting the query based on parameter supplied by the user, most of us start thinking to implement it by using dynamic sql where they create the query on the fly and execute it. Dynamic SQL has many many issues and very few advantages. As a rule of thumb, [...]
Microsoft has announced that SQL Server RTM (i.e. Release To Manufacturer) version will not be available until 3rd quarter of 2008. Interesting thing is that Microsoft is not canceling “Heroes Happen Here” series of launch events in which VS2008 and SQL Server 2008 were planned to be released officially. This decision will impact the technological [...]
Maintaining proper foreign keys is a very good practice and mostly an indicator of a good design but you may start observing slow insert and updates when your data grows. This happens because if you will not create index on a foreign key column then every insert and update will cause a full table scan [...]
