There are a lot of topics about becoming a DBA, search for it.

Funny thing is most people around is not a DBA and started to play with SQL by chance.

Try...

GilaMonster (11/20/2013)

They are a tool. They can be used well or used badly. When used badly, blame the developer, not the...

I learned something today, thanks!

(a bit shame for me, C# developer)

Last time I needed to do something like that (plumbing data from a terabyte text file) framework 2.0 was not...

Sean, you are right! Sorry John I missed the fact its a black box.

Sean you are right, again, about the FKs. Maybe the OP can just disable/drop that trigger and...

Jeff Moden (11/19/2013)

Hey, Hey, [font="Arial Black"]HEY[/font]! I'm old, I used to be a great VB6 programmer, I AM...

10 or more joins are not a problem.

Bad normalized/designed data structure and no properly indexed tables are.

Just try to outer join two big tables by no indexed columns or using...

To make a decision you must answer some questions: first, there are dependencies between rows in that big chunk of data?

Second, what do you want to do if a insert...

Question: a select count(1) from inserted ill return the number of inserted rows?

just for the record: avoid triggers, they are evil.

avoid to put business logic in the database, let the...

For developers, Its just a good practice to implement logging in the application.

(let the data base be just it)

you can create it in the business layer and hook all calls...

VB6 argh... it smells as a old poor designed legacy app.

Give it a look.

http://technet.microsoft.com/pt-br/library/ms187308.aspx

"Because @@FETCH_STATUS is global to all cursors on a connection, use @@FETCH_STATUS carefully."

Other possible problems...

Strange behaviour happens with update cursors.

First, make sure triggers are not firing in those tables, triggers are the best away to create bugs and strange behaviours in legacy systems.

Second, caution...

Wow, that's messy and someone is likely playing with Warehouses Old Numbers...

I can take a different path just using relational logic and helping the engine to speed up things.

Someting like.

select...

+1 to it.

That...

Thanks for everyone take time to write a comment.

Things are a bit worse:

1. The guys enforced this police are the architects/bosses/co owners of the corporation, to steps above me in...

I'm not a DBA! I never was but I did a lot of backups, recoverings, replications, tunnings, design, etc.

Early in my life I got a half period job in a...