Ed Wagner (10/6/2015)

---

I like the convention child_parent_PK

Where:

child = Name of the table with the foreign key

parent = Name of the table with the primary key being referred to

_PK = constant

For...

I prefer:

tablename__xx_name[&name]|description

where xx is:

PK | CL | IX | CK (check) | TR (trigger) | etc.

Sometimes a column name(s) are not really right and a description is better, such as...

Yes, this is a good situation for shrinking a file.

You might first want to rebuild large table(s), esp. if you can rebuild ONLINE.

I've had this dramatically speed up the shrink...

terry999 (10/6/2015)

---

Thanks for your reply

update tblcustomer

set Supid = Supid

I don't mind if this fails.

As long as the supid and manid are not part of the SET clause of an update...

Those JOIN conditions will always be met, regardless of the actual values in A (unless if a B column is NULL). So just do a CROSS JOIN of the...

It looks like you need

SELECT IDENT_CURRENT('dbo.tablename')

rather than IDENT_SEED.

You need to be more selective than that. Any reference to the column will turn the "UPDATE flag" on, even if the value is the same. Maybe something...

myzus2004 (10/3/2015)

---

Thanks scott for your feedback. Appreciate it .

The clustered index on InformationOverride table cannnot be changed as the composite index on these 3 columns have unique data.

I am...

I think this might do it, if I understand correctly what you need:

SELECT cast(0 as bit) as 'Escolha',data, contado , ollocal ,origem, ousrdata,ousrhora

...

Can we see the actual code you used to do the split and column assignment? Maybe there is something there.

You can check to see if the cursor exists before you DECLARE it. I added "LOCAL" to the cursor declaration so that you know for sure that it's local...

Sounds like you need a really fast splitter. Check out DelimitedSplit8K.

Might a job have run and hit that db but using a different user?

Lynn Pettis (10/1/2015)

---

ScottPletcher (10/1/2015)

---

You should get rid of the INSULL() in the WHERE clause, as always. Just NEVER use ISNULL() in a WHERE or JOIN. But it's esp....

You should get rid of the INSULL() in the WHERE clause, as always. Just NEVER use ISNULL() in a WHERE or JOIN. But it's esp. important if that...