×

Allocation Pages In SQL Server

January 20, 2016

In order to understand how page/extent allocation works with in SQL Server for entities (objects) I was reading Paul Randal’s (B|T) blog. While reading different articles I thought of summarizing few critical information into a table. Which will help me consuming the information better and review easily when I need to. With Paul’s written consent […]

SQL Agent Jobs With Notification Enabled

January 8, 2016

DBA team that I worked with manage 170+ SQL Servers. We do not enable notification on any SQL Agent job. We centrally monitor all jobs and send a notification based on the tier (Business-critical). Last night on-call DBA got paged for a job failed in the server we are doing proof of concept. By looking […]

What Is Consuming My Log Space

October 2, 2015

Often times DBA’s (including myself at the beginning of my DBA career) struggle to find out what is causing the log files to grow. Or what is consuming all the space in my log files. I understand there are many factors that can impact the log file size besides all the active transactions. Such as: […]

Manage SQL Agent Job History

October 2, 2015

Recently in one of our server row count in MSDB.DBO.SysJobHistory table exceeded 100 Million and looking at job history was slow via SSMS. It was impossible via the GUI. Because we had about 50 jobs that were running frequently (called from a listener mostly once in every 2 to 3 minutes). I was curious if […]

List All Objects In FileGroup with Size

May 7, 2015

Recently at my work due to low free space on a LUN I was forced to rebuild few indexes on a different filegroup (which resides on a different LUN). I wanted to list all user objects belong to a single filegroup including size. I did not find a query online with everything I needed. So […]


profile for SqlWorldWide on Stack Exchange, a network of free, community-driven Q&A sites

Kubernetes Learning Path

50-days from zero to
hero with Kubernetes

Download eBook

The people who had a big problem with a Black president playing golf haven’t said much about a white one spending more... than one calendar year of his time in office at one of his country clubs. And one of them didn’t let 200,000 Americans die.

Call for Speakers for Granite State Code Camp 2020 is open and I've just submitted a session! Just 2 more weeks to get ... yours in! https://sessionize.com/granite-state-code-camp-2020

“I want you to use my words against me. If there’s a Republican president in 2016 and a vacancy occurs in the last ... year of the first term, you can say Lindsey Graham said let’s let the next president, whoever it might be, make that nomination."

Load More...