SQL Server provides a number of global variables, which are very useful.The values of these variables is maintained by the server. All the global variables represent information specific to the server ...

For example, in SQL Server 2014 default constraints are supported, but check constraints are not. Like memory-optimized tables, table variables do not support parallel plans. Like memory-optimized ...