Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » Performance » Business Intell... » SQL Server 2005   (RSS)
Tuesday, September 06, 2005 6:11 PM

SQL 2005: Making sense of the new Optimistic Concurrency Controls and the readers that block writers

For a long time now Oracle enthusiasts have bashed SQL Server for not having Optimistic Concurrency Controls. They would demonstrate a SQL Server reader blocking a writer and possibly a writer blocking a reader. Thus, having appeared to demonstrate that
Posted by Mat_Stephen | 0 Comments
Tuesday, August 30, 2005 4:27 PM

Project REAL—Business Intelligence in Practice - great website!

For sometime a group of Program Managers from the SQL BI team have been working with a customer, Barnes and Noble, to produce a SQL BI solution for their data warehouse and analysis needs using SQL 2005. The leasons learnt from all their work is being
Posted by Mat_Stephen | 0 Comments
Monday, April 18, 2005 4:49 PM

TechNet Roadshow Example code for Microsoft SQL Server 2005 Table partitioning

For those who want to give this a try, this is the code I've been using on the 2K5 H1 roadshow for my SQL 2k5 Table Partitioning demo. USE AdventureWorks GO ALTER DATABASE AdventureWorks ADD FILEGROUP FG1 ALTER DATABASE AdventureWorks ADD FILEGROUP FG2
Posted by Mat_Stephen | 0 Comments
 
Page view tracker