January 4, 2012 at 8:35 am
Brandie Tarvin (1/4/2012)
Kiara (1/4/2012)
Ninja's_RGR'us (1/4/2012)
Kiara (1/4/2012)
Brandie Tarvin (1/3/2012)
So, skirting the edge of the "no tech speak in The Thread" rule...How is your first week of 2012 shaping up work wise? Are you in firefighting mode with month end / year end stuff? Has it breezed by because everyone's too busy with their own stuff?
Are you starting in on the pile o' projects for 2012? Or are you bored out of your skull because peeps are still on vacation and this is the only break you expect to get for the rest of the year?
I'm halfway between firefighting and pile o' projects.
Just found air... 🙂
The first agreed-on day I could get to move our ERP databases to new hardware was Monday - holidays are useful for that sort of thing. ERP databases moved smoothly, got all the various and sundry connecting systems to happily talk to the new machine.
Life was good.
And then I got to the point where I needed to move the Sharepoint databases.
Databases are easy to move. Convincing Sharepoint to look at a new server? That's another story entirely. Took most of yesterday to resolve it.
All's well that ends well, however, and I managed to clear up a few annoying bits and pieces that I hadn't made time to deal with in the process.
So. Happy New Year a couple of days late, everyone!
Good to hear, welcome to 2013.
ROFL! I will admit - by yesterday morning I was beginning to wonder if I was going to miss the whole year!
Girl, I haven't talked to you since last year! How have things been going during that long time apart? @=)
You're going to have to write up an article about migrating Sharepoint databases for the SQL DBA. In fact, I insist upon it as I might have to do this sometime in the future... Do it. DO IT! @=) (pretty please, sugar on top?)
Girlfriend, you have *got* to be kidding me! You think I ever want to look at that evil mess again, let alone build a test environment and prove to myself that it's actually possible to do without having it blow up on you? :laugh: (Ok, I admit, I had already done that, and thought I had it down. Until I found out that I didn't. :hehe:)
Tell ya what. No promises, since I have a ton of prep work to do for a couple of presentations I'm giving in March, and the deck deadlines are starting to feel way too close. After those are done, if I'm feeling particularly mean to myself, I'll think about it. 🙂
Honestly, after this experience, I probably will build an isolated test environment (my current one is a duplicate of our production environment, and in spite of all my planning things didn't go as planned) and see how many different ways I can break the process. MS has a good tech article on how they suggest you do it, but there are an awful lot of moving parts that can go horribly wrong. And once they do, it gets pretty deep pretty quick.
How's that for a fairly non-committal answer? 😎
-Ki
January 4, 2012 at 9:00 am
Great, so you'll be done by friday 4PM?
L8rs :hehe:
January 4, 2012 at 9:03 am
Ninja's_RGR'us (1/4/2012)
Great, so you'll be done by friday 4PM?L8rs :hehe:
Absolutely.
(Done with something, at least...) :w00t:
-Ki
January 4, 2012 at 9:06 am
Hi guys -- I could use some help here, if one of you has a free moment. Thanks!
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
January 4, 2012 at 9:07 am
Kiara (1/4/2012)
Ninja's_RGR'us (1/4/2012)
Great, so you'll be done by friday 4PM?L8rs :hehe:
Absolutely.
(Done with something, at least...) :w00t:
Awesome, c u tomorrow 🙂
January 4, 2012 at 9:07 am
Ninja's_RGR'us (1/4/2012)
Great, so you'll be done by friday 4PM?L8rs :hehe:
Should be easily possible. Friday 28th December 2012, 4pm PST.
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
January 4, 2012 at 9:09 am
GilaMonster (1/4/2012)
Ninja's_RGR'us (1/4/2012)
Great, so you'll be done by friday 4PM?L8rs :hehe:
Should be easily possible. Friday 28th December 2012, 4pm PST.
By mayan's calendar! yes the incomplete one we're all hearing in the news.
January 4, 2012 at 9:21 am
And here I was thinking you'd be done by 30 Feb 2012. :hehe:
January 4, 2012 at 9:41 am
GilaMonster (1/4/2012)
Ninja's_RGR'us (1/4/2012)
Great, so you'll be done by friday 4PM?L8rs :hehe:
Should be easily possible. Friday 28th December 2012, 4pm PST.
We should adjust that to 4PM Hawaiian instead of Pacific:-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
January 4, 2012 at 9:44 am
SQLRNNR (1/4/2012)
GilaMonster (1/4/2012)
Ninja's_RGR'us (1/4/2012)
Great, so you'll be done by friday 4PM?L8rs :hehe:
Should be easily possible. Friday 28th December 2012, 4pm PST.
We should adjust that to 4PM Hawaiian instead of Pacific:-D
And make sure to complete & deliver the work from those beaches!
Ah nice memories :smooooth:
January 4, 2012 at 10:46 am
Kiara (1/4/2012)
Tell ya what. No promises, since I have a ton of prep work to do for a couple of presentations I'm giving in March, and the deck deadlines are starting to feel way too close. After those are done, if I'm feeling particularly mean to myself, I'll think about it. 🙂...
How's that for a fairly non-committal answer? 😎
So if I give you the super-duper secret admin password to DBCC Timewarp, it'll be the feature article in tomorrow's SSC newsletter, right? @=)
January 4, 2012 at 10:52 am
Brandie Tarvin (1/4/2012)
Kiara (1/4/2012)
Tell ya what. No promises, since I have a ton of prep work to do for a couple of presentations I'm giving in March, and the deck deadlines are starting to feel way too close. After those are done, if I'm feeling particularly mean to myself, I'll think about it. 🙂...
How's that for a fairly non-committal answer? 😎
So if I give you the super-duper secret admin password to DBCC Timewarp, it'll be the feature article in tomorrow's SSC newsletter, right? @=)
For that? You can get me to write almost anything in exchange for *that* password... As long as it comes with a *working* version...
-Ki
January 4, 2012 at 10:55 am
Speaking of articles, I'm getting the urge to write something again (yeah, I know...)
What do you guys want to see an article on? (keep it to backups, database recovery, performance stuff)
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
January 4, 2012 at 10:59 am
GilaMonster (1/4/2012)
Speaking of articles, I'm getting the urge to write something again (yeah, I know...)What do you guys want to see an article on? (keep it to backups, database recovery, performance stuff)
Performance stuff
Like the effect of a clustered index on a table for insertions.
Microsoft says it improves speed, but I think that's not true in certain situations, like if you're always inserting into an empty table.
So maybe an article on when performance improvement standards don't hold true?
--------------------------------------
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
January 4, 2012 at 11:04 am
Stefan Krzywicki (1/4/2012)
Like the effect of a clustered index on a table for insertions.Microsoft says it improves speed, but I think that's not true in certain situations, like if you're always inserting into an empty table.
So maybe an article on when performance improvement standards don't hold true?
Ooof... That's a major benchmark/testing commitment (and to be honest, would need testing couple times on different hardware to be sure)
Inserting one row at a time? Inserting batches (and how big)? Inserting data ordered by the clustered index? Unordered? At the end of the index? At the beginning? In the middle? Randomly? Just empty table? Table with less data than we're inserting? Table with similar size? Table much bigger?
I think if I committed to writing that it would be for Simple Talk (they pay better)
I want to sometime address the 'indexes slow down data modification', but keep putting it off because of the work involved.
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 - 33,121 through 33,135 (of 66,749 total)
You must be logged in to reply to this topic. Login to reply