On several occasions, I have seen new SQL Server features implemented with little thought as to the impact of the feature. I will discus the use of Filtered indexes to illustrate this point. Filtered indexes were introduced in SQL Server 2005. They allow a developer with a good understanding of the data and the application … Continue reading
This post describes errors in a SQL instance after changing the windows account running SQL Server. Environment – a Windows 2008 server running two SQL Server 2008 R2, SP2.instances. One instance is the default instance, the other a named instance. Using SQL Server Configuration Manager, I changed the SQL Server service account for both the … Continue reading
Running a CLR routine on a SQL Server 2005 32-bit instance, I encountered regular failures with the following error: Executing the query “EXEC dbo.up_myprocess ?,?” failed with the following error: “.NET Framework execution was aborted by escalation policy because of out of memory….”. This article describes the steps that I took to control the error. … Continue reading
After disk maintenance, the msdb became corrupt. This was on a SQL Server 2005 (Standard Ed) build. All backups were made with Red Gate SQL Backup. Following the standard approach did not work. The database was restored using a work around. Under normal conditions, it is possible to restore Red Gate database backups using theĀ … Continue reading
The process of restoring a SQL database with Red Gate SQL Backup is usually straightforward. Open the interface, select the database and restore. The interface allows restored to a point in time, but there is no option to restore to a named mark in the log. To restore a database to a named log mark, … Continue reading
Microsoft introduced sequences in SQL Server 2012. These have existed for some time in ORACLE. SQL Servers sequences have some similarities to identity columns. They present a number of opportunities for the developer and DBA. In particular, Microsoft claim performance and manageability improvements. I will examine several aspects of sequences, including performance, re-cycling and the … Continue reading