Get updates from Articles - SQLServerCentral via email, on your phone or read them on follow.it on your own custom news page.
You can filter the news from Articles - SQLServerCentral that get delivered to you using tags or topics or you can opt for all of them. Unsubscription is also very simple.
See the latest news from Articles - SQLServerCentral below.
Site title: SQLServerCentral – The #1 SQL Server community
Is this your feed? Claim it!
The post SQL DROP COLUMN Without Breaking Code appeared first on SQLServerCentral.
When we first start working with SQL Server, most tables are small enough and we do not think much about their size. But over time, a table can collect millions or even billions of rows. For example, an online shopping application may store every order ever placed, a banking system may retain years of transactions, or a logging system may record thousands of even...
Some systems store several small status values through a single packed integer. For example, a device integration may require tracking operating mode, alert level, and zone information as one status code rather than separate values in different columns. That creates a practical reporting problem. The packed value may be convenient for an integration format, but a report still...
The post SQL Server 2016 end of support: how to choose your upgrade path appeared first on SQLServerCentral.
The post Migrate a VLDB with SQL Server Log Shipping appeared first on SQLServerCentral.