I'm not sure it's recompiles. I've seen people report poor performance from procs and queries for a period of time.

Nothing makes sense, but it's like the old "reboot" advice....

I'll disagree in that I like the backup to database. It's easy to copy that data back from a restored db to your primary, and you'll easily identify this as...

richardd (2/2/2010)

---

SQL Search is a very nice tool, but unfortunately it's not going to be free for long:

...

Given Red Gate's policy of forcing their "free" tools to expire and requiring...

blandry,

I think most things become a grind at some point. Even the things you love will be work at times. And lots of it is in your attitude. As long...

LOL, Barry, I'd forgotten about your article. That's a great one!

They have to be stored somewhere since you don't need to rebuild stats on a restart of the server. They should be in a backup, and I would agree that...

Partitioning is only for tables, for certain data. Note that backing up a partition, without considering all of the other related data, might not get you something you can use...

A side note, are you allowing tempdb to grow on your instance?

I don't believe this is a SQL Server out of memory, but I could be wrong. I would learn...

Thanks. Up late Sat (Avatar movie), up early Sun (skiing), up late last night helping my 11 yr old...

For my machine, I installed the OS. Didn't see this listed prominently on the Toshiba site when I checked their Win 7 notes.

I had meant to check what was up...

The benefits of 64 bit are that you can access more memory and have larger caches without penalties of swapping data around in memory (with AWE/PAE)

There is no upgrade. Essentially...

Do I? Not moi. I am confident that I do a good job, and am worth hiring. There are lots of jobs for good employees.

Jays lost Halliday, likely to be below .500

I'm not sold on the Orioles. I hear this most years, but I doubt they'll compete with the other 3. The west seems...

I have removed the sample data.

As mentioned, this is entirely too much data. You can show some sample data, maybe 5-10 XML rows and that would be enough. Using real...

Jeff,

Did you get it right?