The DB World

Project Management and Advocacy

I’ve observed few similarities between the Project Managers and Advocates. Being Project Manager, law bachelor and little practical experienced as an Advocate, I noticed few similarities. I think it’s...

2019-11-04

Blogs

Azure Storage tips

By

As a followup to my blog post Azure Data Lake Store Gen2 is GA,...

Managing Agent Jobs on Availability Group Servers

By

As always, the scripts in this post can also be found on our Git...

Permissions required for row counts to show up on Object Explorer Details

By

I ran into a rather obscure permissions problem the other day. Since I wasn’t...

Read the latest Blogs

Forums

Backup Strategy For distributed availability groups

By juniorDBA13

What is the recommendations for backups in distributed availability groups? I have AG setup...

What happens when I drop a huge table with LOBs? will the space be reused?

By NJ-DBA

Thanks in advance for your help. I have a 5TB database with mutliple filegroups. ...

Surprised that Row_Number() has better performance than IDENTITY

By souLTower

I was doing some testing to see if it's more efficient to use an...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers