October 7, 2011 at 8:27 am
Kiara (10/7/2011)
*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.
In the same boat
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:29 am
SQLRNNR (10/7/2011)
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:
That's called ads revenue! 😀
October 7, 2011 at 8:30 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.
Nah, you'll be fine. Besides, if you don't challenge yourself from time to time, why bother?
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
October 7, 2011 at 8:32 am
Kiara (10/7/2011)
*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.
I'm a contractor, I have those moments all the time. Every new job has more fun surprises waiting.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
October 7, 2011 at 8:33 am
Chad Crawford (10/7/2011)
... I've updated my avatar and it does slightly resemble me now....
You might need to go back to the other avatar - this is a family site :w00t::hehe::-D;-)
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:35 am
GSquared (10/7/2011)
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.)
Oh, that sounds like fun. We're about to decomission a SAN and repurpose/reformat it for a new database. This means I'll finally have enough drives so I don't have to have any sharing, like the Tempdb on C or a log file on the data drive from lack of space. We found out recently that the physical drives on the machines have 4k blocks instead of 64k blocks, so we're going to try and fix that and move everything in stages. Should be fun.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
October 7, 2011 at 8:37 am
Stefan Krzywicki (10/7/2011)
...
Out of curiosity - how should we pronounce your last name? I want to pronounce it like Krzyzewski. Maybe we call you DBA K:-D
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:42 am
SQLRNNR (10/7/2011)
Stefan Krzywicki (10/7/2011)
...Out of curiosity - how should we pronounce your last name? I want to pronounce it like Krzyzewski. Maybe we call you DBA K:-D
Looks like Krazy Wiki if you read it too fast!
October 7, 2011 at 8:43 am
SQLRNNR (10/7/2011)
Stefan Krzywicki (10/7/2011)
...Out of curiosity - how should we pronounce your last name? I want to pronounce it like Krzyzewski. Maybe we call you DBA K:-D
Man, I got those nicknames all my life because people couldn't pronnounce it. When I was at a track meet in high school, my turn came up and I heard the guy say
Stefan Krz
Stefan Kri
Hey Alphabet, you're up!
The easiest way to explain it is Chris Wiki. Make the "S" in Chris sound more like a z and you've got it.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
October 7, 2011 at 8:43 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 am sure you will handle it fine. If I am able to handle a 600 GB DB, I am sure you will be able to manage TB of data. The basics are still the same whether it is a small DB or if it is a VLDB. 🙂
-Roy
October 7, 2011 at 8:45 am
Stefan Krzywicki (10/7/2011)
SQLRNNR (10/7/2011)
Stefan Krzywicki (10/7/2011)
...Out of curiosity - how should we pronounce your last name? I want to pronounce it like Krzyzewski. Maybe we call you DBA K:-D
Man, I got those nicknames all my life because people couldn't pronnounce it. When I was at a track meet in high school, my turn came up and I heard the guy say
Stefan Krz
Stefan Kri
Hey Alphabet, you're up!
The easiest way to explain it is Chris Wiki. Make the "S" in Chris sound more like a z and you've got it.
Remi wasn't too far off then. A lot more straight forward than Coach K.
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:46 am
SQLRNNR (10/7/2011)
Chad Crawford (10/7/2011)
... I've updated my avatar and it does slightly resemble me now....
You might need to go back to the other avatar - this is a family site :w00t::hehe::-D;-)
HAHA!
October 7, 2011 at 8:49 am
Chad Crawford (10/7/2011)
SQLRNNR (10/7/2011)
Chad Crawford (10/7/2011)
... I've updated my avatar and it does slightly resemble me now....
You might need to go back to the other avatar - this is a family site :w00t::hehe::-D;-)
HAHA!
Enjoy the summit - bring some goodies back for me 😉
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:55 am
Roy Ernest (10/7/2011)
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 am sure you will handle it fine. If I am able to handle a 600 GB DB, I am sure you will be able to manage TB of data. The basics are still the same whether it is a small DB or if it is a VLDB. 🙂
Thank all for the vote of confidence. I guess that's why I learn so much, never 100% sure I know enough :-D.
October 7, 2011 at 9:03 am
SQLRNNR (10/7/2011)
Stefan Krzywicki (10/7/2011)
SQLRNNR (10/7/2011)
Stefan Krzywicki (10/7/2011)
...Out of curiosity - how should we pronounce your last name? I want to pronounce it like Krzyzewski. Maybe we call you DBA K:-D
Man, I got those nicknames all my life because people couldn't pronnounce it. When I was at a track meet in high school, my turn came up and I heard the guy say
Stefan Krz
Stefan Kri
Hey Alphabet, you're up!
The easiest way to explain it is Chris Wiki. Make the "S" in Chris sound more like a z and you've got it.
Remi wasn't too far off then. A lot more straight forward than Coach K.
My dad was a High School art teacher. For 40 years kids called him "Mistah K"
I'm glad we're not going with DBA K, leave out the space and it looks like a Kirby character. (from DC comics back in the 70s)
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
Viewing 15 posts - 30,736 through 30,750 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply