Our Blog
Here are some tips and tricks to make SQL Server run faster

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',...

Data and Log File Performance Using Instant File Initialization
Ever wondered why SQL Server takes long time to perform below operations? Create a database Expand data files for additional growth Automatic data file growth due to auto-grow settings Restoring a database, etc. Today we will be looking into a powerful and yet not...