February 11, 2011 at 4:11 am
Koen Verbeeck (2/10/2011)
Brandie Tarvin (2/10/2011)
Hey, guys. I just wanted to point out this non-SQL post of mine:http://www.sqlservercentral.com/Forums/Topic1061974-61-1.aspx
Congratulations!
ps: no more Optimus Prime?
The people who have the license for Transformers only want agented authors or authors they know. The way for me to get around that is to keep writing, and publishing with different people. The more people I know, the more likely it is I'll finally meet them and get on their list.
February 11, 2011 at 4:12 am
jeff.mason (2/10/2011)
Brandie Tarvin (2/10/2011)
It's scary when Gail has to qualify her work in South Africa as "Yes, we really do have technology." 😀You have a nice voice, Gail.
Sort of the Voice of Authority -- do what I say because I KNOW what I am talking about.
Good presentation. Much of it was review but picked up a few new things here and there (like the Sev 10 error for 825). Also loved the strategies for troubleshooting corruption, including a focus on the correct order of activity.
Ditto Ditto Ditto.
Yesterday was fire-fighting day. Today is setting up new alerts day. 825 better not be happening.
February 11, 2011 at 4:13 am
Craig Farrell (2/11/2011)
Anyone else who's seen Full Metal Alchemist, I'm starting to feel like Gluttony. "Can I eat him now?"
But he's special. He has to be kept for the final sacrifice. @=)
Dare I ask why you're feeling that way? Other than you're bored with the Dev job?
February 11, 2011 at 4:53 am
Brandie Tarvin (2/11/2011)
Craig Farrell (2/11/2011)
Anyone else who's seen Full Metal Alchemist, I'm starting to feel like Gluttony. "Can I eat him now?"But he's special. He has to be kept for the final sacrifice. @=)
Dare I ask why you're feeling that way? Other than you're bored with the Dev job?
One word: Nadabadan.
It is very, very difficult for me not to go swinging my Troll-Hammah. You are handling it with much more professionalism and kindness, so I'm just trying to shaddup.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 11, 2011 at 4:57 am
I don't think he's deliberately being a troll. I think he's just being himself.
I'm hoping my last post makes him think about the way he's presenting himself.
February 11, 2011 at 4:59 am
Brandie Tarvin (2/11/2011)
I don't think he's deliberately being a troll. I think he's just being himself.I'm hoping my last post makes him think about the way he's presenting himself.
Godbless and godspeed to that thought. I just want to Gibbs-smack him a few times.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 11, 2011 at 5:40 am
Craig Farrell (2/11/2011)
On another note, it's 2 in the morning and I'm still watching this job go so that I can get a project up to QA in the morning. These are the times I hate dev systems being weak in equipment. Takes for frickin' ever for large scale data movement.
I'm going to be spending part of the weekend cutting down a prod database for restore in dev, on my laptop. There's not enough space in dev to restore the full prod database (300 GB), no space on any other server I can use, and quite honestly no support from management for doing this. The dev environment is easily 6 months out of date and management's response to that is 'Yes? So?'
No prizes for guessing who this is for...
On the plus side, had a very promising meeting this morning,....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 11, 2011 at 5:51 am
GilaMonster (2/11/2011)
I'm going to be spending part of the weekend cutting down a prod database for restore in dev, on my laptop. There's not enough space in dev to restore the full prod database...
Which leads me to ask the question that will get me lynched by y'all.
How many people have told you just shrink the database, then back it up and restore from that? And what was your response?
(BTW, glad you had a productive meeting this morning.)
February 11, 2011 at 6:18 am
Brandie Tarvin (2/11/2011)
GilaMonster (2/11/2011)
I'm going to be spending part of the weekend cutting down a prod database for restore in dev, on my laptop. There's not enough space in dev to restore the full prod database...Which leads me to ask the question that will get me lynched by y'all.
How many people have told you just shrink the database, then back it up and restore from that? And what was your response?
(BTW, glad you had a productive meeting this morning.)
I once had a manager ask if we could just use a "compressed backup" for that. He'd heard of them, but had no clue what that actually meant, except it was smaller.
- 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
February 11, 2011 at 6:23 am
Given how many times I've seen that idea on the forums, and other places, I think it's time to add a variation of it to my interview questions list. If nothing else, it'll give me an idea of how much the interviewee actually knows about backup, recovery, and database files.
February 11, 2011 at 6:32 am
I don't mind pointing out that Red Gate has a tool that can help with this. It's called SQL Storage Compress.
And before you guys start throwing heavy blunt objects at me, notice, no link. I'm just saying is all.
By the way, internally they refer to that software as SSC. It confuses the heck out of me, "Why does SSC need compression? Have we been bad?"
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 11, 2011 at 6:45 am
did someone mention cheap USB-dr.... :slap:
but .. but .. :slap-again-harder-and-harder:
😉
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 11, 2011 at 7:11 am
Brandie Tarvin (2/11/2011)
GilaMonster (2/11/2011)
I'm going to be spending part of the weekend cutting down a prod database for restore in dev, on my laptop. There's not enough space in dev to restore the full prod database...How many people have told you just shrink the database, then back it up and restore from that? And what was your response?
Considering that the production DB had autoshrink on until last week.....
I need to trim down the transactional tables to get the DB to a size that will fit on dev.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 11, 2011 at 7:14 am
GSquared (2/9/2011)
Craig Farrell (2/8/2011)
*sighs* I've failed sainthood. I leave this gentleman in your hands, he can't even debate well, and my patience is stretching to the unprofessional realms.http://www.sqlservercentral.com/Forums/Topic1059167-145-1.aspx
It's not so bad. He's obviously academic, and he's upset by me being a practical realist. The ad hominem attacks on me are a bit weak, and nothing too noteworthy.
It's a pretty standard mindset and handling. Fits right into the behavior-prediction algorithms I was writing about last week. There are two possible ways he'll respond to my replies to him. I'm curious as to which he'll do (assuming he's still paying attention to that thread).
And, yes, he responded with one of the two ways I was expecting. Not the one I was hoping for, though.
I've sent him an off-line message asking if we can sort this out less publically. More professional to do that.
He's reading my post about possible reasons for the question as being antagonistic, which wasn't my intent. He's reading my reference to pointing people to my posts on this site as arrogant, which again is a misunderstanding.
If I can get him to stop "reading between the lines" and start "reading the lines themselves", it'll sort out.
I'll let you know how it goes, if it does.
In the meantime, I'll ask that we all stop trying to take him to task over it. It'll just add fuel to the fire. He's already upset because of simply misreading something, won't help to add to it.
- 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
February 11, 2011 at 7:15 am
Grant Fritchey (2/11/2011)
I don't mind pointing out that Red Gate has a tool that can help with this. It's called SQL Storage Compress.
Great, if the client was willing to pay for a licence for it. Which, since they don't currently see the value in me even updating the dev databases to match production, I highly doubt.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 15 posts - 23,896 through 23,910 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply