ok, you have a requirement that is a little scary for me (ALL bit flas no matter what/all varchars no matter what)

*note this is changing ALL CURRENT DEFAULT VARCHAR FIELDS...

halifaxdal (8/2/2013)

---

Thanks.

Then how do I loop each field and find if there is a constraint on it? and get the constraint's name if I have to put the name there...

basic example:

CREATE TABLE [dbo].[SALESDATES] (

[ID] INT IDENTITY(1,1) ...

halifaxdal (8/2/2013)

---

I have a database with tables to be updated so that all varchar fields will be given a default '' value and all bit fields will be given 1

I...

i'm not sure what you are after here, might need a little clarification.

Are you talking about Data Masking like this article? Where you obfuscate/replace sensitive data on a copy of...

here's my best guess for you: in this case,note how i provided a CREATE TABLE and sample data via INSERT INTO?

if you can do the same in future posts, you'll...

I think you will need to update the table against a version of itself featuring row_number().

within the same order of magnitude or so, doesn't have...

yes that is correct; find the underlying tables of those views, and update stats on them;

you could also use something like this to blindly update all stats for all...

thre you go Donnie;

actual rows 3, but the estimated rows is almost a quarter million.

run this for the three tables involved in this query:

UPDATE STATISTICS [dbo].[VW_DirectReports] WITH FULLSCAN ;

UPDATE...

you DID NOT post readily consumable sample data.

your sample headers had five columns, but the data only appears in three.

how is anyone supposed to be able to use that?

i ran...

both the estimated execution plan and the actual execution...

ok, it sounds like a single service broker would work, but that you would call it 100 times, once for each table, for example.

if we can help with the details,...

agreeing with Steve, here; All SELECT queries take out Shared Locks for the period of time it takes to get the data; those shared locks might delay an update/insert/delete, but...

it really depends on what you are doing to give you a solid answer.

service broker calls run asynchronously; (sending mail via sp_send_dbmail is one common example) so you'd need to...