Scenario One of the common conversations I’ve come across in a typical work day is as below Emp X: I just found that the IDENTITY column values for couple of tables have jumped to a new rangeEmp Y: Can you…
SQL 2017 Tips: Creating Table On The Fly Onto A Specific FileGroup
Introduction One of the frequently used and the most popular features in SQLServer is the ability to create a table on the fly based on a query. This has saved my day on numerous occasions. Only thing I was missing…