This is a brief post containing a script you can use to delete extra tempdb data files and avoid the “file not empty” (Msg 5042) error. I’ve occasionally ran into …
-
-
In this post I cover a script I’ve put together for measuring storage write speeds in SQL Server, namely against database data files. This is meant to help get an …
-
Today I’ll deviate a bit from my usual SQL Server posts, and address plagiarism while also offering a valuable lesson in why hotlinking images is a terrible idea and a …
-
In this post I cover my solution to Brent Ozar’s recent query exercise, where we needed to optimize a query so that it’s able to find long values fast. Introduction …
- PerformanceSQL Server
How applications cause excessive ASYNC_NETWORK_IO waits in SQL Server
by Vlad DrumeaIn this post I’ll go over what the ASYNC_NETWORK_IO wait type is, when it occurs, and how you can tell if the application is causing it. Lately I’ve had to …
-
This post has nothing to do with SQL Server, I just wanted to document a way to recreate a default shared folder on a QNAP NAS without having to recreate …
-
This post contains a script that I’ve written and used a few times when I’ve needed to search for a string in an entire SQL Server database. You can find …
-
In this post I cover my favorite SSMS tips and tricks that I’ve picked up along the years, and on which I rely on a daily basis in my workflow. …
-
In this post I cover two ways to export and import multiple SQL Server tables to and from CSV in one go with the help of a little PowerShell magic …
- SQL ServerTips And Tricks
Testing SQL Server storage read speeds using the NUL device
by Vlad DrumeaIn this post I’m going over one method that I like to use for testing SQL Server storage read speeds. While there are a few ways to do this, a …