SQL Feeds - All your SQL feeds in one place.

Friday, April 10, 2009

SQL Server 2005 / 2008 table partitioning : Important things to consider when switching-out partitions.

by mssqlisv via SQL Programmability & API Development Team Blog on 4/10/2009 11:43:00 PM

An ISV recently found an anomoly in their implementation of a "drop table partition" function which could lead to unexpected partitions being switched out. Typically, to do this "drop partition logic" SQL Server partitions are manipulated using the following operations: ·      switch-out the partition which isn't needed anymore (or being archived) into an empty target table ·      merge / reset the partition function ranges of the partitioned s ...

[ read more ]

How Dirty are your Reads?

by Andrew Kelly via Andrew Kelly on 4/10/2009 11:08:11 PM

As a SQL Server consultant I get to see a lot of different sets of code written by all sorts of database developers from all over the world. And I have to say that one thing that is clear is most developers make abundant use of the NOLOCK query hint or the READ UNCOMMITTED isolation level. Now don’t get me wrong, I am NOT trying to say this is bad and people should not do that. There is a place and time for all the features and hints SQL Server has to offer and these can be quite handy indeed. T ...

[ read more ]

Paul's Survey - Does size really matter or is it what you do with it?

by kimberly.nospam@nospam.sqlskills.com (kltripp) via Kimberly L. Tripp on 4/10/2009 3:28:00 PM

If you haven't seen Paul's weekly survey, please take a look. We're trying to get a feel for the general state of database structures out there... Here's the link: http://www.sqlskills.com/BLOGS/PAUL/post/Weekly-survey-does-size-really-matter-or-is-it-what-you-do-with-it.aspx. THANKS and have a great weekend! kt ...

[ read more ]

RunAsRadio Interview about Developers and DBAs - whose job is it?

by kimberly.nospam@nospam.sqlskills.com (kltripp) via Kimberly L. Tripp on 4/10/2009 10:52:00 AM

A couple of weeks ago I wrote a blog post titled Whose job is it anyway? It's an interesting debate and something I've been hearing more and more - that SQL Server is a "set it and forget it" technology - a black box where you just don't need to know how it works to do well with it. In fact, I've even had a few folks comment that they think it would be better to "roll their own" database rather than have to learn how to work in a "general purpose&qu ...

[ 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