Sorry,

Was reviewing old PM's and came across this link.  Here's a split function that has no loops... the details, as always, are in the comments...

drop FUNCTION dbo.fnTSplit

go

CREATE FUNCTION dbo.fnTSplit

/***************************************************************************************************

 Purpose:

 Split a...

I'm working on fixing that little problem...  I had 84 PM's... when they shifted to the new system, the limit became 50.  I'm working out how to download them (I...

Where are you getting the CDR's from?  Most CDR's include the CallStartTime as both Date and Time.  And, the call duration is almost always listed in seconds.  To get the...

If you treat Excel like any other application, and you should, you'll soon realize that the best way to do this is to write a little VBS to push the...

I'm thinking that Remi thought you were going to move the triggers that did the insert/update on table B to table B... and that's not what you intend...

Of course, I...

Heh... lemme change my stance on this subject ...

I pretty sure there's something built in ... 😀

I, too, like "auto-subscribe".  I'd rather manually "unsubscribe" on something...

Sergiy (9/24/2007)

---

I guess your problem is terrible design.

Can you post DDL for your "many tables" to give us an idea what is it about.

And post one of your triggers. I'm...

Heh... thanks for the compliment, David... but Serqiy is correct... did it work and did it speed things up for you?

Lowell... if you're not talking about the RSS feeds, what are you talking about and how do you do it?  That would be great if I knew how...

I absolutely agree!  Tell the Developers "Thank You"!  This makes life a lot easier for us!

There are two different strategies... one is the system... cache, I/O, memory, load balancing, splitting TempDB for each CPU, etc, etc, ad nausium.

The other is the techniques used in the actual queries...

Ah...  got it... thought you'd stumbled into something cool.  Thanks, Remi.

Yup... I agree... said something similar above.

How do you do that?  That would be most useful to me...