When working with large data volumes, doing normal day to day maintenance becomes a more difficult issue, in a previous post (https://swyssql.wordpress.com/2015/08/06/dbcc-how-to-check-the-uncheckable-dbcc-on-vldb/) I talked about how to handle DBCC CheckDB on a multi-terabyte database. Today I will tackle another issue I came across while dealing with multi-terabyte databases, Index Maintenance. Like most of you my…
On the all new SQL Server 2016 we now have a feature which reminds me of the movie Inception with Leo DiCaprio & Tom Hardy. There you had the dreams in dreams in dreams, for the availability groups we now have AG in AG. This makes the Distributed Availbility groups a dream come true for…
Whenever I go to a burger restaurant & I want to order myself a nice and tasty burger. The first thing I do is look at the menu and ask myself the question: “Where is the bacon?”. I did the same thing while looking at the menu of the new up and coming SQL Server…
Today I’ll be handling an issue I had with the migration of a SQL Server 2000 database to SQL Server 2012. About a week ago we migrated the database from the old and grumpy, and more importantly unsupported windows server 2003 and SQL Server 2005 instance. All was well, and we had no instant issues…
In the previous part of the SQL Server Misconfiguration Chronicles we handled the default instance memory configuration (https://swyssql.wordpress.com/2015/12/17/the-sql-server-misconfiguration-chronicles-part-2-instance-memory-settings/) In the third part of the misconfiguration we will handle the database files. If you create a database SQL Server will look at your model database and create the file structure as specified in your model database….
In the first part of the SQL Server Misconfiguration Chronicles we handled the database level issue of AutoClose & AutoShrink (https://swyssql.wordpress.com/2015/12/08/the-sql-server-misconfiguration-chronicles-part-1-database-autoclose-autoshrink/) The second part of the misconfiguration chronicles will handle the default memory settings of a freshly installed SQL Server instance. SQL Server by default configures the instance memory settings to take a maximum memory…
In the SQL Server Consulting world you see a lot of different environments, but mostly you see the same basic misconfigurations for their SQL Server Enviroment. The following blogposts will show you the most common issues with the configuration of SQL Server, they will tell you what the issue is, why it is a bad…
Close to the 30th of October we find that some SQL Servers start acting spooky, as if they want to add to the sentiment of Halloween. This week I had one SQL Server doing exactly that. The server was running without any problems for the past months but today his TempdDB was starting to fill…
Today I came across an issue I was having with my CMS. On my CMS server I have a database which has a few tables with some detail about my server state (Memory/Diskspace/…). I wrote a few stored procs to gather this data with openrowset in combination with the serverlist that I get from the…
There comes a time in every SQL Server dba’s life when he will have to consolidate a MS Access database to a SQL server, it is inevitable and destiny decided that it was my time today.An overly used Access database which had almost grown beyond its capacity was the one who decided my fate today,…
