RAID write times are improved by writing to a cache. This is a quick operation, the calling program can get on with its business, and the RAID controller can solidify the cached changes to disk(s) in its own time. The … Continue reading →
Sample backup compression figures – SQL Server 2012. The relative sizes and timings are interesting. This was a database with data that compressed well. Uncompressed backup file: 73.4GB. 18 minutes to create Compressed backup: 17.5GB. About 20 minutes to create … Continue reading →
SQLPS The SQLPS utility is being replaced by the sqlps module: Import-Module “sqlps” -DisableNameChecking To run this interactively against a remote server, enter a remoting session: Enter-PSSession -ComputerName HOST-NAME -Credential DOMAIN\user Add a User to a SSAS Role This solves … Continue reading →
Can you install tools to export/deploy DacPac files without requiring a Visual Studio installation? Prerequisites. Install following from Microsoft SQL Server 2014 Feature Pack https://www.microsoft.com/en-us/download/details.aspx?id=42295 ENU\x64\SqlDom.msi ENU\x64\SQLSysClrTypes.msi Install Data-Tier Application Framework. (May 2015 version is here: https://www.microsoft.com/en-us/download/details.aspx?id=46898. This took some finding: there was … Continue reading →
Taking a database offline is probably less invasive than a detach-move files-reattach sequence. — Get file name and current location of files. SELECT name AS LogicalFileName, physical_name AS FileLocation, state_desc AS Status FROM sys.master_files WHERE database_id = DB_ID(‘RedgateMonitor’); USE MASTER — Alter … Continue reading →
The answer is: Latin1_General_CI_AS. (the windows collation) This is Microsoft’s recommendation. It’s in article 322112 Comparing SQL Collations to Windows collations. References Collation Hell (Part 1) by Dan Guzman
Continue reading →What is the most efficient, least intrusive, way of getting table row counts (say, for keeping periodic statistics)? Select(*) is accurate. Using index statistics is instant but the statistics could be out of date. dm_db_index_physical_stats Dynamic management view. http://technet.microsoft.com/en-us/library/ms188917.aspx … Continue reading →