Blog Archives

Instant File Initialization (IFI)

One way to improve performance on SQL Server is with IFI or Instant File Initialization. Normally files are zeroed out on a database growth during an AUTOGROW, RESTORE, CREATE DATABASE or ALTER DATABASE. This is done by SQL Server when

Posted in Performance, Performance Tuning Tagged with: , , , , , , ,

CTE to Split a String in a function SplitString

Back in 2012 when I was writing my Common Table Expressions book, I came up with the following CTE in a function to split a string into rows. Original Post: http://stevestedman.com/2012/04/using-a-cte-to-split-a-string-into-rows/ At the time, I thought it was pretty handy

Posted in CTE Book Tagged with: , , , , , , ,

SQL Server – Cost Threshold For Parallelism

The check for Cost Threshold for Parallelism check has be added to the Database Health MonitorQuick Scan Report. The Cost Threshold For Parallelism setting in SQL Server controls the level at which the query optimizer decides to have a query

Posted in Database Health Tagged with: , , , ,

SQL Server MAX DEGREE OF PARALLELISM

The check for MAX DEGREE OF PARALLELISM has be added to the Database Health MonitorQuick Scan Report. The max degree of parallelism setting in SQL Server is used to control the maximum number parallel threads available to process your

Posted in Database Health Tagged with: , , , , ,

Beta release 1.2 of SchemaDrift – the database schema comparison tool

Today I released another beta release of SchemaDrift. Part of this release was some redesign of the main screen, as shown here. I had some great help from some of the beta testers, and there have been many bugs fixed and

Posted in SchemaDrift Tagged with: , , ,

Optimize for Ad Hoc Workloads

The Optimize for Ad Hoc Workloads server configuration can improve performance, and is extremely unlikely to negatively impact performance. This was a new feature that was introduced in SQL Server 2008, and as with many new features in SQL Server,

Posted in SQL Server Tagged with: , , , , ,

SQL Server – Dedicated Admin Connection (remote DAC)

In SQL Server there is a special connection that can be used to connect to the database, the remote Dedicated Admin Connection or (DAC). This is a special connection that allows the administrator to connect to the SQL Server even

Posted in DBA Tagged with: , , , , , ,

What is a Page Split

Tables, and indexes are organized in SQL Server into 8K chunks called pages. If you have rows that are 100 bytes each, you can fit about 80 of those rows into a given page. If you update one of those

Posted in Performance, Performance Tuning Tagged with: , , , , , , ,

Database Corruption Challenge Week 7 – Alternate Solution

The alternate solution to the Database Corruption Challenge this week was created by Patrick Flynn. This solution is the only solution to successfully recover all the data without using any of the backups. If the challenge had been structured differently

Posted in Corruption Tagged with: , , , , , , ,

SQL Server Performance Tuning

Need help with SQL Server Performance Tuning, contact Steve at Stedman Solutions, LLC for help, or take a look at the performance tuning page at the SteveStedman.com blog. We can help with tuning a single query or with figuring out why your SQL Server is running slow. Free 30 minute consultation.

Newsletter Signup

Stay informed of Database Corruption Challenge events, and other things happening at SteveStedman.com with my newsletter.
Newsletter signup form.

Stedman Solutions

StedmanSolutionsRemoteSkilledDBA

Archives