August 15, 2013 at 2:13 pm
Jan Van der Eecken (8/15/2013)
jasona.work (8/15/2013)
In this case, the DB that was going to Prod is being "re-purposed." The one on Prod I was to restore over-top (same name and everything) isn't being used, and the Devs had been making their changes to the QA version. I think as for why they're re-using a DB, rather than a new DB, is the bureaucratic hoops required to get a DB created...Friggin red tape. But then again, it was Prod, so I guess it somehow warrants it, even if the DB is unused. One never knows whether there's that one remote client who might in 3 years time require access to that database for obscure reasons. Rules are rules after all. Still doesn't warrant reusing the same database. Just back it up, delete it, then wait for someone to complain. And reclaim the space the old DB held for the new one of course.
Except around here, even QA has red tape to almost the same level as Prod...
August 15, 2013 at 2:20 pm
jasona.work (8/15/2013)
Jan Van der Eecken (8/15/2013)
jasona.work (8/15/2013)
In this case, the DB that was going to Prod is being "re-purposed." The one on Prod I was to restore over-top (same name and everything) isn't being used, and the Devs had been making their changes to the QA version. I think as for why they're re-using a DB, rather than a new DB, is the bureaucratic hoops required to get a DB created...Friggin red tape. But then again, it was Prod, so I guess it somehow warrants it, even if the DB is unused. One never knows whether there's that one remote client who might in 3 years time require access to that database for obscure reasons. Rules are rules after all. Still doesn't warrant reusing the same database. Just back it up, delete it, then wait for someone to complain. And reclaim the space the old DB held for the new one of course.
Except around here, even QA has red tape to almost the same level as Prod...
Same over here, working on a project at THE BANK that Gail was involved in, I mean THE BANK, not the project. π
August 15, 2013 at 7:43 pm
jasona.work (8/14/2013)
Ed Wagner (8/14/2013)
Sean Lange (8/13/2013)
Ed Wagner (8/13/2013)
Congratulations on getting the car. I agree that a picture would be nice...hold the Speedo, please. Be sure to include a picture of the engine. πBe careful how you word this Ed. We do not want him to post a picture of him holding his Speedo anymore than we want one of him wearing it. :sick:
AHHH!!! :blush: This qualifies as one of the biggest "oops" I've ever done. To make it as unambiguous as possible, I'll quote Steve:
you know we can't unsee things, right? Please feel free to post a generic picture the car, without you in it.
Just the car, please.
π
Now for why people *HATE* playing board games with me! RULES LAWYERING!!!
You'l note Steve said without me *in it* In what? In the car? OK, I can post with me *ON* the car!
π
Later today, once I get home, I'll post a couple pics of the car and the motor, sans me...
OK Rules Lawyer. Was "it" referring to the car or to the speedo or to the picture?
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
August 15, 2013 at 8:27 pm
I'm prepping a table, which has gotten kind of large, for partitioning. While I've found some workarounds for it, it seems bloody incredible to me that you cannot rebuild a partitioned index at the partition level in an online fashion. It seriously negates one of the major reasons to do the partitioning to begin with.
Someone opened a CONNECT item on the subject a little over a year ago and, while it is still in an "active" status, only 31 votes have been placed.
If you agree that being able to rebuild a partitioned index at the partition level in an online fashion is important, help spread the word and let's get some votes on this important item. Here's the link to the CONNECT item...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 15, 2013 at 8:41 pm
Jeff Moden (8/15/2013)
I'm prepping a table, which has gotten kind of large, for partitioning. While I've found some workarounds for it, it seems bloody incredible to me that you cannot rebuild a partitioned index at the partition level in an online fashion. It seriously negates one of the major reasons to do the partitioning to begin with.Someone opened a CONNECT item on the subject a little over a year ago and, while it is still in an "active" status, only 31 votes have been placed.
If you agree that being able to rebuild a partitioned index at the partition level in an online fashion is important, help spread the word and let's get some votes on this important item. Here's the link to the CONNECT item...
Now 32 FOR votes
August 15, 2013 at 10:12 pm
Jeff Moden (8/15/2013)
While I've found some workarounds for it, it seems bloody incredible to me that you cannot rebuild a partitioned index at the partition level in an online fashion.
Online single partition index rebuild is present in SQL Server 2014 CTP 1.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
August 16, 2013 at 5:09 am
Paul White (8/15/2013)
Jeff Moden (8/15/2013)
While I've found some workarounds for it, it seems bloody incredible to me that you cannot rebuild a partitioned index at the partition level in an online fashion.Online single partition index rebuild is present in SQL Server 2014 CTP 1.
I was just going to look that up because I thought it was one of the upgrades in 2014. Thanks.
"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
August 16, 2013 at 6:00 am
SQLRNNR (8/15/2013)
jasona.work (8/14/2013)
Ed Wagner (8/14/2013)
Sean Lange (8/13/2013)
Ed Wagner (8/13/2013)
Congratulations on getting the car. I agree that a picture would be nice...hold the Speedo, please. Be sure to include a picture of the engine. πBe careful how you word this Ed. We do not want him to post a picture of him holding his Speedo anymore than we want one of him wearing it. :sick:
AHHH!!! :blush: This qualifies as one of the biggest "oops" I've ever done. To make it as unambiguous as possible, I'll quote Steve:
you know we can't unsee things, right? Please feel free to post a generic picture the car, without you in it.
Just the car, please.
π
Now for why people *HATE* playing board games with me! RULES LAWYERING!!!
You'l note Steve said without me *in it* In what? In the car? OK, I can post with me *ON* the car!
π
Later today, once I get home, I'll post a couple pics of the car and the motor, sans me...
OK Rules Lawyer. Was "it" referring to the car or to the speedo or to the picture?
Based on the format of the sentence, and the comma placement:
Please feel free to post a generic picture the car, without you in it.
"It" is referring to the car. There's no mention of the speedo anywhere. Now, if he had written:
Please feel free to post a generic picture the car, without you in the picture.
Or
Please feel free to post a generic picture the car, and if you're going to be in the picture, be appropriately dressed.
We wouldn't be having this discussion, and at worst, you'd get a picture of the car with me perhaps going either hipster (skinny jeans, flannel shirt, socks and sandals) or "bro" mode (skintight t-shirt, jeans, and slicked back hair.)
:hehe:
August 16, 2013 at 6:04 am
Grant Fritchey (8/16/2013)
I was just going to look that up because I thought it was one of the upgrades in 2014. Thanks.
No worries π
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
August 16, 2013 at 6:58 am
jasona.work (8/16/2013)
SQLRNNR (8/15/2013)
jasona.work (8/14/2013)
Ed Wagner (8/14/2013)
Sean Lange (8/13/2013)
Ed Wagner (8/13/2013)
Congratulations on getting the car. I agree that a picture would be nice...hold the Speedo, please. Be sure to include a picture of the engine. πBe careful how you word this Ed. We do not want him to post a picture of him holding his Speedo anymore than we want one of him wearing it. :sick:
AHHH!!! :blush: This qualifies as one of the biggest "oops" I've ever done. To make it as unambiguous as possible, I'll quote Steve:
you know we can't unsee things, right? Please feel free to post a generic picture the car, without you in it.
Just the car, please.
π
Now for why people *HATE* playing board games with me! RULES LAWYERING!!!
You'l note Steve said without me *in it* In what? In the car? OK, I can post with me *ON* the car!
π
Later today, once I get home, I'll post a couple pics of the car and the motor, sans me...
OK Rules Lawyer. Was "it" referring to the car or to the speedo or to the picture?
Based on the format of the sentence, and the comma placement:
Please feel free to post a generic picture the car, without you in it.
"It" is referring to the car. There's no mention of the speedo anywhere. Now, if he had written:
Please feel free to post a generic picture the car, without you in the picture.
Or
Please feel free to post a generic picture the car, and if you're going to be in the picture, be appropriately dressed.
We wouldn't be having this discussion, and at worst, you'd get a picture of the car with me perhaps going either hipster (skinny jeans, flannel shirt, socks and sandals) or "bro" mode (skintight t-shirt, jeans, and slicked back hair.)
:hehe:
Skip the lawyering, where's the picture of the car?
August 16, 2013 at 7:02 am
jasona.work (8/16/2013)
SQLRNNR (8/15/2013)
jasona.work (8/14/2013)
Ed Wagner (8/14/2013)
Sean Lange (8/13/2013)
Ed Wagner (8/13/2013)
Congratulations on getting the car. I agree that a picture would be nice...hold the Speedo, please. Be sure to include a picture of the engine. πBe careful how you word this Ed. We do not want him to post a picture of him holding his Speedo anymore than we want one of him wearing it. :sick:
AHHH!!! :blush: This qualifies as one of the biggest "oops" I've ever done. To make it as unambiguous as possible, I'll quote Steve:
you know we can't unsee things, right? Please feel free to post a generic picture the car, without you in it.
Just the car, please.
π
Now for why people *HATE* playing board games with me! RULES LAWYERING!!!
You'l note Steve said without me *in it* In what? In the car? OK, I can post with me *ON* the car!
π
Later today, once I get home, I'll post a couple pics of the car and the motor, sans me...
OK Rules Lawyer. Was "it" referring to the car or to the speedo or to the picture?
Based on the format of the sentence, and the comma placement:
Please feel free to post a generic picture the car, without you in it.
"It" is referring to the car. There's no mention of the speedo anywhere. Now, if he had written:
Please feel free to post a generic picture the car, without you in the picture.
Or
Please feel free to post a generic picture the car, and if you're going to be in the picture, be appropriately dressed.
We wouldn't be having this discussion, and at worst, you'd get a picture of the car with me perhaps going either hipster (skinny jeans, flannel shirt, socks and sandals) or "bro" mode (skintight t-shirt, jeans, and slicked back hair.)
:hehe:
You forgot that hipster includes those skinny jeans revealing at least 90% of your undergarments. And since a speedo was already mentioned, we'll assume that to be the undergarment of choice which leads to a 100% display of undergarment in hipster mode.
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
August 16, 2013 at 8:29 am
Ed Wagner (8/16/2013)
Skip the lawyering, where's the picture of the car?
Um, I keep forgetting to take a decent pic...
π
August 16, 2013 at 8:34 am
jasona.work (8/16/2013)
Ed Wagner (8/16/2013)
Skip the lawyering, where's the picture of the car?Um, I keep forgetting to take a decent pic...
π
Too busy taking those indecent pics?
--------------------------------------
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
August 16, 2013 at 9:12 am
Stefan Krzywicki (8/16/2013)
jasona.work (8/16/2013)
Ed Wagner (8/16/2013)
Skip the lawyering, where's the picture of the car?Um, I keep forgetting to take a decent pic...
π
Too busy taking those indecent pics?
/Insert 70s' p0rn music here
Um, no?
:hehe:
August 16, 2013 at 10:55 am
jasona.work (8/16/2013)
Stefan Krzywicki (8/16/2013)
jasona.work (8/16/2013)
Ed Wagner (8/16/2013)
Skip the lawyering, where's the picture of the car?Um, I keep forgetting to take a decent pic...
π
Too busy taking those indecent pics?
/Insert 70s' p0rn music here
Um, no?
:hehe:
Bow chicka wah wah!
π
Jason Wolfkill
Viewing 15 posts - 40,951 through 40,965 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply