This is just going to be a quick post but I was asked the question the other day, how can I find all the tables in the database that don't have a clustered index? Tables without clustered indexes, known as heaps can give you quite a few different performance problems for various reasons. I don't... Continue Reading →
SQL Server has given us the option to backup our databases directly to Azure BLOB storage for a while now but it's not something that I've had all that much call to use until recently. So this is just going to be a quick walk through on how you can backup your on premise SQL... Continue Reading →
This month's T-SQL Tuesday invitation is from Ken Fisher and he's asking about non-SQL tips and tricks. This had me thinking for a bit and then something popped into my head, an accidental discovery that I made the other day. I apologise if this is common knowledge among the PoSH guys but it was a... Continue Reading →
Undercover Catalogue Update 0.4.3 An update to the tables module, Row count and size infotmation added Fix - LocalInterrogation There was an issue with the LocalInterrogation stored proc not updating the execution log, this has now been fixed. Undercover Inspector Updates we forgot to mention from May (V2.2): Added EmailGroup column to ReportData table #216Added... Continue Reading →
It looks like we had a bug the in the SQL script in Move All Your SQL Database and Log Files in Bulk. No worries though, it's all been fixed now 🙂
As always, the script from this post can also be found on our GitHub repo, HERE You've got a SQL Server with a few hundred databases on it (to be honest it doesn't even need to be quite that many) and you need to move all the data and log files to a new location.... Continue Reading →
This month's T-SQL Tuesday invitation comes from Tracy Boggiano and she's asking us to write about our experiences with Query Store. I thought about what I should write, I'm a big fan of query store and I've used it to help me out on a number of occasions recently. I could write about one of... Continue Reading →
I decided to write this off the back of a conversation I was having the other day around the SOS_SCHEDULER_YIELD wait type. The conversation went something along the lines of "but David, I'm seeing SOS_SCHEDULER_YIELD, we must have CPU issues". Yes this particular customer had been CPU bound recently but was that really their problem... Continue Reading →
Adrian has a look at the performance benefits of instant file initialisation https://www.youtube.com/watch?v=b6NE-ipzLbQ&feature=youtu.be Below is Ade's auto growth script... DECLARE @trcfilename VARCHAR(1000) ; SELECT @trcfilename = path FROM sys.traces WHERE is_default = 1 SELECT StartTime , DB_NAME(DatabaseID) AS DatabaseName , FileName, SUM(( IntegerData * 8 ) / 1024) AS [Growth (MB)] , ( Duration /... Continue Reading →
Quick video showing you how to install and configure the SQL Undercover Catalogue https://www.youtube.com/watch?v=SJ5YlTGkV5o
SQL Undercover 