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 SQL can’t handle these two operations concurrently, they would therefore conclude that SQL can’t scale…

0

Follow up on Database snapshot performance question from SQL Server™ 2005 High Availability TechNet evening 21/6/05

Follow up on Database snapshot performance question from SQL Server™ 2005 High Availability TechNet evening 21/6/05   Question; how does a snapshot database perform compared to the original database when it comes to querying – can it make use of the indexes on the original database?   Thanks to my colleague in the States, Lewis…

0

Two SQL 2005 TechNet Evenings I'll be delivering in Reading, UK

For those of you in the area, I’ll be presenting these two TechNet evenings in Reading UK – it would be good to see you there! 14 th June Session Abstract: Microsoft SQL Server 2005 is the next version of the successful SQL Server product family. This new edition offers a number of enhancements to…

0

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 AdventureWorksGO ALTER DATABASE AdventureWorks ADD FILEGROUP FG1ALTER DATABASE AdventureWorks ADD FILEGROUP FG2GO ALTER DATABASE AdventureWorks ADD FILE ( NAME = dat1,  FILENAME = ‘c:\Program Files\Microsoft SQL…

0

The Final Word in Microsoft SQL Server 2000 Backup, Restore and recovery

I am pleased to be able to point you to the last word in SQL Server 2000 Backup and Restore methods. At last all the answers in one place! SQL Server 2000 Backup and Restore Published: March 1, 2005 Author: Pankaj Agarwal Published: February, 2005 Summary: This paper discusses the types of backups that are…

0

Oracle RAC, Grid, IBM, and Microsoft: A Corporate Altercation or Religious Divergence

People often ask me, “When Microsoft is going to get into the type of clustering as defined by Oracle’s RAC (Real Application Clusters)?”  Generally, I find these are people who believe the technical concepts behind RAC are the way of the future, so naturally conclude that Microsoft will want to follow. I have a simple…

1