Category: Experiences

Introducing DataBloat

Introducing DataBloat

So, what is DataBloat? DataBloat is a term that I use to describe issues caused when a table takes up more space than necessary due to the use of inappropriate Data Types. You don’t always notice it straight away… I frequently run the “Disk usage by Top Tables” Report on a Database as it’s useful…

Read More Read More

Virtual Log Files – Too many and you’re gone!

Virtual Log Files – Too many and you’re gone!

We had a situation whereby a Database maintenance job over-ran on a Data Warehouse Server. The overrun was so bad that it was blocking the overnight Data Load process. At the time, there was a separate team that handled general Operations, so I contacted them. They stopped the maintenance job, to no avail. The blocking…

Read More Read More

SQL Server SSPI Errors

SQL Server SSPI Errors

Over the years, I’ve frequently had users complain to me about SQL Server producing variants on the following error: SSPI Handshake failed / Cannot Generate SSPI Context Now, I’m not going to go into depth about the various causes of this error (largely because it’s not really my area and there are far more qualified people…

Read More Read More

Follow on Feedly

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close