Thank you for voting

We grab the top 50 according to some crazy forumula. Might be too much activity in the other forums.

OK, back online for awhile. So here goes.

It was probably a bad question to put out there, but it certainly got people thinking? My apologies for the poor wording.

There is...

That's true some of the time, but many people, including myself, still have work responsibilities that cannot easily be put off to anyone else.

John,

We're still sending them to you. It must be a filter somewhere that's stopped it.

Nothing has changed other than the domain name. Even the old one still works.

STeve

Carolyn,

That's interesting. I've only had a few datbases over 200GB, but I've never seen this issue, even on W2K. It seems like a file handle thing, which could be an...

It's actually a weird issue in the forum code. There's a mem leak somehwere, so we were restarting the app pool every hour. I backed that down to 4 times...

Bulk load the data into some staging table and then move it over a few rows at a time.

the other thing is to examine the triggers and ensure you're not...

select @projectcode = @projectcode + '0001'

In the second example you are directly returning @projectcode+'001' and having the output column named ProjectCode, not assigning the variable.

Or set a performance alert on this counter.

Interesting thread and I'd love to get a writeup from any of you to share with everyone on how the rollout goes (or has gone for any of you) and...

Interesting points and thanks for the comments.

I know most of us live in the world of < 1TB databases and actually it's prob < 100GB for the vast majority. A...

No separate windows in SSMS. It's a pane (and pain) in SSMS only for queries.

You can still connect with QA, but the object browser only partially works.

You can also rename the northwind and pubs dbs and let them come up suspect to get SQL to start.

The update has to apply to specific rows. You are using a where exists() clause, which returns a true or false, not a set of rows.

What you need to do...