Good tests. I think tabs was always the big issue.

I 2nd the advice from "sa" above.

Post examples/links in here.

The more examples we can pass to the devs, the better.

There might be some caching going on there. We do have pages that are cached for a few minutes because of load, and I wouldn't be surprised if that's one...

Nice job, Lowell.

Interesting, I'll check. We were experimenting with removing the requirement to log in to read forum posts, but it should take you to the proper page.

There are some different local area ones, but I thought that the worldwide GPS system used WGS-84 because of US satellites. Is it different from the UK?

Since this is THE THREAD, a change was made to allow cut and paste to/from SSMS and the forums.

http://www.sqlservercentral.com/Forums/Topic749309-83-1.aspx

I await the issues.

Well I've seen them compared to prison cells, and often with less space in the cubes!

Get a book, read the items from Microsoft on which you'll be tested, go through Books Online for those topics, and practice.

It's hard work and effort that will get you...

Thanks, and I agree. Doing this stuff on camera is hard. I'm amazed at how often I make mistakes.

The issue with encryption is that many times the DBA can still get to the keys, or add themselves to the group that can access the keys for encryption/decryption.

Or they...

What you'd want to do is extract out the month and date using substring. Then you can cast this as a number, and sort appropriately.

So

Where cast( substring( field, 1,...

There's no way to do this other than logging the data. It doesn't magically exist anywhere in the server.

A server side trace, which you can template out from Profiler, will...

Your format is wrong.

select a

from tableA

inner join Table B

on a.x = b.x

WHERE a.y = 1

The joins come before the WHERE.