SQL Server Index
Create an index in SQL Server
Create an index in SQL Server to improve the performance of queries on tables and also in clustered views. Two types of index exists, the clustered and the nonclustered one. To create a …
view
SQL Server Views
Create a view with SQL Server
How to create a SQL Server view to display specific columns from an existing table? Consider a view as a virtual table defined by a SQL query. It’s a set of columns and …
SQL Server Views
How to delete a SQL Server view?
How to delete a SQL Server view from the database? How to drop a view? For a SQL developer it’s a good practice to have a clean database and remove the unused or …
SQL Server Views
How to modify a SQL Server view?
How to modify an existing T-SQL view ? To develop a SQL Server database or more generally an application, create a database and tables is mandatory. The views are also very useful because …
SQL Server
Last updated table on SQL Server
How to check the last date a table was updated on a SQL Server database? Check the last access and update with a simple SQL query? Thanks to the SQL Server relational database …
