×

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 […]

Fix High or Low VLF Count

February 26, 2015

We started collecting a count of all VLF across the enterprise and yes there were few with high counts. I know there are no SET guidelines on how many is too low or too high. After chatting with MVP Allen Kinsel (Blog|Twitter) and Kevin Conan (Twitter) I decided to fix using this threshold. You will […]

Which Node SQL Cluster was Running

February 20, 2015

While troubleshooting unplanned SQL cluster failover few questions are asked commonly. When did the last failover occur? How frequently you failover (planned and unplanned)? Did this happen recently? All these questions can be answered by this query.  Your output will depend on how frequently you recycle error log and retention of the error log. You […]

My Stackexchange Profile

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

Announcing the 1st Data Platform Discovery Day - a 100-level, 1-day virtual conference intended for those looking to ... change their career path or data platform beginners looking to expand their skill sets. CfS live at https://dataplatformdiscoveryday.com/ til 4/13. US day 4/29, Europe day 4/30.

We are pleased to announce #SQLSaturday #1000, in Portland, Oregon on October 24, 2020!

... http://www.sqlsaturday.com/1000/EventHome.aspx

Since #SQLSat started in 2007, there have been some amazing milestones achieved along the way. Check out some of the highlights by clicking the image below! #sqlpass

I know many of us are biased between blue and red.
U want to know the fact. Call someone you trust and works in NY city ... hospital.
I did with 2 doc, 1 admin and 1 finance person.
You are bound to get angry and not trust a bit of these TV shows at 5pm.

#CoronaPandemic

No days off. Thanks to some serious teamwork, Massachusetts is set to receive over 1 million N95 masks for our ... front-line workers. Huge thanks to the Krafts and several dedicated partners for making this happen.

Load More...