If I had a nickel for every client I have come across over the past two decades that had umpteen SQL Agent or other batch jobs starting at the same...

I'm with Igor. Using sp_spaceused to determine OLTP insert size seems improper, although i supposed it could work out.

What type of data? What does indexing look like? Any triggers (auditing...

Andrew P (11/29/2016)

---

I should have noted that this database isn't business critical. I definitely would look into hiring Gail if this were, thanks TheSQLGuru.

Is there anything more I could do...

This is probably overly cumbersome, but I am sick and tired - literally. 😀

Note that if you can guarantee both dates are already end of their respective months, I do...

Are your two dates ALWAYS both the end of their respective months? Becomes quite trivial if so.

My advice is to get a hold of Gail Shaw (SQLintheWild) from here on the SSC.com forums and engage her as a consultant. She is in South Africa but you...

Mike Scalise (11/29/2016)

---

TheSQLGuru (11/29/2016)

---

Ola's code is completely open for you to modify to suit if you need to. If the options don't allow you to do NO backups just make...

Seems like Full Text engine (or it's interaction with relational engine) isn't happy. I would use sp_whoisactive in differential mode and see if any work is being done by the...

Numbers Table #FTW!!

Glad you...

Ola's code is completely open for you to modify to suit if you need to. If the options don't allow you to do NO backups just make your own copy...

Indianrock (11/29/2016)

---

Ours seem to be a mix. Sometimes I'll see all parameters defined as varchar(8000), other times there are varchar set at the string length ( varchar(23)...

wendy elizabeth (11/29/2016)

---

The .write statement is used was an nvarchar(max) column. I am using a varchar(max) column. Will the write statement work with a varchar(max) column?

Also if you...

Definitely best practice to set all tempdb data files same size and same growth. Unbalanced scenarios can happen otherwise, leading to poor IO usage patterns.

You can grow the main file...

Sqlsavy (11/29/2016)

---

Is it possible to estimate database capacity based on following details?

Volume of records held in the database- 18000000

Volume of updates per day thru overnight batch- 50k

Database growth expected to...