May 24, 2016 at 9:09 am
Brandie Tarvin (5/24/2016)
Lynn Pettis (5/24/2016)
Grumpy DBA (5/24/2016)
The "Thanks for the script" guy strikes again, necro'ing several old, dead threads.I refer to him as PP.
Thanks for the post. @=)
Thanks for the thanks for the post. 😉
May 24, 2016 at 9:10 am
Ed Wagner (5/24/2016)
Brandie Tarvin (5/24/2016)
Lynn Pettis (5/24/2016)
Grumpy DBA (5/24/2016)
The "Thanks for the script" guy strikes again, necro'ing several old, dead threads.I refer to him as PP.
Thanks for the post. @=)
Thanks for the thanks for the post. 😉
:unsure:
May 24, 2016 at 3:56 pm
Grant Fritchey (5/24/2016)
Thrilling stuff Steve. Congrats!My two are graduating high school tomorrow (and turning 18 on the same day, **** I'm old).
Especially if you consider that you waited to start having those kids until you were well into your 40's.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
May 24, 2016 at 8:01 pm
WayneS (5/24/2016)
Grant Fritchey (5/24/2016)
Thrilling stuff Steve. Congrats!My two are graduating high school tomorrow (and turning 18 on the same day, **** I'm old).
Especially if you consider that you waited to start having those kids until you were well into your 40's.
And here I thought we were friends.
"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
May 25, 2016 at 5:45 am
Just testing to see if my problems replying are just work related, or related to trying to post a script...
May 25, 2016 at 5:49 am
jasona.work (5/25/2016)
Just testing to see if my problems replying are just work related, or related to trying to post a script...
Looks like if I try to post SQL code...
SELECT @@VERSION
May 25, 2016 at 6:59 am
So, I'm working on getting a new server setup, doing the initial migration of the customer DBs to the server, and I found myself wondering...
Does anyone, when they're doing something similar (backup / copy / restore) do the restores in such a way that if you select your databases by name or by database_id, they're in the same order?
Or is that to OCD even for most of us?
May 25, 2016 at 7:04 am
jasona.work (5/25/2016)
So, I'm working on getting a new server setup, doing the initial migration of the customer DBs to the server, and I found myself wondering...Does anyone, when they're doing something similar (backup / copy / restore) do the restores in such a way that if you select your databases by name or by database_id, they're in the same order?
Or is that to OCD even for most of us?
Can you imagine the breakages that would ensue when a new database had to be added to the server, and the DBA was compelled to reorder again?
Thomas Rushton
blog: https://thelonedba.wordpress.com
May 25, 2016 at 7:23 am
^ Would that cause a DBA split?
May 25, 2016 at 7:24 am
jasona.work (5/25/2016)
So, I'm working on getting a new server setup, doing the initial migration of the customer DBs to the server, and I found myself wondering...Does anyone, when they're doing something similar (backup / copy / restore) do the restores in such a way that if you select your databases by name or by database_id, they're in the same order?
Or is that to OCD even for most of us?
I consider myself to be quite CDO (OCD in proper, alphabetic order). But that goes too far even for me.
Why would you ever care about DB_ID()? Do you have anything that hardcodes the DB_ID values?
May 25, 2016 at 7:39 am
Hugo Kornelis (5/25/2016)
jasona.work (5/25/2016)
So, I'm working on getting a new server setup, doing the initial migration of the customer DBs to the server, and I found myself wondering...Does anyone, when they're doing something similar (backup / copy / restore) do the restores in such a way that if you select your databases by name or by database_id, they're in the same order?
Or is that to OCD even for most of us?
I consider myself to be quite CDO (OCD in proper, alphabetic order). But that goes too far even for me.
Why would you ever care about DB_ID()? Do you have anything that hardcodes the DB_ID values?
Thankfully, no, there's nothing that has a hardcoded DB_ID()...
It just bugs me when I select against sys.databases, forget to order by name, and the list is all out of alphabetical order...
Just not enough to get me to do something like I suggested.
:hehe:
May 25, 2016 at 8:02 am
ThomasRushton (5/25/2016)
jasona.work (5/25/2016)
So, I'm working on getting a new server setup, doing the initial migration of the customer DBs to the server, and I found myself wondering...Does anyone, when they're doing something similar (backup / copy / restore) do the restores in such a way that if you select your databases by name or by database_id, they're in the same order?
Or is that to OCD even for most of us?
Can you imagine the breakages that would ensue when a new database had to be added to the server, and the DBA was compelled to reorder again?
It's not OCD. It was probably because they did a migration before and they did the restores in alphabetical order. I just did such a migration and I sorted by DB name so that it was easier to monitor the feedback so I could tell where in the process of restoring that we were.
--Jeff Moden
Change is inevitable... Change for the better is not.
May 25, 2016 at 8:14 am
Grant Fritchey (5/24/2016)
Sean Lange (5/23/2016)
Jack Corbett (5/23/2016)
Sean Lange (5/20/2016)
GilaMonster (5/20/2016)
Ed Wagner (5/20/2016)
ON the SQL Saturday topic, the rumor is that a Detroit one will hopefully be scheduled for February 2017. I hope you can make it.And further on the SQLSaturday topic, who's joining me in Iceland next month?
Gosh that sounds awesome. We are going on a family driving vacation around the East coast for a week. Not quite the same but should be lots of fun.
Where on the East coast? I'm on the northeast coast (NH) and if you are going to be close it would be cool to meet up.
My nephew is graduating high school so we are starting in Rochester. From there we are going to Fort Ticonderoga, Sturbridge Village, Boston. Depending on time (and family energy) we may try to take a day and drive up to Maine. I can let you know as the time gets a little closer what our final plans are. Would be great to meet up if only for a bite to eat or a quick beer.
We're supporting members of Sturbridge Village and my daughter volunteered there, in full garb, for two years. To get the most out of the visit, make sure you talk to the people there. They have tons and tons of information about the village itself and the time period. Most of the love to share. My favorite installation is the cooper, but they're very seldom working. Make sure you see the sawmill in action. I love that.
I was there for a couple days a LONG time ago. I was around 10 or so at the time. I remember it but all of the details have faded after this many years. As a woodworker the sawmill is near the top of my required stops. That and the candlemaker, I find that fascinating.
If you are out in the area we should get together and break bread (or maybe just a beer).
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
May 25, 2016 at 8:38 am
Jeff Moden (5/25/2016)
ThomasRushton (5/25/2016)
jasona.work (5/25/2016)
So, I'm working on getting a new server setup, doing the initial migration of the customer DBs to the server, and I found myself wondering...Does anyone, when they're doing something similar (backup / copy / restore) do the restores in such a way that if you select your databases by name or by database_id, they're in the same order?
Or is that to OCD even for most of us?
Can you imagine the breakages that would ensue when a new database had to be added to the server, and the DBA was compelled to reorder again?
It's not OCD. It was probably because they did a migration before and they did the restores in alphabetical order. I just did such a migration and I sorted by DB name so that it was easier to monitor the feedback so I could tell where in the process of restoring that we were.
I agree - it's consistency. My backups are done in a specific order, as are consistency checks and database maintenance.
May 25, 2016 at 8:39 am
Grumpy DBA (5/25/2016)
^ Would that cause a DBA split?
If it does, would it be fully logged? I'd hate to see the log file of what I do it a day - talk about fragmentation. 😛
What if it is and the DBA queries the log? If he reads it up to the point where he's reading what he's doing now, would it invoke DBCC TIMEWARP under the hood to determine what he's going to do next?
Viewing 15 posts - 54,286 through 54,300 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply