davidsalazar01 (12/12/2014)

---

Gazareth, I will try the update sample you sent.

Jeff, I definitely want to update all values (I don't think there are null values) as I need to sanitized all...

If I'm reading that correctly, won't it just start updating rows that already have the value 'ayIWt6C8sgimC6t61EJ9d8BB3+bfIZ8v' ?

Try

UPDATE [dbo].[CC_Info_T]

SET [Acct_Num_CH] = 'ayIWt6C8sgimC6t61EJ9d8BB3+bfIZ8v'

WHERE [Acct_Num_CH] <> 'ayIWt6C8sgimC6t61EJ9d8BB3+bfIZ8v'

NB: Rowcount is deprecated, TOP...

New Born DBA (12/12/2014)

---

Gazareth (12/12/2014)

---

Comparing the backup_size and compressed_backup_size fields in msdb.dbo.backupset table should tell you how much compression, if any, took place.

Which version & edition are you running? Backup...

Comparing the backup_size and compressed_backup_size fields in msdb.dbo.backupset table should tell you how much compression, if any, took place.

Which version & edition are you running? Backup compression on standard edition...

When P is P, P also shuts down as it can't form a quorum (to help protect against a split brain scenario).

It's. Too. Early. For. This. 🙂

For Procs/Views/Triggers/Functions:

select * from sys.sql_modules where definition like '%xp_cmdshell%'

This runs in the context of the current database; you'll need to use sp_msforeachdb or your own loop/cursor to go through multiple...

cphite (12/5/2014)

---

Gazareth (12/5/2014)

---

Copying the results of this into SSMS might be quicker (category_id 100 should be Report Server - check this first!):

select 'exec msdb.dbo.sp_update_job @job_id = ''' + cast(job_id as...

That is worrying!

Don't have any 2012 instances around to check on, so I'll resort to speculation - is the suggested index identical in the included columns, and their order too?

Cheers

Yep, it's a documented issue, fixed in SQL 2012.

http://www.sqlskills.com/blogs/paul/missing-index-dmvs-bug-that-could-cost-your-sanity/

https://connect.microsoft.com/SQLServer/feedback/details/400578/query-plan-missing-index-recommendation-doesnt-check-if-an-index-actually-exists

Copying the results of this into SSMS might be quicker (category_id 100 should be Report Server - check this first!):

select 'exec msdb.dbo.sp_update_job @job_id = ''' + cast(job_id as varchar(50)) +...

Then colour me ashamed 🙂

It is one of only a handful I actually remember though!

Hi, give dateadd a whirl: http://msdn.microsoft.com/en-us/library/hcxe65wz%28v=vs.90%29.aspx

Should be something along the lines of =WeekdayName(weekday(DateAdd(DateInterval.Day, -1, fields!date.value)))

Nice question, thanks. And a good explanation of why it's not needed so much these days.

Nice one, and thanks for taking the time to post your solution 🙂