The attribute value in Dimension table are going to change slowly over time and they are not going to be static. For example if we have employees dimension table the location of the employee may change, the contact number can change. In a product table a product can become obsolete and a new product can
Changing Database compatibility level will be required when you upgrade your database from one version to another and you want to use the latest feature for sql version. For details on compatibility check this earlier post. For example lets say when you upgrade a database from sql server 2012 to 2014 the compatibility level
To know what is compatibility Level check this post link. You can view the compatibility of SQL Server Database in two ways. From SSMS. Open SSMS -> Right click on Database -> Click properties -> Click on Options tab. 2. By running below SQL you can get the compatibility level
SQL Server Compatibility level will be used to decide how SQL will use it features. By setting compatibility level will make sure that SQL will follow that particular compatibility level version. It is a database property and will only affects the features for that particular database. For example with SQL 2014 or higher the new
A view is a virtual table. View will not store any data physically. The data is pulled from the underlying base table when you call a view. Advantages of View : 1.It can be used to combine multiple tables and can have required columns for them. Example : Let us consider below three
Below is the error which I was getting today while deploying the SSIS pacakge for a particular SSIS project. “The package failed to load due to error 0xC0011008 “Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be
Query store is a new powerful feature introduced in SQL 2016 which stores the query plan, statistics and query execution for current and past queries. You can enable it from SSMS ( 2016 and above) by clicking on the database and then on properties tab on the left side you can find query store. In
In SQL server to check transaction log file size you can simply run this dbcc sqlperf(“logspace”) . This query will provide you the transaction log usage statistics for all the databases. The other way round is to run this DMV query which will provide you the usage for the selected database. Note,this will provide you
DIFFERENCE BETWEEN TWO DATES BY DATEDIFF_BIG: DATEDIFF_BIG is a new function introduced in SQL Server 2016. We will also see what is the difference between the DATEDIFF and the new DATEDIFF_BIG function. The syntax for DATEDIFF and DATEDIFF_BIG are both similar however DATEDIFF will return a int value and the DATEDIFF_BIG will return a big
Starting from SQL server 2016 we have new String split function which will help to split a string in rows. With earlier version of sql server a developer would have to create his own custom scripts to achieve this task. Syntax : STRING_SPLIT( ‘string’,’separator’). Split string will divide the input string using a separator into
