October 6, 2011 at 2:46 pm
Finding more people dealing with Oracle data in one form or another. I'm walking away before I have an episode of some sort.
October 7, 2011 at 7:20 am
amazing how this thread will explode or go dead in a cycle. Everyone watching Tigers/Yankees last night? Or the new Big Bang Theory?
October 7, 2011 at 7:25 am
Ok to bring this back on topic.
I'm eyeing a contract opportunity to work for a payment processing firm. I'd be team lead + perf tuning.
No my concern is that this is obviously a multi TB env. My biggest dbs were always quite small (200 GB, biggest tables 50 M rows and 4-5 GB of data).
So while I'm not completely adverse to large DBs, I'm wondering (again) if I might be bitting off too much on this one.
October 7, 2011 at 7:26 am
Steve Jones - SSC Editor (10/7/2011)
amazing how this thread will explode or go dead in a cycle. Everyone watching Tigers/Yankees last night? Or the new Big Bang Theory?
So you want 300 new posts everytime you open up your e-mail client?
We did that as a favor to you... don't be too greedy!
October 7, 2011 at 7:29 am
Ninja's_RGR'us (10/7/2011)
Steve Jones - SSC Editor (10/7/2011)
amazing how this thread will explode or go dead in a cycle. Everyone watching Tigers/Yankees last night? Or the new Big Bang Theory?So you want 300 new posts everytime you open up your e-mail client?
We did that as a favor to you... don't be too greedy!
Is this what you're asking, Steve?
I can help if you want.
-- Gianluca Sartori
October 7, 2011 at 7:31 am
*sigh* Anyone else ever have days when they want to rant about <insert favorite WTF tripped over in database> but feel like it's unprofessional to do so?
I've had one of those weeks.
-Ki
October 7, 2011 at 7:31 am
Not asking that at all, just strange that everyone dropped off at once.
I'm sure a few of you are heading to PASS or SQL Saturday #92 in Portland today, but just surprised not to see any posts.
October 7, 2011 at 7:36 am
Steve Jones - SSC Editor (10/7/2011)
Not asking that at all, just strange that everyone dropped off at once.I'm sure a few of you are heading to PASS or SQL Saturday #92 in Portland today, but just surprised not to see any posts.
Others are most likely preparing for PASS as well. That kills a lot of "us".
October 7, 2011 at 7:39 am
Jack Corbett (10/6/2011)
create function [dbo].[SYSDATE]()
returns datetime
as
begin
declare @sysdate_l datetime
select @sysdate_l = sdv.system_date
from system_date_view sdv
return @sysdate_l
end
Just a theory, but if this is vestigial code from 2000, it could be that he needed to use the System Date as a value in another udf. The view returns the system date as a one column row; wrapping a call to the view in a udf makes it a scalar value, so it can be used as a column, in a WHERE clause, etc.
October 7, 2011 at 8:19 am
Steve Jones - SSC Editor (10/7/2011)
amazing how this thread will explode or go dead in a cycle. Everyone watching Tigers/Yankees last night? Or the new Big Bang Theory?
Was watching Oregon/Cal
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
October 7, 2011 at 8:20 am
Ninja's_RGR'us (10/7/2011)
Ok to bring this back on topic.I'm eyeing a contract opportunity to work for a payment processing firm. I'd be team lead + perf tuning.
No my concern is that this is obviously a multi TB env. My biggest dbs were always quite small (200 GB, biggest tables 50 M rows and 4-5 GB of data).
So while I'm not completely adverse to large DBs, I'm wondering (again) if I might be bitting off too much on this one.
I think you'll be fine.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
October 7, 2011 at 8:21 am
I'm busy prepping for another attempt at moving our servers to a new datacenter.
The last one, the SAN engineer forgot to mark the partition on a LUN as NTFS, and all the files were corrupted as they transfered over. I only lost 3 days' work and stayed up for 48 hours and didn't get anything useful out of it because he couldn't be bothered to spend five minutes running a check disk utility before we tried to go live.
So, we're trying again next week, and I'm setting up for that.
(No, I'm not at all bitter about doing it twice. Not even slightly. I'm sure I'm not. Say this often enough and I might even convince myself.)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 7, 2011 at 8:22 am
Speaking of the PASS Summit, I'm going to try and get a copy of Jonathan, Ted, Gail (et.al.)'s book that I can get all the threadziens to autograph as a souvenir. If you see me and I don't recognize you, PLEASE introduce yourself and ask to sign the book. I did it last year and it was a load of fun, but was only able to track down four of you (I treasure the book - this year's Exceptional DBA even wrote a short poem!). I've updated my avatar and it does slightly resemble me now.
For those who are not able to make it this year, hopefully I'll run into you sometime soon. :'(
Thanks,
Chad
October 7, 2011 at 8:23 am
GSquared (10/7/2011)
I'm busy prepping for another attempt at moving our servers to a new datacenter.(No, I'm not at all bitter about doing it twice. Not even slightly. I'm sure I'm not. Say this often enough and I might even convince myself.)
Repeating it for ya :-D.
October 7, 2011 at 8:27 am
Ninja's_RGR'us (10/7/2011)
Steve Jones - SSC Editor (10/7/2011)
amazing how this thread will explode or go dead in a cycle. Everyone watching Tigers/Yankees last night? Or the new Big Bang Theory?So you want 300 new posts everytime you open up your e-mail client?
We did that as a favor to you... don't be too greedy!
Sounds like a reasonable request. Maybe Steve gets a commission based on post count from the thread.:Whistling:
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 15 posts - 30,721 through 30,735 (of 66,749 total)
You must be logged in to reply to this topic. Login to reply