I'm on the way home, I'll try to set up a test tomorrow. You can see a huge difference in only a few hundred rows. Multi-statement UDF's are just a...

Gail, I can tell you do softer style martial arts because your response is much more a redirect of his energies than mine would have been. Very nice.

riix, try this,...

The thing is, most people on the thread, just about everyone on the thread, that suggested using TSQL cursors was a bad thing didn't say "THOU SHALT NEVER USE A...

You can't do that in 2000.

Go for it. The more knowledge that gets out there, the better.

Thanks.

I've been remiss in my writing just lately (Tom, who I'm supposed to be working with, is going to kick my butt). There will be another OpsMgr article in the...

Lots of cursing. If you run out of good words, let me know. I used to be a sailor.

😉

I can't come up on Saturday, but I can get there early on Sunday. If that fits the agenda, let me know.

That's the old days. Now, most karate tournies, it's...

Here's the bad news, the amount of good information in a single source on writing custom reports in OpsMgr is even less than that for programming against it.

Have fun!

You were running a query that moved 390 gb of data in 15 minutes? That's the estimated data size from the execution plan. Overall, the plan doesn't look too bad....

I don't see anything immediately visible that would prevent you from creating that constraint. Can you post the scripts to recreate the tables? There may be a constraint of some...

Hopefully, you're right. It does seem like this one may have missed a point or two. Something to keep in mind for the next one.

Are you sure it's not being caused by the read committed vs read uncommitted? I don't recommend it's use, because you can get some really bad data, but read uncommitted...

You're trying to uinstall SQL Server while people are connected to it? That might cause a few issues with the uninstall and the people working.

Like Steve says, a bit more...