Craig-315134 (7/11/2013)

---

It could be even worse. Two guys in black suits with badges show up at your home when you're alone, or at work and say we need to talk...

When you describe your situation, you're not always being clear and using pronouns which are somewhat ambiguous. We also have no idea if you are talking about in place or...

Stefan Krzywicki (7/10/2013)

---

Starting tomorrow and running through Sunday is Readercon in Burlington, MA just outside Boston. This is a local SF convention that I'm helping run this year. Wow this...

+1 for R10. I'd go 4 files as well to start as that's the latest CSS recommendation.

If you can't go SQL2K12 and need to write your own function/table to track this, make sure it's transactionally controlled to prevent concurrency issues.

+1 more for the Windows upgrade. Go to W2K8 R2 or, preferably, W2K12.

Also, +1 for Johan's note. Backup restore for upgrades.

PIVOT is your solution. There's one way above, but play with the command and see what it can do for you.

Didn't know EditPlus did that, though I use that for lots of stuff.

I have started using GitHub for keeping code sync'd between machines. Like that for now.

I don't know that everyone can, or wants, to learn programming, but I do think there are a wider group of people that can than are doing it now. Some...

I suspect you have memory issues.

Check free memory in Task manager, make sure that it isn't too low. In line with that, here's a related thread: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/b43c3631-b28f-4564-a802-7b737966b457/there-is-insufficient-system-memory-in-resource-pool-internal-to-run-this-query

DBCC MEMORYSTATUS will help...

I think it's what it says. You're memory starved for this operation. Is it a busy instance?

The logins need to be mapped to users in each database, and a role set there.

I think this will help. I can't test right now, but it looks like it reads the files, gets the info from them, and then builds the restore command.

http://www.sqlservercentral.com/scripts/Backup+%2F+Restore/30962/

Looks like notifications are working. Not sure if something broke loose or got fixed.

Are all databases going back to the same pathing? Or to the default paths on the new server?