Viewing 15 posts - 6,121 through 6,135 (of 18,926 total)
Ok so you only need to process the new rows added today, but in a table with over 1 Billion rows? How many rows do you need to process...
May 13, 2011 at 5:17 pm
That's your first error. Sql dbs are live and can't be copied into any image software I know (except expansive san ones).
If you had screwed up the db could...
May 13, 2011 at 3:23 pm
Not surprised, please post the query and the actual execution plan (sqlplan).
May 13, 2011 at 3:20 pm
SOrry for the incomplete phrase... but you got the idea anyways.
How much data in this table (rows and gb in the table)?
Can we have the table definition including keys and...
May 13, 2011 at 2:55 pm
I've taken as much as 80% pressure of hds system with only 20-30 hours of work on completely unkown system without changing 1 line of code.
I know what it takes...
May 13, 2011 at 2:53 pm
aaapppleee (5/13/2011)
Thanks a lot:-)
No offense but if you have no experience don't play with it. I wouldn't do brain surgury on my friends and I don't think anyone unqualified...
May 13, 2011 at 2:49 pm
sqldba_icon (5/13/2011)
May 13, 2011 at 11:42 am
2 points if you can guess what RGRus stands for (term not coined by me!).
May 13, 2011 at 11:20 am
Dugi (5/13/2011)
Ninja's_RGR'us (5/13/2011)
Dugi (5/13/2011)
stan-617410 (5/13/2011)
Ninja's_RGR'us, you are right... I have a trigger, I didn't realize that it was having the problem.
Thanks Dugi, your last submission is where...
May 13, 2011 at 11:18 am
Dugi (5/13/2011)
stan-617410 (5/13/2011)
Ninja's_RGR'us, you are right... I have a trigger, I didn't realize that it was having the problem.
Thanks Dugi, your last submission is where I started.
I...
May 13, 2011 at 11:11 am
aaapppleee (5/13/2011)
The App is named isalon, when doing report/analysis for one month, it takes very long, 15/20 mins, sometime you have to wait forever,
I check the computer, it is working...
May 13, 2011 at 11:10 am
That's certainly doing but I don't understand why you need to flag those. I can't help to think that there's more to it than what you're letting us know.
Maybe...
May 13, 2011 at 11:09 am
stan-617410 (5/13/2011)
Ninja's_RGR'us, you are right... I have a trigger, I didn't realize that it was having the problem.
Thanks Dugi, your last submission is where I started.
I appreciate...
May 13, 2011 at 11:06 am
How do you do that with strings / dates?
May 13, 2011 at 10:36 am
SanDroid (5/13/2011)
Ninja's_RGR'us (5/13/2011)
SanDroid (5/13/2011)
Steve Jones - SSC Editor (5/13/2011)
Hugo Kornelis (5/13/2011)
In the daily newsletter, the question specifies to "select 4". Which is what I did. And then I find that...
May 13, 2011 at 10:33 am
Viewing 15 posts - 6,121 through 6,135 (of 18,926 total)