You should be able to use convert but you'll probably need to do a little bit of text formatting first since that's not a format SQL Server can read.

You've a ton of subqueries and joins in there, start with one table then add the joins back in one at a time.  That should give you an idea of...

Try doing a varbinary on the column in question and make sure that data is actually what you expect.

No you need to run a log backup then you will be able to shrink it, and if the database is in full or bulk recovery mode you need to...

Well if the issue is sensitive data then maybe going with application level encryption for that data would make more sense.  Then the sys admin in question would be able...

A day dimension is pretty standard in a datawarehouse, yes you could have a time dimension but the use cases would be significantly less especially if you want time dimensions...

Why exactly do you want a time dimension?  And what dimension data are you actually trying to capture that would need to be granular down to the second but is...

That seems like that would be better done at the application layer.

Ug... my hatred of DST knows few bounds, we're not medieval farmers whose schedules are driven by the hours of sunlight in the day.  I used to work for a...

https://www.youtube.com/watch?v=ykxMqtuM6Ko

You can but only if the sub query will only return 1 or no rows.

Hmm... maybe you can do something with this, I'm not an expert on formatting reports in SSRS but in some systems this would work for what you're trying to do...