What is a Materialized View and Why Should you Use It?
As data volumes continue to increase, more developers look towards materialized views to process...
MySQL Create View, Replace View and Drop View Statements with Examples
An SQL view is a virtual table or a result-set generated by the SELECT query. Unlike physical tables, views do not store data in a...
Top 3 Tips You Need to Know to Write Faster SQL Views
Friend or foe? SQL Server views have been a subject of heated debates when I was in my first year using SQL Server. They said it was bad...
Views in SQL Server
Introduction A view in SQL Server is a virtual table-like structure based on the result-set of an...
Main Usage of sys.dm_os_wait_stats
As you know, the main responsibility of the database administrator lies in the monitoring of the SQL Server performance and intervening in...
SQL Server TempDB Monitoring by Using Dynamic Management Views (DMV)
What is TempDB in MS SQL Server? TempDB is a system database in Microsoft SQL Server used as a store of internal objects, row versions,...
