However, whenever we are exploring the new feature, it is a good idea that we work with the sample database and build our scripts
Question: How to Use a CASE statement in the WHERE Clause? Answer: First of all – CASE is not a statement but rather an expression.
My primary task is to do consultation for SQL Server Performance Tuning. I always use Microsoft provided sample databases for my demonstrations.
Last year, I have written a blog to install sample database WideWorldImporters SQL SERVER 2016 – How to Import New Sample Database WideWorldImporters. Recently, while I was showing demo to a client, they informed that I don’t have a blog about data-warehouse database WideWorldImportersDW. In this blog we would learn about how to install database WideWorldImportersDW.bak
Some emails, indeed triggers blog posts such as the one I received the other day about database samples.
I have been a very loyal user to sample database AdventureWorks for a while, I really liked the overall database. However, as we know SQL Server releases, new features every year and along with the new features there is always need for a new Sample Database which contains all the necessary data and schema to demonstrate new features of the SQL Server. The SQL Server team has recently released a new sample database WideWorldImporters which can be used to demonstrate new features of the SQL Server.
Few days back I wrote blog about SQL Server 2016 Developer Edition free download. If you didn’t get a chance to have a look, here is the link: Download SQL SERVER 2016 Developer Version for FREE. Let us learn about how to install Sample Database WideWorldImports.