Need to find a character - RUSTY SOLVED IT
Re: Need to find a character - RUSTY SOLVED IT
Trust rusty to find the G-string!
- Tribble
- Registered User
- Posts: 88465
- Joined: 08 Feb 2007, 02:00
- Processor: Intel Core i7-4770K CPU@3.50GHz
- Motherboard: ACPI x64-based PC
- Graphics card: GeForce GTX 780 Ti
- Memory: 16GB
- Location: Not here
- Contact:
Re: Need to find a character - RUSTY SOLVED IT
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.
-
- Forum Administrator
- Posts: 22136
- Joined: 14 Jun 2004, 02:00
- Processor: Ryzen 1700K
- Motherboard: Asus X370
- Graphics card: Asus 1060 Strix
- Memory: 16GB RAM
- Location: Where Google says
Re: Need to find a character - RUSTY SOLVED IT
Wow...
And the company is sending me on a SQL course! I am wonder if I should be scared...
And the company is sending me on a SQL course! I am wonder if I should be scared...
JUSTICE, n A commodity which is a more or less adulterated condition the State sells to the citizen as a reward for his allegiance, taxes and personal service.
-
- Registered User
- Posts: 20576
- Joined: 19 Sep 2003, 02:00
- Location: Bloodbank
Re: Need to find a character - RUSTY SOLVED IT
Why would you be scared?Anakha56 wrote:Wow...
And the company is sending me on a SQL course! I am wonder if I should be scared...
- Spoiler (show)
- Tribble
- Registered User
- Posts: 88465
- Joined: 08 Feb 2007, 02:00
- Processor: Intel Core i7-4770K CPU@3.50GHz
- Motherboard: ACPI x64-based PC
- Graphics card: GeForce GTX 780 Ti
- Memory: 16GB
- Location: Not here
- Contact:
Re: Need to find a character - RUSTY SOLVED IT
Anakha56, If I can do what I need to without training - you should be fine. Methinks I should go on a course too.
-
- Registered User
- Posts: 20576
- Joined: 19 Sep 2003, 02:00
- Location: Bloodbank
Re: Need to find a character - RUSTY SOLVED IT
I never took a course. I learned what I did from DBA's at companies I worked at and from hands on experience.
- Spoiler (show)
- rustypup
- Registered User
- Posts: 8872
- Joined: 13 Dec 2004, 02:00
- Location: nullus pixius demonica
- Contact:
Re: Need to find a character - RUSTY SOLVED IT
RuadRauFlessa wrote:hands on experience.
<translation>
That gut-wrenching moment when the DB responds: "4,238,107 rows updated"
Most people would sooner die than think; in fact, they do so - Bertrand Russel
-
- Registered User
- Posts: 20576
- Joined: 19 Sep 2003, 02:00
- Location: Bloodbank
Re: Need to find a character - RUSTY SOLVED IT
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.
- Spoiler (show)
- Tribble
- Registered User
- Posts: 88465
- Joined: 08 Feb 2007, 02:00
- Processor: Intel Core i7-4770K CPU@3.50GHz
- Motherboard: ACPI x64-based PC
- Graphics card: GeForce GTX 780 Ti
- Memory: 16GB
- Location: Not here
- Contact:
Re: Need to find a character - RUSTY SOLVED IT
Ah update query - that is what I am doing now.
-
- Forum Administrator
- Posts: 22136
- Joined: 14 Jun 2004, 02:00
- Processor: Ryzen 1700K
- Motherboard: Asus X370
- Graphics card: Asus 1060 Strix
- Memory: 16GB RAM
- Location: Where Google says
Re: Need to find a character - RUSTY SOLVED IT
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...
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...
JUSTICE, n A commodity which is a more or less adulterated condition the State sells to the citizen as a reward for his allegiance, taxes and personal service.
- Tribble
- Registered User
- Posts: 88465
- Joined: 08 Feb 2007, 02:00
- Processor: Intel Core i7-4770K CPU@3.50GHz
- Motherboard: ACPI x64-based PC
- Graphics card: GeForce GTX 780 Ti
- Memory: 16GB
- Location: Not here
- Contact:
Re: Need to find a character - RUSTY SOLVED IT
Lol I agree. Just need to find the time. They need the modifications now.
- rustypup
- Registered User
- Posts: 8872
- Joined: 13 Dec 2004, 02:00
- Location: nullus pixius demonica
- Contact:
Re: Need to find a character - RUSTY SOLVED IT
@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...
Most people would sooner die than think; in fact, they do so - Bertrand Russel
-
- Registered User
- Posts: 20576
- Joined: 19 Sep 2003, 02:00
- Location: Bloodbank
Re: Need to find a character - RUSTY SOLVED IT
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.
- Spoiler (show)
-
- Forum Administrator
- Posts: 22136
- Joined: 14 Jun 2004, 02:00
- Processor: Ryzen 1700K
- Motherboard: Asus X370
- Graphics card: Asus 1060 Strix
- Memory: 16GB RAM
- Location: Where Google says
Re: Need to find a character - RUSTY SOLVED IT
The twisted emoticon and Google have saved me from trusting the puppyrustypup 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...
JUSTICE, n A commodity which is a more or less adulterated condition the State sells to the citizen as a reward for his allegiance, taxes and personal service.
- Tribble
- Registered User
- Posts: 88465
- Joined: 08 Feb 2007, 02:00
- Processor: Intel Core i7-4770K CPU@3.50GHz
- Motherboard: ACPI x64-based PC
- Graphics card: GeForce GTX 780 Ti
- Memory: 16GB
- Location: Not here
- Contact:
Re: Need to find a character - RUSTY SOLVED IT
Ronny keeps wanting me to Drop database too I will get him for that
-
- Registered User
- Posts: 20576
- Joined: 19 Sep 2003, 02:00
- Location: Bloodbank
Re: Need to find a character - RUSTY SOLVED IT
Anakha56 wrote:The twisted emoticon and Google have saved me from trusting the puppyrustypup 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...
- Spoiler (show)
-
- Registered User
- Posts: 4110
- Joined: 22 Mar 2005, 02:00
- Location: Stonehenge
- Contact:
Re: Need to find a character - RUSTY SOLVED IT
Looking for tribble... Here kitty kitty kitty.
ON topic, well done rusty
ON topic, well done rusty
~~*Head of the Druidic Council of the Pride of Darkness*~~
AMD PhenomII X4 955
M4N98TD-EVO
ENGTX560 TI DCII TOP
8GB Corsair XMS
Antec TP 750W
- hamin_aus
- Forum Moderator
- Posts: 18363
- Joined: 28 Aug 2003, 02:00
- Processor: Intel i7 3770K
- Motherboard: GA-Z77X-UP4 TH
- Graphics card: Galax GTX1080
- Memory: 32GB G.Skill Ripjaws
- Location: Where beer does flow and men chunder
- Contact:
Re: Need to find a character - RUSTY SOLVED IT
Tribble wrote:Code: Select all
USE [FAP]
Re: Need to find a character - RUSTY SOLVED IT
WOW, Well done Rusty, you are deserving of the accolade!
However this is now seen its bottom, cheers.
However this is now seen its bottom, cheers.