Corrected how?

You're still showing two invalid answers - CAST(SELECT '20161015 08:15 -4:25' as DATETIMEOFFSET) and SELECT '20161015 08:15 2:00'.

The solution is also confusing - the "correct answer" is option 2,...

SQL-DBA-01 (3/18/2015)

Sorry, if I am confused, but the below link says:

"https://technet.microsoft.com/en-us/library/bb895334(v=sql.110).aspx"

SQL Server Express supports FILESTREAM. The 10-GB database size limit does not include the FILESTREAM data container.

So I selected...

The fact that it's almost identical to the question posted on 15th May helps! 🙂

http://www.sqlservercentral.com/questions/SQL+Server+2014/108889/[/url]

The date on that question...

I'm just hoping that, after last month's .NET updates broke SharePoint, they don't reintroduce the problem this month. It took them three weeks to release a patch for a single...

Your query using the CHECKSUM index is incorrect:

SELECT *

WHERE PostalCheckSum = CHECKSUM(@PostalArea, @PostalCity, @PostalState);

As previously mentioned, the value returned from CHECKSUM will not be unique for the...

I'm still waiting for an explanation of why hundreds of perfectly valid bug reports were recently deleted. Even if they were closed as "won't fix", it was useful to know...

Also:

http://msdn.microsoft.com/en-us/library/ms175010.aspx

A perfect example of how not to write comments! 😛

Nice - a potential SQL injection vulnerability right inside your database! 😛

No wonder they've got so many LoC if they restrict the length of...

Another point to consider - what if the company hosting your data goes bankrupt? The receivers will likely turn off the servers abruptly, without giving you any time to extract...

Slight nit-picking issue: what is a "courser" lock? Do you mean a coarser lock?

http://dictionary.reference.com/browse/Courser

http://dictionary.reference.com/browse/Coarser

You could also use single-user mode from the command-line, even if BUILTIN\Administrators is not in the sysadmin role:

http://dba.stackexchange.com/a/11302

One small issue - there is no "C#.NET"; it's just called "C#".

VB gained the ".NET" suffix to differentiate it from the pre-.NET versions, but C# was created at the same...

So a man who runs a company which sells a competitor to "oldSQL" products has given an interview saying the "oldSQL" is bad, and his "newSQL" competitor is doubleplusgood?

OK, I'll...