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,015 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: )

1,005 reads

Blogs

Azure Cloud Chronicles with Microsoft MVPs YouTube Channel

By

In my YouTube subscriptions feed, a new video for the Azure Cloud Chronicles with...

T-SQL Tuesday #188: Growing the Community

By

This month we have a great T-SQL Tuesday, hosted by John Sterrett. He has...

Unveiling the Legacy: POSTGRES to Modern Open-Source Powerhouse

By

PostgreSQL, often referred to as Postgres, is a powerful, open-source object-relational database system that...

Read the latest Blogs

Forums

Report Table/view or SP in SQL to handle various reports

By JP789

I have an Access database with a SQL backend with tables, views, SP's. I...

Each database having its own disk?

By WebTechie

Good morning, Once again, I find myself Sr. DBA for a company.  As I...

the value of the effectiveusername xml for analysis property is not valid

By Bhagat

I'm experiencing odd behaviour when using Analysis Services as a data source in Excel...

Visit the forum

Question of the Day

Independence Day

The film independence day was released in 1996. Which of these queries returns that year is run today?

See possible answers