Azure BLOB Storage

Technical Article

RE: Moving DTS packages from box to box

  • Reply

HiI plan to have the production SQL DB and the development SQL DB. The idea is to make any new development on the development machine and once tested and approved move it to the production SQL DB. Although the structure and all DTS will be identical (that is before changing something on the development SQL) the […]

2004-08-25

Technical Article

RE: How to Handle "Wide" Tables?...

  • Reply

Assuming that (i) the average length of the data within the two wide fields are relatively large (ie occupying most of the 4000 varchar field and is a common occurrence for that table), and (ii) there are many records, then it would be wise to create a separate table for the two columns and join back to […]

2004-08-18

Blogs

Daily Coping 29 Nov 2022

By

Today’s coping tip is to make a meal using a recipe or ingredient you’ve...

My adventures with speaking and what changed

By

I am writing this blog post as contribution to #NewStarNovember and what got me...

Automatically Take Missed Backups with Ola Hallengren’s Scripts

By

I blogged a few years ago about my configuration tables for Ola Hallengren’s maintenance...

Read the latest Blogs

Forums

Basic Checks on a New AWS RDS SQL Server

By Br. Kenneth Igiri

Comments posted to this topic are about the item Basic Checks on a New...

Assigning a Server Role

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Assigning a Server Role

Cloud First Software

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Cloud First Software

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers