When doing bulk data changes it may be beneficial to disable indexes prior to starting the operation. Fortunately, SQL's rich metadata makes this very easy to automate in a robust fashion.
2018-05-18 (first published: 2015-10-19)
4,795 reads
As a developer working with SQL Server, you'll need to work with DBAs at one point or another. Here are some easy ways to make those conversations go smoothly.
2015-04-10 (first published: 2013-09-24)
18,286 reads
In this piece, Josh follows up on his earlier article about smoothing DBA/Developer interactions, this time from the side of the developers.
2014-02-07
8,655 reads
By Steve Jones
Recently I’ve been looking at archiving some data at SQL Saturday. As a start,...
Buckle up, database wranglers! Nowadays, SQL DBAs hold the keys to a company's most...
By DataOnWheels
Picture this, your data ingestion team has created a table that has the sales...
Dears, I was told that I cannot access delta files in SQL Server Managed...
Comments posted to this topic are about the item Crazy Interviews
Comments posted to this topic are about the item The Query Traceflag