I get a Porsche magazine and I read about the RUF last month, and then another editorial this month that complained about it.

I wouldn't mind electric, I just want my...

Wow, once again things have gone sideways on my quite a bit.

The global warming debate inspired this, precisely because there is a debate. It got me thinking that we perhaps...

I thought when I talked with someone on the SQLCAT team last year they mentioned they'd worked with someone that had 120TB or 150TB in a warehouse. lost of challenges...

They're for some developers. I know plenty of developers that have done well sharing space with 1, 2, or more others in an open environment. I've had developers that wanted...

I hadn't looked at it that much, but one index per table. Makes you think CE is more of a small local data store for lookups than a real database.

Pick...

So you see what you expect in Profiler, but no changes in SQL? Open transaction? Explicit transactions set?

That is great. I'll see if I can figure out who did make the case for this one.

If there's not SQL, I hint ("think union" or "try MAX()") and then ask them to show work. I love helping, but I hate being an unknowing contractor for someone.

I agree. We standardized a lot of stuff at JD Edwards, but when Oracle came in, they let things go wilder, almost chaotic, but it did result in interesting security...

I didn't show it, but there are over a dozen conference rooms, ranging from small (10x10 or similar size) to larger, 50-80 person rooms. You could schedule time in there...

max length of openquery strings is 8k

http://msdn.microsoft.com/en-us/library/ms188427.aspx

I agree with Greg. Try to avoid dynamic sql.

you can switch compatibility mode back and forth. It doesn't change the structures or data, it just changes how things are interpreted.

On an import, I'm not sure. You'd have to know the sheet, or write ActiveX to connect to the Excel and read the list of tables. You might check here:...

I'll try to remember to post an announcement the week after.