What are your target server memory and current memory settings?

I have used data janitor often for other IT people asking.

Thanks for the note. If I get a chance, i'll update the article. Of if you want to write an updated version that talks about the enhancements of sp_executesql over...

I had hopes that the GDPR would actually start to move the needle on this stuff, but I don't think it's going to. It's pretty clear that businesses are...

Did a little work here to solve some customer problem, so added a few. If you have ideas, would love someone to sketch out more complex ones: https://www.sqlservercentral.com/contributions

Yes, it's insane that it isn't taken more seriously.  People will say that they take it seriously, but then not give the people what they need to...

Re: work-to-live v live-to-work

Many other countries have driven people, they make advances, they do creative things. They learn that their knowledge and skill isn't necessarily related to hours put in....

Thanks for all the responses. What I would add here is that burning out isn't just hours. It isn't just overwork or long commutes or travel. It's a combination of...

Trying to do these every other Wed (with Python in between) to keep myself fresh as well.

It's filed as an item to work on. The new forums didn't have this feature and it somehow got lost in the development.

Glad I finally got something right :). Writing these questions clearly and getting answers organized is harder than I ever expected.

It took me some time to understand this function, though...

Tools are essential. Everyone uses them, whether they write one, download one, or buy one. These make a huge difference. Learning to use them properly is important, and unlike the...

Do you mean expand the list in SSMS? No, the schema DMV is likely locked, and SSMS times out. You can create the table first, or you can try to...

Stop thinking NDF v MDF. This is filegroups that you're considering. The files in a filegroup all need to be the same size. The filegroups do not need to be...

I think they make plenty of money. Not sure how things work out, but the last time I see the SE/EE breakdown, it was 3:1 or 4:1. Since EE costs...