Sorry, corrected my statement. I meant to say lower charges for current rather than historical data.

Jo Pattyn (9/13/2011)

---

Cons: strain on your internet connection. What if the cloud decides to vaporize...

If so, what is the issue? SQL doesn't care where you have these columns stored. It isn't...

Let's another thread for a debate on that. I'll open one up in this forum.

http://www.sqlservercentral.com/Forums/Topic1174524-373-1.aspx

If this is for queries, then you can do this as well:

select

Fname

. Lname

, DOB

, Age

, City

, Country

from Mytable

If its' for...

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...