I turned off the firewall and tested connecting from my laptop to the host with "hdcvs-lims-sql\ss2016" and it worked!  That implies sql browser is working and likely that 1434 UDP...

You must create constraints/indexes along with the table right from the start or you will end up fixing data later.

If you have wide rows, you will only get...

It is not really a typing area; it captures the actual hotkeys you press.  First I cleared all the ctrl+r existing hotkey mappings.  Then, I assigned the hotkey to the...

Yes you can assign the old hotkeys to your functions but you may need to un-assign the hotkeys from new functions first:

Yes, some hotkeys and features were removed from the display.  I actually like having the "Show Results Pane" on the toolbar better than the old ctrl+r hotkey.  Add it with...

This all reminds me of co-workers asking what is the part number.  Are they referring to the manufacturer's part number, the supplier's part number, or the one we assign to...

I think your full path should include "Values".
/codeSystem/Values/value

I use VS2015 Pro and a co-worker just confirmed this works in VS2013 also.

Here is the right click to open with:

Here is the Add Program and  Set as...

I don't see a connection between a large tempdb and switching to SIMPLE mode.  Tempdb never shrinks except on restart.

Switching to SIMPLE during a critical time really freaks...

This works if you associate .sql files with ssms in file explorer.

Right-click a .sql file in a TFS solution and select Open with...

Press Add...
The Program...

I never implement weird things so I don't know empirically the performance impact.  Float(53) is eight bytes so it is equal to a bigint data type.  My main concern would...

Do you mean DSN instead of DNS?  I've been burned in the past by redirection.  It is probably ok if everyone is referencing the same redirector.

May I suggest adding a column to your recursive table that stores the root value for each row.  Have a trigger keep the column updated.  All your subsequent queries can...

Maybe something like this.  Generally, I use a function to normalize all date ranges for all reports.


SELECT
    CONVERT(varchar(6),DATEADD(MONTH,-12,GETDATE()),112)+'01',
    CONVERT(varchar(8),DATEADD(day,-DATEPART(DAY,GETDATE()),GETDATE()),112)
;


Does this meet your needs?

DECLARE @t table (vin varchar(10) NOT NULL);
INSERT into @t VALUES ('VO0100005'), ('VO0101553'), ('VO0099300');
SELECT vin, CAST(REPLACE(vin,'VO','') AS int) FROM @t;