Monthly Archives: September 2014

Disk allocation unit size

How to determine what allocation unit size was selected when a disk was formatted? If a disk was formatted incorrectly i.e. a SQL Server data volume,  but you want to check what allocation unit size was selected  when the disk … Continue reading

Posted in Performance, Tips | Comments Off on Disk allocation unit size

Linked Server on SQL2014

  If a linked server was created on a SQL2008 instance specifying a provider of SQLNCLI10 (SQL Native Client 10) and the server is upgraded to SQL2012 or SQL2014, any calls using this linked server will fail with the following … Continue reading

Posted in SQL2014 | Comments Off on Linked Server on SQL2014

MDW (Management Data Warehouse) Missing Index

The cleanup job for the MDW (mdw_purge_data) has a step that performs the following query… SELECT qt.sql_handle INTO #tmp_notable_query_text FROM snapshots.notable_query_text as qt WHERE NOT EXISTS (SELECT snapshot_id FROM snapshots.query_stats as qs WHERE qs.sql_handle = qt.sql_handle) and as a result … Continue reading

Posted in MDW | Comments Off on MDW (Management Data Warehouse) Missing Index

Moving from Server Core to Minimal Server Interface

To install Server Graphical Management Tools & Infrastructure on Server Core: Run PowerShell, then run the following command: Install-WindowsFeature Server-Gui-Mgmt-Infra  -Restart A restart is required and this command will restart the computer at the end of the update. If you omit the -Restart, … Continue reading

Posted in SQL on Server Core | Comments Off on Moving from Server Core to Minimal Server Interface

Granting permissions for SQL Server

To operate correctly, SQL Server requires permissions on the file system. In the past, running under local administrator it wasn’t necessary but nowadays we always run the SQL Server services under minimal privileges. This means that SQL needs permissions on … Continue reading

Posted in SQL on Server Core | Comments Off on Granting permissions for SQL Server

Managing SQL Services from command Line

Under Windows Server core, if you can’t control the services remotely, the commands to change the services are as follows: sc config <service_name> start= <mode> auto = automatically started at boot time (automatic) demand = manually start the service (manual) … Continue reading

Posted in SQL on Server Core | Comments Off on Managing SQL Services from command Line