October 5, 2010 at 11:07 am
GilaMonster (10/4/2010)
For your monday evening entertainment: http://www.sqlservercentral.com/Forums/Topic997896-357-1.aspxThere are days I just don't want to know...
Is it awful of me that the first thing I think of when I read this article is that this is a disgruntled employee who just managed to perms on production and wants to mess with his employer.
October 5, 2010 at 11:13 am
GilaMonster (10/4/2010)
Craig Farrell (10/4/2010)
Alvin Ramard (10/4/2010)
GilaMonster (10/4/2010)
I'm not sure I got the order of operation there correct. Do you check that it's the correct DB before or after dropping it?The order is not that critical if you have DBCC TimeWarp installed. 😀
I always found the time to check was 'During'. Gave me the most interesting results. 🙂
I'd agree, but the duration for drop database is so short there isn't even time to reflect on the meaning of life.
I've found if you have an SSMS window open on the database in question, you can force the database drop to last quite a while. @=)
It feels just like using DBCC Timewarp.
October 5, 2010 at 11:15 am
GilaMonster (10/5/2010)
And just when I thought the project I'm on couldn't get any worse..We're officially in UAT, though both the front-end dev and I are still developing. Had a meeting with the business users yesterday to demo the half of the system that was working. Business users came up with a long list of changes they want, none of which were in the spec.
I take a look over the list and, of the 4 that impact me, rate 2 as moderate-difficult and 2 as minor, but comment that I can't give a time impact until I've had a chance to analyse a bit better. The front end dev rates 1 as medium, estimating a week's work, and the rest as minor
This morning, in project meeting, project manager announces that we will be implementing all but one of those changes before the original project deadline (2 weeks away)
WT!@#$%$#^*&^^$%???????
Wow - I think I would pull that PM and my boss aside. That is bogus.
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 5, 2010 at 11:16 am
WayneS (10/4/2010)
CirquedeSQLeil (10/4/2010)
I just realized who our drop database OP was. DohHmm. This made me go look at previous posts. Quite interesting...
What did I miss?
October 5, 2010 at 11:24 am
CirquedeSQLeil (10/5/2010)
Wow - I think I would pull that PM and my boss aside. That is bogus.
The PM's boss fully supports him. I'm an external consultant (ie slave), so not in their management structure, so in any conversation I have with their management, I'm automatically wrong.
That said, I suspect there's going to be an interesting email from my MD to the client shortly. He is not happy.
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
October 5, 2010 at 11:24 am
GilaMonster (10/5/2010)
And just when I thought the project I'm on couldn't get any worse..We're officially in UAT, though both the front-end dev and I are still developing. Had a meeting with the business users yesterday to demo the half of the system that was working. Business users came up with a long list of changes they want, none of which were in the spec.
I take a look over the list and, of the 4 that impact me, rate 2 as moderate-difficult and 2 as minor, but comment that I can't give a time impact until I've had a chance to analyse a bit better. The front end dev rates 1 as medium, estimating a week's work, and the rest as minor
This morning, in project meeting, project manager announces that we will be implementing all but one of those changes before the original project deadline (2 weeks away)
WT!@#$%$#^*&^^$%???????
That is several kinds of messed up. Sorry to hear it. That kind of frustration makes the normal frustrations associated with this business seem that much worse.
"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
October 5, 2010 at 11:26 am
GilaMonster (10/5/2010)
CirquedeSQLeil (10/5/2010)
Wow - I think I would pull that PM and my boss aside. That is bogus.The PM's boss fully supports him. I'm an external consultant (ie slave), so not in their management structure, so in any conversation I have with their management, I'm automatically wrong.
That said, I suspect there's going to be an interesting email from my MD to the client shortly. He is not happy.
That's good. My initial reaction after reading that was "Ah, good, so when you go live my 2 week notice will have just expired and you all can have a real good time trying to deal with this tragedy you've decided to implement."
I feel for you, Gail. At least you've got SOME backup.
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
October 5, 2010 at 11:26 am
GilaMonster (10/5/2010)
CirquedeSQLeil (10/5/2010)
Wow - I think I would pull that PM and my boss aside. That is bogus.The PM's boss fully supports him. I'm an external consultant (ie slave), so not in their management structure, so in any conversation I have with their management, I'm automatically wrong.
That said, I suspect there's going to be an interesting email from my MD to the client shortly. He is not happy.
Good - there needs to be something said from your superior.
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 5, 2010 at 11:27 am
Grant Fritchey (10/5/2010)
GilaMonster (10/5/2010)
And just when I thought the project I'm on couldn't get any worse..We're officially in UAT, though both the front-end dev and I are still developing. Had a meeting with the business users yesterday to demo the half of the system that was working. Business users came up with a long list of changes they want, none of which were in the spec.
I take a look over the list and, of the 4 that impact me, rate 2 as moderate-difficult and 2 as minor, but comment that I can't give a time impact until I've had a chance to analyse a bit better. The front end dev rates 1 as medium, estimating a week's work, and the rest as minor
This morning, in project meeting, project manager announces that we will be implementing all but one of those changes before the original project deadline (2 weeks away)
WT!@#$%$#^*&^^$%???????
That is several kinds of messed up. Sorry to hear it. That kind of frustration makes the normal frustrations associated with this business seem that much worse.
I think that is an understatement.
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 5, 2010 at 11:28 am
GilaMonster (10/5/2010)
This morning, in project meeting, project manager announces that we will be implementing all but one of those changes before the original project deadline (2 weeks away)WT!@#$%$#^*&^^$%???????
Look, everyone. Gail's turned into Alice from Dilbert. "Must control Fist of Death..."
(Brandie runs away to hide from Gail now). 😀
October 5, 2010 at 11:31 am
Brandie Tarvin (10/5/2010)
WayneS (10/4/2010)
CirquedeSQLeil (10/4/2010)
I just realized who our drop database OP was. DohHmm. This made me go look at previous posts. Quite interesting...
What did I miss?
This:
GilaMonster (10/4/2010)
For your monday evening entertainment: http://www.sqlservercentral.com/Forums/Topic997896-357-1.aspxThere are days I just don't want to know...
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
October 5, 2010 at 11:46 am
I read the topic. Apparently, I'm not getting the joke about the OP, though.
October 5, 2010 at 11:51 am
Brandie Tarvin (10/5/2010)
I read the topic. Apparently, I'm not getting the joke about the OP, though.
The OP in this case has a long history of asking questions and then asking the same question later. Some people have blacklisted this particular OP - some still try to help.
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 5, 2010 at 12:11 pm
GilaMonster (10/5/2010)
Brandie Tarvin (10/5/2010)
WayneS (10/4/2010)
CirquedeSQLeil (10/4/2010)
I just realized who our drop database OP was. DohHmm. This made me go look at previous posts. Quite interesting...
What did I miss?
This:
GilaMonster (10/4/2010)
For your monday evening entertainment: http://www.sqlservercentral.com/Forums/Topic997896-357-1.aspxThere are days I just don't want to know...
Brandie Tarvin (10/5/2010)
I read the topic. Apparently, I'm not getting the joke about the OP, though.
Brandie - not a joke. Go to the link above, and click the OP name. Select "Find all Members Posts". Then - enjoy the read. As Lynn stated earlier "sounds like a permanent Jr DBA" (slightly paraphrased).
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
October 5, 2010 at 12:16 pm
GilaMonster (10/5/2010)
And just when I thought the project I'm on couldn't get any worse..We're officially in UAT, though both the front-end dev and I are still developing. Had a meeting with the business users yesterday to demo the half of the system that was working. Business users came up with a long list of changes they want, none of which were in the spec.
I take a look over the list and, of the 4 that impact me, rate 2 as moderate-difficult and 2 as minor, but comment that I can't give a time impact until I've had a chance to analyse a bit better. The front end dev rates 1 as medium, estimating a week's work, and the rest as minor
This morning, in project meeting, project manager announces that we will be implementing all but one of those changes before the original project deadline (2 weeks away)
WT!@#$%$#^*&^^$%???????
Gail, I have two thoughts.
First, do your typical outstandingly great job. Then enjoy dreaming over how much you'll be charging them when they want you back for something else. :-D:-D:-D:w00t::w00t::w00t:
Second - do you use the SSMSToolsPack? It has a code snippet feature, where you type in an abbreviation and the predefined code is entered in the code window. It comes with a WTF predefined for use... seems like it would be useful to you today!
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
Viewing 15 posts - 19,876 through 19,890 (of 66,815 total)
You must be logged in to reply to this topic. Login to reply