Category Archives: SQL

Comprehensive Baseline Collector Solution get published on SQLServerCentral

My free Comprehensive Baseline Collector Solution has been published on SQLServerCentral.

Posted in baseline, maintenance, Project, Script, SQL | Leave a comment

Real life scenario for collecting data using linked servers get published on SQLServerCentral

My real life example how you can collect data from SQL Server instances using linked servers has been published on SQLServerCentral (When the reporting team needs an assist…). It is also a good example for practical usage of sp_uforeach (additional link) … Continue reading

Posted in Publication, Script, sp_uforeach, SQL | Leave a comment

sp_uforeach get published on SQLServerCentral

You can find my sp_uforeach script on SQLServerCentral as well: Universal foreach aka sp_uforeach

Posted in Project, Script, sp_uforeach, SQL | Leave a comment

Bug: DBCC CHECKDB data purity checks are skipped for master and model

It has been a long time since I wrote a post. I had so so much work to do, so that I had no time for posting Anyway I want to change that in the future. I don’t promise that … Continue reading

Posted in bug, DBCC, SQL | Leave a comment

Deadlock scenario: ALLOW_ROW_LOCKS and ALLOW_PAGE_LOCKS index options

Last month I helped one of my customer investigate a deadlock situation. After we got the deadlock report it turned out that we were dealing with a ‘conversion deadlock’ caused by inappropriate index options. Let’s reproduce and check the situation. … Continue reading

Posted in Deadlock, Index, SQL | 5 Comments

Project No. 1. – Universal foreach aka uforeach

Hi Everyone! This is the first post of SQLApprentice.net. In this post I would like to introduce my universal foreach script. So, here is the story: There is a very good blog post about removing duplicated indexes posted by Kimberly … Continue reading

Posted in Project, Script, SQL | Tagged , , | Leave a comment