Gabriel P (3/11/2009)

---

Hello, I am seeking some clarification on how to calculate index size as I appear to be off in my calculations from what I see in sys.dm_db_index_physical_stats

I'm trying...

I apologize, I didn't clarify. The 40 minutes technically is really just the time it takes to copy the data over to the archive server (purging & archiving was all...

Just an FYI, I just want to let you know the partitioning has been successfully deployed. The 3 hour purge/archive process now takes 40 minutes with Switch Partitioning. Transaction Log...

This doesn't answer your question, but I want to point out you're going a really long way to do something really simple. I'm assuming your function just returns the time...

If you're good with VB.net, you can do this using the Script Component of SSIS.

Actually I don't know why I made it even more difficult. You can account for all previous sortorder records using Count(*) (assuming that they will always start with 1, and...

Chuck Craig (1/30/2009)

---

It's still returning incorrect rows.

I'm getting rows back where empin = 16975

this routeid should not show up in the resultset

RouteUD SortOrder EmpNum ...

GSquared (1/21/2009)

---

The part I added is called a correlated subquery, because part of it (the Where clause) references one of the tables in the outer query.

Does that get you what...

I get http://emzero.com.ar/xml/XML_I_GET.xml which is wrong because it's creating an element per row and I want to create just one element per GalaxyId and nest the Objects inside of it....

Plus during a split/merge there's an exclusive lock on the table, and a schema lock. Not pretty - even if it is done at 1am.

I did some more research and I figured out how the split/merge works although I'm still working on the "why". However, the return on reading this explaination is minimal -...

I figured it out. Well not really, but I figured out a way around it.

For some reason, both partitions have to be empty for it to be an instant O(1)...

Have one scheduled to run for tonight's purge process.

No argument from me - but I mentioned that only because during the sliding window, you need to split partitions in order to create a new empty partition. If there's...

Yes although my situation is a little different since I have the two tables.

Some obstacles I've come across which will save you time if you plan ahead:

Bear in mind...