You can right click in the upper left cell of the headers in results and select "select all" and then "save as". You'll get a CSV loadable into Excel.

I like Flo's approach better since it allows you to better error handle things and I think dynamic SQL is harder to read for anyone else following in your work.

I am with Gail. A backup of the system, and SQL binaries, assumes that those are static. But those binaries get information from the system database in order to start....

Does this historic data change?

If not, you can do this and put it in a separate filegroup. That potentially allows you to recover the primary production data quickly and restore...

Go Rays!!

You are welcome. As soon as I started working in environments with other DBAs / developers, we made that switch since code would be formatted differently on different machines.

New building looking good for the horses:

We talked about it, and since we are also giving out shirts (and maybe books) as people walk in the door, we decided that having two types of tickets would...

I think there's a risk issue. Financial information has lots of liability stops. Report your CC stolen, limited to $50. Similar limits on some other accounts, plus insurance is available....

Don't use tabs. No one can count on consistent tabs spaces, so if you expect 3 or 4 spaces, and it's different, the code is mangled.

You should always set editors...

Tobar (9/13/2011)

---

Perhaps, but I write about what I think is cool. I...

Jeff Moden (9/13/2011)

---

I have to ask... where do students get the money to travel from Australia to Europe, spend a couple of weeks doing whatever they want, and then travel...

grumble, grumble

#$%$^#$%$# Steelers

Grant Fritchey (9/12/2011)

---

Chad Crawford (9/12/2011)

---

Woohoo. Attended my first SQL Saturday and spoke there as well. Was as nervous as <fill in your favorite joke here>, since the...

Chad, I'll work on something. It gets a little hard to handle prizes, which is the main thing we charge the tickets for. The casino is covered by SQLServerCentral, but...