Eitan BluminMar 163 minThe Ultimate Compression Savings Estimation Script for an Entire Databaseדחיסת מידע ב-SQLSERVER יכולה לחסוך שטח ואף לשפר ביצועים. אבל במקרים מסוימים זה יכול לגרום יותר נזק מתועלת, וחשוב לזהות מקרים אלה.
Guy GlantserMar 162 minהאם יש לכם אסטרטגיית גיבויים נכונה?Sometimes I see SQL Server instances with hundreds or even thousands of databases. This is usually a consolidated environment or a hosting environment or a m...
Guy GlantserNov 28, 20196 minHow to Compare Tables in SQL Server?Sometimes you need to compare data between two tables with many rows and columns. There are several ways to achieve this. Here is one...
Guy GlantserNov 5, 20194 minDo You Have a Proper Backup Strategy?Researches show that we are more likely to lose our database in the coming year- Don't let that happen to you! Statistical research shows that there’s a hig...
Eitan BluminNov 5, 20183 minEnhanced Indexes List It is often useful to query the list of all indexes in a database. Such a report can help in tuning the database or in designing a new feature. One way to ac...
Eitan BluminNov 4, 20182 minWhich 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 hosting environment or a m...
Eitan BluminJul 29, 20187 minHow to Fix a Suspect or Recovery Pending Database in SQL Server?One of the most scary moments for a DBA is to see a database in the "Suspect" mode or in the "Recovery Pending" mode... First, let's understand the differenc...
Eitan BluminMar 9, 20181 minWhy 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 example, in order to r...
Eitan BluminMar 9, 20182 minWhich 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 ... FROM dbo.LotsOf...
Eitan BluminMar 9, 20181 minCreating AlwaysOn Availability Group With ScriptsOne day, your Availability Group cluster can get into a critical state in a way that forces your team to create the Availability Group from scratch. The foll...
Eitan BluminMar 8, 20181 minSomething 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 architecture, the da...
Eitan BluminMar 2, 20181 minWhat 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 points to the existe...
Eitan BluminMar 2, 20182 minUse Filtered Statistics to Improve Performance on Very Large TablesLet’s say you have a very large table on a SQL Server 2012 Standard Edition instance. This means: old cardinality estimator and no partitioning. The table ha...
Eitan BluminFeb 27, 20184 minPlanning to Increase Cost Threshold for Parallelism – Like a Smart Person!Planning to Increase Cost Threshold for Parallelism When administrating a SQL Server instance with multiple CPU cores and heavy workload, it’s common to see ...
Eitan BluminFeb 19, 20182 minThe 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 of official SQL Serve...
Eitan BluminFeb 15, 20182 minSCHEMABINDING and Why It Can be Useful?In SQL Server, when we use the “WITH SCHEMABINDING” clause in the definition of an object (view or function), we bind the object to the schema of all the und...
Eitan BluminFeb 15, 20181 minExtremely 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 data: unnecessary extr...
Eitan BluminFeb 4, 20182 minינואר 2018 – קידום אישי ומקצועיבכל אחד ואחת מאיתנו קיים הצורך בלמידה מתמדת. הן בתחומים שיקדמו אותנו בעבודה והן בנושאים אחרים. מקום העבודה, המקום בו אנחנו נמצאים שליש מהיום שלנו לפחות, יכול...
Eitan BluminFeb 1, 20181 minHow to Troubleshoot Waiting Tasks Without Requests in SQL Server?Usually, when I need to troubleshoot currently running requests, I use a combination of sys.dm_exec_requests and sys.dm_os_waiting_tasks. The former retrieve...
Eitan BluminJan 28, 20188 minDoing More with Less – My Productivity GuideHouston, We Have a Problem We are living in a crazy world. And it just gets more and more crazy all the time. The amount of tasks we are confronted with at a...
