My Humble SQL Tips

I'm keeping this blog as a repository for SQL tips and tricks I have learned over my time working with SQL Server.

Thursday, 15 March 2018

Querying the Execution Plan for Subtree Cost - Take 2

›
A few weeks ago I shared a query for probing the execution plan for the Estimated Subtree Cost value . That query was rather simple but ...
1 comment:
Friday, 19 January 2018

Querying the Execution Plan XML for Subtree Cost

›
There are quite a lot of great tools and queries available to the DBA that aid in troubleshooting and performance tuning. The list is incred...
Tuesday, 2 January 2018

SQL 2016 Database Scoped Configuration: MAXDOP

›
SQL Server 2016 Microsoft expanded the range and flexibility of database level configuration settings . There are some new features, as well...
2 comments:
Monday, 18 September 2017

Master Data Services Model Cloning

›
Yes! My company uses Master Data Services or MDS. Yes! It's a pain. And yes! I needed to learn how to use and administer it. For anyone ...
1 comment:
Friday, 4 August 2017

Check for SQL Server Connectivity

›
My company is revamping its domain structure and tightening up network security. I am one of the guinea pigs and therefore have been put int...
Friday, 28 July 2017

Cleanup SQL Server Logins

›
Cleaning up after someone leaves. We all do it right? Our companies all have water tight policies and procedures to handle that, or maybe th...
3 comments:
Friday, 5 May 2017

Compress your database tables

›
SQL Server has offered data compression since SQL 2008. It is a very good feature but, as with almost everything SQL Server, it needs to be ...
Friday, 2 September 2016

Query To Find SQL Audit Details

›
I've been deploying a SQL Server auditing solution for our new SQL 2014 estate. I know, we're a few years behind. But if you saw som...
2 comments:
Monday, 1 February 2016

Restarting a service with PowerShell

›
We use Redgate's SQL Monitor to keep an eye on our mission critical servers. I like the product. It is reasonably user-friendly, reliabl...
121 comments:
Monday, 7 December 2015

Databases With No Recent Backups

›
I've written the script below to easily identify databases that have not had backups taken within a certain amount of time. This could b...
1 comment:
›
Home
View web version

About Me

Thomas Mucha
View my complete profile
Powered by Blogger.