SQL Server Developer Edition Free Download

SQL Server Developer Edition Free Download

Get a copy of SQL Server 2017 Developer Edition SQL Server developer edition is now free! Finally, Microsoft has made it easy for companies to develop and test SQL Server 2017 by making the developer edition of SQL Server completely free. This is certainly helpful for...
SP_What is smarter than SP_Who2

SP_What is smarter than SP_Who2

SP_What is smarter than SP_Who2! We’ve seen many DBAs scratch their head to find out who is running what in SQL Server. When a user complains about the database performance issue, the first thing DBAs do is run SP_Who or SP_Who2 to see what may be happening in SQL...
SQL Agent Job Failure Permanent Fix

SQL Agent Job Failure Permanent Fix

SQL Agent Job Repeat Failures SQL Agent job failure can be easy to fix but the problem many production DBA’s encounter is the repeat failures of SQL agent job failures. Identifying that there’s a problem would be your first step to fix the problem...
Optimize for Ad Hoc Workload in SQL Server

Optimize for Ad Hoc Workload in SQL Server

When a query is executed, it compiles and generates an execution plan and stores it in the plan cache. If this is a one time query that will never be run again, then the newly generated plan and space in plan cache are wasted. This means the buffer pool now contains a...
How to rebuild indexes in SQL Server

How to rebuild indexes in SQL Server

We get many requests to help with performance issues. we strongly recommend users to sign up: SELECT sqlschema.name AS 'SchemaName', object_name(sqlfrag.object_id) AS 'TableName', sqlindexes.name AS 'IndexName', sqlfrag.alloc_unit_type_desc AS 'AllocUnitType',...