Mission: SQL Homeostasis

Blogs

Top Modern Data Warehouse questions

By

Below are the top 15 questions I am seeing from customers looking to build...

Importance of Testing

By

I’ve always said if you’re running a script for the first time in a...

Current database vs database locks

By

I have a lot of co-workers who use sp_who and sp_who2 to see who’s...

Read the latest Blogs

Forums

Change Character

By Nita Reddy

I need to change Varchar column from 100 to 200 for one of the...

empty table is large

By winston Smith

I have a table used for staging during ETL. It is empty most of...

XP_CMDSHELL Error

By oradbguru

Hello, I have set up and configured xp_cmdshell using a proxy account and I...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers