There's nothing right or wrong about aliasing. It's preference.

I try to use them often, because I find many queries quickly get complex and it's much harder for me to read:

select...

habit

you should never expect any of our questions...

Arrggg, wrong box checked.

10 is correct. I'll award back points tomorrow.

You are NOT going to win. change your avatar now, get one where I'm not smiling.

Eirikur Eiriksson (9/23/2014)

---

jcrawf02 (9/23/2014)

---

any folks have any favorites other than w3schools.org or stackoverflow for getting newbies started on web design? This is someone who has zero experience, so I made...

You'd have to write code that builds this string and passes it in. I'm not sure how you're calling this, but you'd need a wrapper that queries your databases, builds...

Dan Guzman-481633 (9/23/2014)

---

How much did the choppy video and connection errors really cost Apple in terms of lost revenue or reputation? Testing their CDN performance using a world-wide...

That may be true. It hasn't been documented AFAIK or disclosed by MS, but perhaps it is SHA2_512. That...

GilaMonster (9/23/2014)

---

That job runs every hour, so if...

Noooooooooooooooooooooooooooooooooooooooooooooooooooooooooo

Blue Mancunian (9/22/2014)

---

Thanks, Steve.

But do you agree "if extra databases/load been put on to a SQL Server, the existing database performance will certainly more or less be affected."?

Will TempDB...

This isn't disclosed as it would be a security issue for the platform if someone were to be able to duplicate this.

I usually answer that ultimately it's a guess, and we might need to experiment because it's hard to measure workload. I can get avg CPU needs, space needs, memory footprint,...

Biml

http://www.sqlservercentral.com/stairway/100550/