PCFormat Forum Archive

Trust rusty to find the G-string!

Thanks. I shall do this. This is one of my feeder tables and the other tables do have indexed fields. But I shall check that they are mainly int fields.

Wow...

And the company is sending me on a SQL course! I am wonder if I should be scared...

Anakha56 wrote:Wow...

And the company is sending me on a SQL course! I am wonder if I should be scared...

Why would you be scared?

Anakha56, If I can do what I need to without training - you should be fine. Methinks I should go on a course too.

I never took a course. I learned what I did from DBA's at companies I worked at and from hands on experience.

RuadRauFlessa wrote:hands on experience.

<translation>
That gut-wrenching moment when the DB responds: "4,238,107 rows updated"

Yeah I actually had that only it was not "4,238,107 rows updated" it was more like "628,476,297 rows updated". Luckily from that experience I learned a couple of tricks how to recover the data without losing the users work from the last time a backup has been made. And that is also when you learn to comment out every line of code you write in SSMS even if it is something you intend to execute. You also learn from it to first write a select query to see what you are about to update for every update query you are writing so as to avoid updating the wrong things.

Ah update query - that is what I am doing now.

Reason for being scared so much typing to do!

I am being sent on a course because the SQL databases we use are all in a live enviroment and are constantly converting data from our customer into part orders for the different line's. Now I have to look after this "beast" and having no knowledge on SQL or this system makes me very nervous to play with it. If I crash it and stop the lines for a whole shift I am fired .

I think I will take the course Tribz because it would make life easier to learn than rather deleting something that I should not have...

Lol I agree. Just need to find the time. They need the modifications now.

@Anakha56: it will also benefit you to know that you can streamline backups by running a simple "drop database;" script just before the backup is scheduled to run...

Nah you just have to be careful. The course is a good thing. You can always learn something so it is never a waste. + you will have something to put on a CV.

rustypup wrote:@Anakha56: it will also benefit you to know that you can streamline backups by running a simple "drop database;" script just before the backup is scheduled to run...

The twisted emoticon and Google have saved me from trusting the puppy

Ronny keeps wanting me to Drop database too I will get him for that

Anakha56 wrote:

rustypup wrote:@Anakha56: it will also benefit you to know that you can streamline backups by running a simple "drop database;" script just before the backup is scheduled to run...

The twisted emoticon and Google have saved me from trusting the puppy

Looking for tribble... Here kitty kitty kitty.


ON topic, well done rusty

Tribble wrote:

Code: Select all

USE [FAP]

WOW, Well done Rusty, you are deserving of the accolade!
However this is now seen its bottom, cheers.