SQL Server Identity Values Check
Very few users have any idea how many SQL Server identity values they have remaining on a column.
sql server
HOW TO: Recreate SQL Server Statistics In a Different Environment
Did you know table and index statistics are the most important piece of metadata for your database? The reason for this has to do with how SQL Server (and other database engines) build query execution plans. The query optimizer builds an execution plan based upon the statistical data available at the time. If you have … Read more
101 Things I Wish You Knew About SQL Server
Last week I was visiting the SolarWinds home office in Austin and hanging with my fellow Head Geeks. Our conversations often cover a wide range of topics and at times even turn into teaching lessons for each other. I get to learn about networks, storage, virtualization, monitoring, etc. and I get to teach my fellow Head … Read more
5 Things You Didn’t Know About SQL Agent
Microsoft SQL Server comes with a boatload of additional components. One component is the SQL Agent service. The purpose of the SQL Agent is to serve as a job scheduler. Many experienced DBAs use jobs running inside the SQL Agent to perform routine tasks such as backups, updating statistics, and rebuilding indexes as needed. While the … Read more
Do You Make These 5 Database Design Mistakes? [SLIDESHOW]
A while back I wrote a post on the five database design mistakes you don’t want to make. I always meant to build slides for the post but never seemed to have the time. I finally found a few odd moments here and there over the past few weeks and got a deck uploaded to … Read more
An incompatible SQL Server version was detected
Hope this helps you understand the “An incompatible SQL Server version was detected.” error, and what to do to fix.
