How to Delete hiberfil.sys on Windows 10

How to Delete hiberfil.sys on Windows 10 Select Search. Enter command. … Right-click Command Prompt and select Run as Administrator. … Select Yes if a User Account Control window appears requesting permission to continue. … Type powercfg.exe /hibernate off into the Command Prompt window and press Enter.

Search of Large Files on Disk Drive

Option 1: Folder Explorer Go to folder explorer and type in … in the search box size:huge Option 2: TreeSize Free app Note on Removing Files: hiberfile.sys ok to delete pagefe.sys should NOT be deleted .ost outlook files should NOT be deleted Although hiberfil. sys is a hidden and protected system file, you can safely... » read more

Upgrade availability group replicas When upgrading a SQL Server instance that hosts an Always On availability group (AG) to a new SQL Server version, to a new SQL Server service pack or cumulative update, or when installing to a new Windows service pack or cumulative update, you can reduce downtime for the primary replica to only a single... » read more

Check Current Windows Version

To find out which version of Windows your device is running, press the Windows logo key  key + R, type winver in the Open box, and then select OK. Select the Start  button > Settings  > System  > About .

Things to Avoid in Your Query

LIKE ‘%xxxxxx%’ Table Valued Functions Functions in from/below Implicit Conversions (convert to different data type) Comparing the contents of 2 columns on 1 table Table Variables Table variable does not have stats and serial for updates.

CTE (Common Table Expression) Specifies a temporary named result set, known as a common table expression (CTE). This is derived from a simple query and defined within the execution scope of a single SELECT, INSERT, UPDATE, DELETE or MERGE statement.  A Common Table Expression, also called as CTE in short form, is a temporary named result set that... » read more

SQL Server Windows Failover Cluster – Unable to start Roles

Status: Windows Failover Cluster fail to start any of the Roles All nodes in the Windows Failover Cluster are up. Identified several important event IDs that are common across all SQL nodes: 1069, 1205, 1254. Probable Causes: -SQL node names and AG name are not resolving or couldn’t register in the network. please look at the... » read more


ONLINE = ON for SQL Server Enterprise / Developer Edition ONLINE = OFF for SQL Server Standard Edition