You rule. I have been using stored procedure to truncate and load SQL queries instead of using views to achieve this result. Materialized views sounds like a great way to keep the ETL process cleaner by removing the need to add stored proc calls.
Hello friend, The simplest answer is, Yes, it is possible to create indexes on views that span across linked servers. One way to accomplish this is by looking into distributed partitioned views.
You rule.
I have been using stored procedure to truncate and load SQL queries instead of using views to achieve this result.
Materialized views sounds like a great way to keep the ETL process cleaner by removing the need to add stored proc calls.
Most excellent primer on materialized views on Microsoft SQL Server. Thank you so much!
🤗You're very welcome Alejandro!
Very helpful! Please a create a second part for partitions!
Thank you! I will, stay tuned :)
Thanks for this great video!
You're very welcome!
VERY GOOD ,THANKS !
You're very welcome!
good tips. thanks for the information
You're welcome!
can I create indexes between linked servers?
Hello friend,
The simplest answer is, Yes, it is possible to create indexes on views that span across linked servers. One way to accomplish this is by looking into distributed partitioned views.
i need a backup of this database can you give me this
I failed that question on my last interview u_u