How to enable stretch database
After the tip https://www.mssqltips.com/sqlservertip/5526/how-to-setup-and-use-a-sql-server-stretch-database/ I made a video to show step by step how to enable stretch database.
Category: configuration
Moving the msdb, model, and tempdb databases files
All system databases, except the resource database, can be moved to new locations to help balance I/O load. To move
Understanding parallelism on SQL Server
Parallelism refers to multiple processors cooperating to execute a single query at the same time. Parallel execution involves the overhead
There is insufficient system memory in resource pool
Doing crash and recovery tests on my local machine I got the SQL Server instance not going online. After trying
SQL Examiner Tool
I like tools and I’ve used a couple of them. I had the opportunity to try SQL Examiner to compare
10 Configurations Best Practices
The first checklist before start using any application using SQL Server should be the default configurations. What configurations I used
