SQLStudies

Blogs

2 Tips to a Working Schedule

By

When I watched the following video from Justin Sung, I realized that I am...

Teaching at the SC Statewide Audit Conference

By

Instead of teaching the CISA exam prep course, I'm teaching in the IT track....

Upgrading SQL Server in a Container

By

I decided to update software on my laptop recently during a trip. I’m loathe...

Read the latest Blogs

Forums

cant that export task be scripted without ssis

By stan

hi, i'm archiving some dw stuff to tsv's.   i got the manual sequence working...

Dependency Chain

By Phil Parkin

I have not yet been able to come up with a tidy solution for...

is there a reorg available in sql server?

By stan

hi i have a 67 million row fact table that needs about 30 million...

Visit the forum

Question of the Day

Getting the Updated Column List

What happens when I run this code in SQL Server 2022?

UPDATE dbo.CustomerLarge
 SET CustomerContactFirstName = 'Andy'
 WHERE CustomerID = 1

SELECT COLUMNS_UPDATED()

See possible answers