I believe we should always have a DB server just for developers to do some fun coding and get understanding of different functionalities. In our development environment we have few...

I think I got confused with the word, " have a table with a PK that is also the clustered index", I translated as i already have clustered index and created...

One more solution. 

create table #ValueTracking
(
ID int
,[2017_01] int
,[2017_02] int
,[2017_03] int
,[2017_04] int
,[2017_05] int
,[2017_06] int
,[2017_07] int
)

insert...

Sample data is actually very clean. Why suggested name change, for clean data it is suggested data which is not clean and for dirty data a clean value is assigned....

You are taking Time component of getdate() in @t, so obvious it will ignore the date part. with this script you'll get the minute difference from midnight only. Elaborate the...

Using pivot in SQL should be your best bet. try using below code, this may be helpful. all unique name for the step need to be added in the query...

Create view and run the below query to get the dependent objects

SELECT DISTINCT referenced_entity_name
FROM sys.dm_sql_referenced_entities('dbo.' + @viewname, 'OBJECT') ref
WHERE referenced_entity_name IS NOT NULL

I have reimbursement for food or travel for some occasion is always an issue (at least most of the companies) it may not be the policy of a company but...

HIPPA is very broad. but Audit and logging of access to data is very important. even if application is showing data as read only, there should be a log what...

I don't think there is a direct way of using 3 part naming convention to execute cross database objects. but you can look into elastic query if that is an...