Need to find a character - RUSTY SOLVED IT

Get help on databases - MySQL, Oracle, Access, etc.
User avatar
Stuart
Lead Forum Administrator
Posts: 38503
Joined: 19 May 2005, 02:00
Location: Home

Re: Need to find a character - RUSTY SOLVED IT

Post by Stuart »

Trust rusty to find the G-string! :roll: :twisted:
Image
User avatar
Tribble
Registered User
Posts: 88456
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

Post by Tribble »

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.
Image
Anakha56
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

Post by Anakha56 »

Wow... :shock:

And the company is sending me on a SQL course! :shock: 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.
RuadRauFlessa
Registered User
Posts: 20576
Joined: 19 Sep 2003, 02:00
Location: Bloodbank

Re: Need to find a character - RUSTY SOLVED IT

Post by RuadRauFlessa »

Anakha56 wrote:Wow... :shock:

And the company is sending me on a SQL course! :shock: I am wonder if I should be scared...
Why would you be scared?
:rock: :rock: :rock: :rock: :rock: :rock: :rock: :rock: :rock: :rock:
Spoiler (show)
Intel Core i7-2600k @ 3.4GHz
Corsair Vengence 2x4GB DDR3 2000MHz
Thermaltake Toughpower 850W
ASUS nVidia GTX560 1GB
CoolerMaster HAF 932
User avatar
Tribble
Registered User
Posts: 88456
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

Post by Tribble »

Anakha56, If I can do what I need to without training - you should be fine. Methinks I should go on a course too.
Image
RuadRauFlessa
Registered User
Posts: 20576
Joined: 19 Sep 2003, 02:00
Location: Bloodbank

Re: Need to find a character - RUSTY SOLVED IT

Post by RuadRauFlessa »

I never took a course. I learned what I did from DBA's at companies I worked at and from hands on experience.
:rock: :rock: :rock: :rock: :rock: :rock: :rock: :rock: :rock: :rock:
Spoiler (show)
Intel Core i7-2600k @ 3.4GHz
Corsair Vengence 2x4GB DDR3 2000MHz
Thermaltake Toughpower 850W
ASUS nVidia GTX560 1GB
CoolerMaster HAF 932
User avatar
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

Post by rustypup »

RuadRauFlessa wrote:hands on experience.

<translation>
That gut-wrenching moment when the DB responds: "4,238,107 rows updated" :lol:
Most people would sooner die than think; in fact, they do so - Bertrand Russel
RuadRauFlessa
Registered User
Posts: 20576
Joined: 19 Sep 2003, 02:00
Location: Bloodbank

Re: Need to find a character - RUSTY SOLVED IT

Post by RuadRauFlessa »

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. :wink:
:rock: :rock: :rock: :rock: :rock: :rock: :rock: :rock: :rock: :rock:
Spoiler (show)
Intel Core i7-2600k @ 3.4GHz
Corsair Vengence 2x4GB DDR3 2000MHz
Thermaltake Toughpower 850W
ASUS nVidia GTX560 1GB
CoolerMaster HAF 932
User avatar
Tribble
Registered User
Posts: 88456
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

Post by Tribble »

Ah update query - that is what I am doing now.
Image
Anakha56
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

Post by Anakha56 »

:lol: Reason for being scared so much typing to do! :P

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.
User avatar
Tribble
Registered User
Posts: 88456
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

Post by Tribble »

Lol I agree. Just need to find the time. They need the modifications now.
Image
User avatar
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

Post by rustypup »

@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... :twisted:
Most people would sooner die than think; in fact, they do so - Bertrand Russel
RuadRauFlessa
Registered User
Posts: 20576
Joined: 19 Sep 2003, 02:00
Location: Bloodbank

Re: Need to find a character - RUSTY SOLVED IT

Post by RuadRauFlessa »

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. :D
:rock: :rock: :rock: :rock: :rock: :rock: :rock: :rock: :rock: :rock:
Spoiler (show)
Intel Core i7-2600k @ 3.4GHz
Corsair Vengence 2x4GB DDR3 2000MHz
Thermaltake Toughpower 850W
ASUS nVidia GTX560 1GB
CoolerMaster HAF 932
Anakha56
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

Post by Anakha56 »

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... :twisted:
The twisted emoticon and Google have saved me from trusting the puppy :evil:

:P
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.
User avatar
Tribble
Registered User
Posts: 88456
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

Post by Tribble »

Ronny keeps wanting me to Drop database too :twisted: I will get him for that :lol:
Image
RuadRauFlessa
Registered User
Posts: 20576
Joined: 19 Sep 2003, 02:00
Location: Bloodbank

Re: Need to find a character - RUSTY SOLVED IT

Post by RuadRauFlessa »

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... :twisted:
The twisted emoticon and Google have saved me from trusting the puppy :evil:

:P
:lol: :lol: :lol: :lol: :lol: :lol:
:rock: :rock: :rock: :rock: :rock: :rock: :rock: :rock: :rock: :rock:
Spoiler (show)
Intel Core i7-2600k @ 3.4GHz
Corsair Vengence 2x4GB DDR3 2000MHz
Thermaltake Toughpower 850W
ASUS nVidia GTX560 1GB
CoolerMaster HAF 932
qwiksilva666
Registered User
Posts: 4110
Joined: 22 Mar 2005, 02:00
Location: Stonehenge
Contact:

Re: Need to find a character - RUSTY SOLVED IT

Post by qwiksilva666 »

Looking for tribble... Here kitty kitty kitty. :D


ON topic, well done rusty :P
Image
~~*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
User avatar
hamin_aus
Forum Moderator
Posts: 18358
Joined: 28 Aug 2003, 02:00
Processor: Intel i7 3770K
Motherboard: GA-Z77X-UP4 TH
Graphics card: EVGA GTX680 SC
Memory: 32GB G.Skill Ripjaws
Location: Where beer does flow and men chunder
Contact:

Re: Need to find a character - RUSTY SOLVED IT

Post by hamin_aus »

Tribble wrote:

Code: Select all

USE [FAP]
Image
Image
lancelot
Registered User
Posts: 7162
Joined: 13 May 2003, 02:00
Location: Cape Town

Re: Need to find a character - RUSTY SOLVED IT

Post by lancelot »

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