My favorite place I have worked was a small online retailer which had roughly 80 total employees and an IT department of 4.  On my last day I set up...

I've been a DBA 10 years at 4 different companies now and they all have purchased the extended support (usually via SA), effectively giving the product a 10 year shelf...

lol, funny one @jeff Moden

I just switched jobs a couple months ago.  I went from one of the big fortune 500 companies to a smaller manufacturer.  The move was 100% about culture.  I really...

Ran my test in 2008 R2:

Are you sure that's right?  In the page the answer links to, I see this:

As others have pointed out, this documentation also contradicts your answer:
https://docs.microsoft.com/en-us/sql/relational-databases/in-memory-oltp/implementing-identity-in-a-memory-optimized-table?view=sql-server-2017

Thank you

With great power comes great responsibility.  While having a computer in our pockets is ultra-convenient, it's also quite addictive, to the point that many people use it to escape reality. ...

Coming from SQL Server, I got very frustrated by the Oracle community when trying to start administering one of those databases.  I couldn't understand why their community was so much...

I got my undergrad in math and have found about half of it very helpful in my professional career.  Discrete math is particularly helpful when working in SQL.  I am...

I find it interesting that Microsoft docs say Column Sets start with SQL Server 2016, yet the ColumnProperty function works for IsColumnSet even back in SQL 2008 R2.

The other thing I'd like to point out, having graduated from college just 10 short year ago, is that, at least here in the US, our university system is quite...