If it is SQL 2016+ you can enable the QueryStore feature and check the reports it provides.

Hi migurus,

Your t-sql statement works fine on 13.0.5698.0.

May be the index name is allocated to another object in that database?

Drive 1: System drive

Drive 2: Database drive for DB's with a lot of read/writes

Drive 3: Database drive for other DB's and TempDB

Drive 4: Log files

Drive 5: Backups and other...

I haven't seen any SAN with NVMe yet. If someone knows a model with NVMe please share that.

The dates in the question and in the answers do not match 😉

You don't have an option to install 2017 first. Because it won't allow you to install a lower version of SQL Server. The most recent version of shared tools should...

Accordingly with the official Microsoft web site you will need to pass one of these exams in order to get your MCSE: Data Management and Analytics:
Exam 70-473 
Exam...

Good article, thank you.
The conventional migrations were described in my article - http://www.sqlservercentral.com/articles/SQL+Server+2017/172693/ You can use it for comparison.

I have published similar solution sometime ago - http://www.sqlservercentral.com/articles/Database+Mail/166901/

The second parameter is not acceptable - https://docs.microsoft.com/en-us/sql/t-sql/functions/string-split-transact-sql?view=sql-server-2017

Something like this?


select merchantnumber, max(merchantname) merchantname, max(activeflag) activeflag, min(rec_start_date) rec_start_date, max(rec_end_date) rec_end_date
from #datatable
group by merchantnumber


That depend on the version of MS SQL Server.
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-columnstore-index-transact-sql?view=sql-server-2017

I would use something like this:

CREATE