SQL Server

Article

The tip, Views in SQL Server, explored the purpose of views, creating views examples, and benefits of views. A view is a virtual table that references the actual database tables stored in the database. What if someone changes the underlying table structure, such as renaming the column, adding a new column, or dropping the table? What is the impact of changing schema on views? How can we stop any schema changes if the view references the schema?

2023-05-08

Create an HTML Report on the Status of SQL Server Agent Jobs

by Nisarg Upadhyay

SQLServerCentral

Article

SQL Server jobs are an integral part of any SQL Server environment. These jobs run a predefined set of tasks and commands at specified intervals, ensuring the database is up-to-date and performing optimally. As a database administrator, it is essential to regularly monitor the status of SQL Server jobs. One way to do this is […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (2)

You rated this post out of 5. Change rating

2023-05-03

7,339 reads

Discuss

Use DDL Triggers to Automatically Keep SQL Server Views in Sync

by Additional Articles

MSSQLTips.com

SQL Server

Article

As much as we tell people to use SCHEMABINDING and avoid SELECT *, there is still a wide range of reasons people do not. A well-documented problem with SELECT * in views, specifically, is that the system caches the metadata about the view from the time the view was created, not when the view is queried. If the underlying table later changes, the view doesn't reflect the updated schema without refreshing, altering, or recreating the view. Wouldn't it be great if you could stop worrying about that scenario and have the system automatically keep the metadata in sync?

2023-04-17

What Do We Want to See in SQL Server?

by Steve Jones

SQLServerCentral

SQL Server

Editorial

Microsoft reads your feedback, but doesn't always build it. However, your votes can sway them at times. Today Steve asks what you'd like to see added to SQL Server.