SQL Server 2014 In-Memory-OLTP Tables do not support identity columns or foreign keys, so that puts them well outside what I would be willing to accept for a normal application.

They...

The space needed will be about the size of the clustered index and a little more.

You should probably allow enough free space equal to the size of the current table...

Did you physically rename the Windows server and reboot?

The catch is a run-time error handler, but the error you are getting is a parse time error that happens before the query is run.

Are you sure that you really need to update the statistics every day?

What problems do you have is you only do the update statistics once per week?

I have to come down on the side of RDP access for DBAs.

I have seen many cases where there was a problem with the server and the Windows admins claimed...

bugg (12/11/2013)

I have considered this, but it will mean downtime to Enable READ_COMMITTED_SNAPSHOT ON, which unfortunately I cannot do anytime soon.

Also...

Run the transaction log backups more often. Are you running replication?

If you are not doing it already, set them up to run every 15 minutes 24x7. If that...

You can test them with the ISDATE function.

select

a.MyTime,

IsTime = isdate(a.MyTime)

from

(

select MyTime ='8:00'

union all select MyTime = '8:00 am'

union all select MyTime = '8:00 AM'

union all select MyTime = '8:00 A.M'

union...

I think they are most useful for testing.

When I need to test with production data, I restore to a test database from a production backup, and create a snapshot of...

You could use the function on the link below to calculate the distance from work to employee home in a select statement, and just select the top 2 based...

You should verify that each table that has a foreign key has an index on the foreign key column(s). When you do a delete, it will force a table...

DimOrder doesn't look like a dimension table. It looks more like a fact table.

Casting the float to a VARCHAR value is what causes the rounding you are seeing:

select

a.MyFloat,

ToVarchar = convert(varchar(30),a.MyFloat),

ToLtrimRtrim =ltrim(rtrim(a.MyFloat))

from

( Select MyFloat = convert(float,10041.25E00) ) a

Results:

MyFloat ...

It would be easier to know what you are getting at if you post the schema of the tables.