Not having instant file initialization turned on slows down the process of adding pages to your database, because prior to allocating the data pages to your database, SQL Server needs to zero out the newly allocated pages.
2018-01-03
3,515 reads
Jeffrey Yao explains how to generate backups based on the amount of data that has changed for differential and transaction log backups.
2018-01-02
3,457 reads
Erik writes a script to do what it says on the tin.
2018-01-01
4,692 reads
Can you imagine it? You are in a group of smart database people, and they are debating the finer points about AWS DMS, and you don't even know what the letters stand for. You just feel too shy to ask those basic questions that seem ridiculous once you're up to speed. Laerte Junior answers all the questions you need answers for when facing the prospect of getting familiar with Amazon's useful Database Migration Service.
2017-12-29
5,408 reads
There may be times when you need to perform maintenance against a database that requires you to keep normal database users from connecting to your database while the maintenance is being performed. You want to stop users from connecting right away, but you want the database to be in a state that you can perform maintenance.
2017-12-28
5,508 reads
Choosing the right data platform is not an easy task. Warner Chaves compares the capabilities of the big three Database as a Service (DBaaS) offerings, Microsoft’s Cosmos DB, Google’s Cloud Spanner, and Amazon’s DynamoDB, to help you make the right choice for your application.
2017-12-27
3,064 reads
Brent demos a single query plan that asks for 2 identical indexes on the same table.
2017-12-26
3,142 reads
Ameena Lalani looks at cascading updates and deletes when using temporal tables in SQL Server.
2017-12-25
3,228 reads
Tim Radney of SQLskills talks about the various Standard tiers available in Azure SQL Database – what they get you, and how much they cost.
2017-12-22
3,997 reads
SQL Server orphaned users are a common thorny issue in auditing. In this post, Jeffrey Yao provides a few different ways of identifying orphaned users covering various scenarios.
2017-12-21
3,707 reads
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Comments posted to this topic are about the item The Long Name
Comments posted to this topic are about the item Eight Minutes
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?