Use

select field1 + ' ' + field2

Sorry, it's low priority when compared with other things. It's rarely reported and I answer questions almost daily and rarely see it as well.

Ah, perhaps that wasn't a great picture. I thought it was funny. It came from a SQL Saturday presentation by Kevin Kline.

Doh! Fixed

I leave for a few days and this thread starts to sound like SQL-Seuss

Might read this and see if it helps: http://www.sommarskog.se/query-plan-mysteries.html

There is no implication in the question, at least not from what I read, that RG was enabled and disabled. It is "disabled" for non-internal groups by default, and doesn't...

There is no trick. When we specify drives, you should assume physical drives. The same applies on the Microsoft exams. There is no intention to trick you or come up...

Dizzy Desi (3/2/2011)

---

What about when management forces or tries to force you to do something that you know is wrong? Such as giving them data that's private, but they...

The questions has been corrected (again, sorry) to note that 2 answers are required. The standard MS tests tell you how many answers you need to select, and I...

BrendaD (2/28/2011)

---

Really? Do you not find that a tad offensive?

Who is the audience for such comments? Or more importantly, who are you trying to exclude?

Just wondering...

I don't think...

If you have new hardware, you will install the new software on it, then move logins

Login migration: http://www.sqlservercentral.com/articles/934/

Move over databases from either a backup/restore or detach/attach, then script out alerts/operators/jobs...

Yes, it's a bug in the system when two people are posting at similar times. Low priority, but it's on our list.

You haven't asked a question. You made three statements.

You can install SQL Server on one, and the client tools on the other machine and have them work. You will have...