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

68,995 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: )

956 reads

Blogs

Get Configuration Change History From the SQL Server Error Logs

By

Get Configuration Change History From the SQL Server Error Logs There...

A Study in SQL Server Ad hoc Query Plans

By

A Study in SQL Server Ad hoc Query Plans ...

Read the latest Blogs

Forums

Managing some particular dimensions in a data warehouse based on medical records

By pmscorca

Hi, I need to design a data warehouse solution to manage medical records about...

Gentlest of Reminders, Don't Stop Learning

By Grant Fritchey

Comments posted to this topic are about the item Gentlest of Reminders, Don't Stop...

table with varcahar(max)

By sqlguy80

Gurus, there is a table which is very slow to query , it has...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers