I have seen holidays stored as bit-columns on traditional calendar tables that contain one row for each date and have seen them normalized out to separate tables. Thanks for sharing...

select datefromparts(year(getdate())-1,1,1) as beginning_of_last_year,

datefromparts(year(getdate())-1,12,31) as end_of_last_year;

michael_okonji (2/15/2016)

---

I've got this job that needs to be executed in prod during downtime at exactly 9pm EST, starting with a backup. But the database that ill be setting up...

I am not sure why are you involving xp_cmdshell in this. If you execute your command-line in an SSIS Execute Process Task and capture the output to a variable or...

DOes your real City tale only have Malaysian cities in it? I am guessing not, but in this small example there are only 695 rows in the city table and...

This person asked if we could put the production database code into a VCS. Not as a way of tracking development tasks, but as a way of auditing production and...

For someone who has made so much hay off helping others slay RBAR processing, I don't blame you one iota for not wanting to review something you have no opportunity...

Start by running Upgrade Advisor against your database to see if any red flags are raised, e.g. deprecation announcements or features that been dropped from the product in use.

https://msdn.microsoft.com/en-us/library/ms144256(v=sql.110).aspx

It can skip databases: https://www.mssqltips.com/sqlservertip/2201/making-a-more-reliable-and-flexible-spmsforeachdb/

It can be very disruptive. Scary fact: Maintenance Plans used to rely on the proc, may still.

At the bottom of your dynamic proc change you needed to change this:

to this:

and InjectedDate Between ''' + convert(varchar(100),@DateFrom) +'''And''' + convert(varchar(100),@DateTo) +...

Just in case anyone else happens to stumble on this thread, this...

Wow, this thread has come back from the dead not once, but twice now!

Perry Whittle (2/15/2016)

---

Orlando Colamatteo (2/13/2016)

---

Be wary of the PowerShell step type in SQL Agent though. I prefer to have a my PowerShell scripts saved to .ps1 files (ideally on a...

Can you try it in order from most rows to least, see Jeff's follow-up post to mine. The thought being to reduce the set as much as possible as early...

True, provided the column is nullable, my understanding is also that...