top of page
Which Databases are Active in a SQL Server Instance?
Sometimes I see SQL Server instances with hundreds or even thousands of databases. This is usually a consolidated environment or a...
Madeira Team
Nov 4, 20182 min read
How to Fix a Suspect or Recovery Pending Database in SQL Server?
One of the scariest moments for a DBA is to see a database in the "Suspect" mode or in the "Recovery Pending" mode... First, let's...
Madeira Team
Jul 29, 20187 min read
Why we should enable trace flag 3604 before part of DBCC statements?
In many cases, while we using DBCC commands, we must to run two statements instead of one, in order to receive the wishful result. For...
Madeira Team
Mar 9, 20181 min read
Which One is Better? IN or BETWEEN?
I just had an interesting case of performance tuning: a query with multiple predicates on a very large table. Something like this: SELECT...
Guy Glantser
Mar 9, 20182 min read
Creating AlwaysOn Availability Group With Scripts
One day, your Availability Group cluster can get into a critical state in a way that forces your team to create the Availability Group...
Madeira Team
Mar 9, 20181 min read
Something Cool We Learned Today!
We have many customers, and we work on lots of projects. Each project is different in so many ways: the business environment, the system...
Madeira Team
Mar 8, 20181 min read
What is the CXPACKET Wait Type?
This wait type indicates that parallel plans execute on the server. This wait type doesn’t necessarily means there is a problem. It only...
Madeira Team
Mar 2, 20181 min read
Planning to Increase Cost Threshold for Parallelism – Like a Smart Person!
When administrating a SQL Server instance with multiple CPU cores and heavy workload, it’s common to see SQL Server creating and...
Eitan Blumin
Feb 27, 20183 min read
The king is dead, long live the king!
Everyone, who deal with SQL server, know sample database AdventureWorks, which has been with us since the days of SQL Server 2005. Most...
Madeira Team
Feb 19, 20182 min read
Extremely easy tricks to list table columns’ names and replace SELECT *
Everyone knows the simple T-SQL “SELECT * ” is bad practice. It can: Effects the execution plan (Table / Index Scan); Returns too much...
Madeira Team
Feb 15, 20181 min read
bottom of page