From the article...

---

Extended Events, just for example, is wildly superior to Profiler/Trace.

Heh... NOT! 😀  But we'll save that discussion for another time.

I agree with a whole lot that you've...

My comment would be to not use Python to duplicate what can be done in SQL Server.  Only use it if you have something that SQL Server can't do well...

Since the tables are being truncated and then repopulated by inserts, they'll be pretty well packed at the page level of nearly 100% page fullness before they get hit with...

Okay,

Thanks,

I thought it was just growing because we are putting so much data in there and that involves a transaction.

So you are indicating that they would be committed and...

My Weekly Full Transaction Log Backup and Shrink Keeps Killing my Log Shipping by throwing it out of synch.

No matter when I try to time it, it throws of...

I see nothing wrong with such a DDL trigger to detect when a new database was created... but I wouldn't rely on it to make sure backups are performed.  The...

At least try to help yourself...

https://www.google.com/search?q=How+to+find+size+of+each+filegroup%3F

Without seeing the actual execution plans of the parts that are taking the longest, we're all just "guess'n and suggest'n".  You need to figure out what the "high points" are...

p.s.  I also agree with Phil... if you have SSIS, SSAS, and other SQL "4 letter words" involved in jobs, this could end up being a fair bit more difficult...

If you...

Unfortunately this application doesn't work quite that simply.  "Relativity" is an eDiscovery platform that allows users in the course of their work to add and remove fields that they...

That's a great story, Grant, and I 100% agree that's was an appropriate use of PowerShell.  The question is, would you have been comfortable in letting someone who didn't know...

Total agreement with everyone else that you should be spotting when new databases are created. However, it's entirely possible to create a backup script (or use Minion or Ola...

First of all (and you probably all ready know this but I have to say it out loud), fix the main problem that started all of this... stop giving users...

I'm thinking that the data has an embedded Cr, Lf, or Vertical Tab in it and OPENQUERY along with the given provider is treating what follows that as a separate...