Alter table

SQLServerCentral Article

Implementing Reporting Application Enhancements with No Downtime

  • Article

The purpose of this article is to detail steps that would help implement an enhancement to reporting application that uses SQL Server Database (or any other database) in backend without causing downtime to reporting application.

4.25 (4)

You rated this post out of 5. Change rating

2020-04-09

69,003 reads

Technical Article

Create a view to Alter a Table and Add three Columns

  • Script

I am teaching a database class at Queens College. The project entails the truncation of all of the data and loading new data into the  existing database "BIClass" from a single of the flattened data. One of the tasks of the project was to add these three additional columns to each of the tables (AlterTableAddColumnsUserAuthorizationKeyAndTwoTimeStamps): […]

3 (3)

You rated this post out of 5. Change rating

2019-11-18 (first published: )

981 reads

Blogs

Updating dbatools–Fixing the Certificate Failure

By

I was trying to update my dbatools install to test something and go this...

Classifications and sensitivity labels in Microsoft Purview

By

I see a lot of confusion on how classifications and sensitivity labels work in...

PASS Data Community Summit: A Personal Journey

By

As someone attending the event since 2011, I would like to share my personal...

Read the latest Blogs

Forums

AWS RDS MSSQL

By shambhumahto

Since AWS RDS MSSQL does not support logon trigger, is there any alternative way...

How to get a distinct value from my data set

By skaggs.andrew

Hi, I need help with writing a script that will allow me to pull...

How To Approach Adding A primary Key To An Existing Table

By YSLGuru

In our vendor created/managed DB we have a table that is like an audit...

Visit the forum

Question of the Day

SQL Server on Linux Restrictions

Which of these features are not available on SQL Server on Linux? (choose 2)

See possible answers