SQL Feeds - All your SQL feeds in one place.

Friday, March 13, 2009

Conor vs. Isolation Level Upgrade on UPDATE/DELETE Cascading RI

by Conor Cunningham [MSFT] via Conor vs. SQL on 3/13/2009 6:12:52 PM

A customer recently asked our support organization about an unexplained series of range locks that they were seeing on a DELETE to a table with a foreign key. Here is the repro:   1: create table Foo (FooId int not null primary key ) 2: create table...(read more) ...

[ read more ]

Virtualization with Kevin and Brent

by KKline via Kevin Kline on 3/13/2009 5:23:00 PM

Brent Ozar and I had an interview with Jeff James over at SQL Server Magazine.  The topic was virtualization, where Brent and I were able to riff extensively on the topic.  I encourage you to take a look here. And if you haven't already checked it out, look at Brent's excellent blog.  Here's a good place to start:  http://www.brentozar.com/archive/2009/02/sql-server-and-cloud-links-for-the-week-14/. Enjoy! -Kev   Share this post: email it! | bookmark it! | digg it! | ...

[ read more ]

Virtualization with Kevin and Brent

by KKline via Kevin Kline on 3/13/2009 5:23:00 PM

Brent Ozar and I had an interview with Jeff James over at SQL Server Magazine.  The topic was virtualization, where Brent and I were able to riff extensively on the topic.  I encourage you to take a look here. And if you haven't already checked it out, look at Brent's excellent blog.  Here's a good place to start:  http://www.brentozar.com/archive/2009/02/sql-server-and-cloud-links-for-the-week-14/. Enjoy! -Kev   Share this post: email it! | bookmark it! | digg it! | ...

[ read more ]

Database Maintenance Best Practices Part II – Setting FILLFACTOR

by kimberly.nospam@nospam.sqlskills.com (kltripp) via Kimberly L. Tripp on 3/13/2009 9:45:00 AM

When you decide to rebuild or reorganzie an index, you have an option to set something called FILLFACTOR. This is probably the MOST IMPORTANT thing to understand about index maintenance and reducing fragmentation (especially in databases that are prone to it). Unfortunately, we need to dive into some internals to really understand why this is so helpful... What is FILLFACTOR? FILLFACTOR defines how full the leaf level pages of the index are filled when rebuilding or reorganizing an index. ...

[ read more ]

Subscribe

New Feed

Product Spotlight

Recently Updated Sources

Legal Note

The content of the postings is owned by the respective author. SQL Feeds is not responsible for the contents of the postings. This site is automatically generated and cannot be reviewed for abusive content. If you find abusive content on SQL Feeds, please contact us. Designated trademarks and brands are the property of their respective owners. All rights reserved.

Advertise with us