Reporting

Blogs

Current database vs database locks

By

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

Last Week Reading (2019-07-21)

By

Another week passed. Look what did I find during that time. Press British Airways...

The Data platform has evolved – so too must the DBA.

By

This blog post is around the changing landscape of both SQL Server and the...

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