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.

Wow, I go to bed and the thread goes wild 🙂

SSIS is used to move data from many servers, fairly often, in the new Data collector in 2008, so it...

I don't think the furniture arrangement offers up a lot, but it does add something.

There was a lot of thought given to making things look good, more than a few...

Or SQL Server Steve?

Not sure either. Worse case I'll bug Lynn next week when I'm in the SPrings.