January 28, 2019 at 1:22 am
TomThomson - Saturday, January 26, 2019 6:57 PMrodjkidd - Thursday, January 24, 2019 8:28 AMIs it too early to mention SQL Bits?
Who from the Thread are attending?
...
Cheers,Rodders...
I would have attended, but looking after my Ann took priority again this year, so I needed to be not far away from her where she has for years had to live in the winter because Britain is, according to her doctors, too cold (buying a place in Lanzarote for her to live in during winter has given her an extra 13.5 years of not being totally bed-ridden compared to the doctors' predictions 15 years ago if she was going to spend her winters in the UK).
But now things have gone wrong. If I'd known what would happen, perhaps I could have come to SQL Bits - she died in the main hospital in Arrecife on Sunday 13 January this year, and so she doesn't need me to look after her day by day any more.
So I've had her body brought home to be buried where she wanted. Then, as she would never make a will, I have to sort out her estate in Britain and seperately sort out her estate in Spain (radically different laws) so that our childen don't have to cope with that bureaucracy ( and I shall write the neccessary English and Spanish wills to ensure they aren't stuck with that when I die). But sorting out that bureaucracy is not urgent (I hope).
And I have to sort out myself and accept that I've lost her, but I dont know if I can cope with that.
So very sorry for your loss Tom.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
January 28, 2019 at 2:18 am
ChrisM@Work - Monday, January 28, 2019 1:22 AMTomThomson - Saturday, January 26, 2019 6:57 PMrodjkidd - Thursday, January 24, 2019 8:28 AMIs it too early to mention SQL Bits?
Who from the Thread are attending?
...
Cheers,Rodders...
I would have attended, but looking after my Ann took priority again this year, so I needed to be not far away from her where she has for years had to live in the winter because Britain is, according to her doctors, too cold (buying a place in Lanzarote for her to live in during winter has given her an extra 13.5 years of not being totally bed-ridden compared to the doctors' predictions 15 years ago if she was going to spend her winters in the UK).
But now things have gone wrong. If I'd known what would happen, perhaps I could have come to SQL Bits - she died in the main hospital in Arrecife on Sunday 13 January this year, and so she doesn't need me to look after her day by day any more.
So I've had her body brought home to be buried where she wanted. Then, as she would never make a will, I have to sort out her estate in Britain and seperately sort out her estate in Spain (radically different laws) so that our childen don't have to cope with that bureaucracy ( and I shall write the neccessary English and Spanish wills to ensure they aren't stuck with that when I die). But sorting out that bureaucracy is not urgent (I hope).
And I have to sort out myself and accept that I've lost her, but I dont know if I can cope with that.So very sorry for your loss Tom.
Tom,
Sorry to hear about Anne. My condolences.
Rodney
January 28, 2019 at 5:53 am
TomThomson - Saturday, January 26, 2019 6:57 PMI would have attended, but looking after my Ann took priority again this year, so I needed to be not far away from her where she has for years had to live in the winter because Britain is, according to her doctors, too cold (buying a place in Lanzarote for her to live in during winter has given her an extra 13.5 years of not being totally bed-ridden compared to the doctors' predictions 15 years ago if she was going to spend her winters in the UK).
But now things have gone wrong. If I'd known what would happen, perhaps I could have come to SQL Bits - she died in the main hospital in Arrecife on Sunday 13 January this year, and so she doesn't need me to look after her day by day any more.
So I've had her body brought home to be buried where she wanted. Then, as she would never make a will, I have to sort out her estate in Britain and seperately sort out her estate in Spain (radically different laws) so that our childen don't have to cope with that bureaucracy ( and I shall write the neccessary English and Spanish wills to ensure they aren't stuck with that when I die). But sorting out that bureaucracy is not urgent (I hope).
And I have to sort out myself and accept that I've lost her, but I dont know if I can cope with that.
Truly sorry for your loss. I can only imagine what you're going through.
"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
January 28, 2019 at 6:04 am
TomThomson - Saturday, January 26, 2019 6:57 PMrodjkidd - Thursday, January 24, 2019 8:28 AMIs it too early to mention SQL Bits?
Who from the Thread are attending?
...
Cheers,Rodders...
I would have attended, but looking after my Ann took priority again this year, so I needed to be not far away from her where she has for years had to live in the winter because Britain is, according to her doctors, too cold (buying a place in Lanzarote for her to live in during winter has given her an extra 13.5 years of not being totally bed-ridden compared to the doctors' predictions 15 years ago if she was going to spend her winters in the UK).
But now things have gone wrong. If I'd known what would happen, perhaps I could have come to SQL Bits - she died in the main hospital in Arrecife on Sunday 13 January this year, and so she doesn't need me to look after her day by day any more.
So I've had her body brought home to be buried where she wanted. Then, as she would never make a will, I have to sort out her estate in Britain and seperately sort out her estate in Spain (radically different laws) so that our childen don't have to cope with that bureaucracy ( and I shall write the neccessary English and Spanish wills to ensure they aren't stuck with that when I die). But sorting out that bureaucracy is not urgent (I hope).
And I have to sort out myself and accept that I've lost her, but I dont know if I can cope with that.
Man, that's rough. Sorry for your loss and I wish you the strength to learn to cope. I hope you have a lot of people around you who are there for you when you need someone.
January 28, 2019 at 1:47 pm
TomThomson - Saturday, January 26, 2019 6:57 PMrodjkidd - Thursday, January 24, 2019 8:28 AMIs it too early to mention SQL Bits?
Who from the Thread are attending?
...
Cheers,Rodders...
I would have attended, but looking after my Ann took priority again this year, so I needed to be not far away from her where she has for years had to live in the winter because Britain is, according to her doctors, too cold (buying a place in Lanzarote for her to live in during winter has given her an extra 13.5 years of not being totally bed-ridden compared to the doctors' predictions 15 years ago if she was going to spend her winters in the UK).
But now things have gone wrong. If I'd known what would happen, perhaps I could have come to SQL Bits - she died in the main hospital in Arrecife on Sunday 13 January this year, and so she doesn't need me to look after her day by day any more.
So I've had her body brought home to be buried where she wanted. Then, as she would never make a will, I have to sort out her estate in Britain and seperately sort out her estate in Spain (radically different laws) so that our childen don't have to cope with that bureaucracy ( and I shall write the neccessary English and Spanish wills to ensure they aren't stuck with that when I die). But sorting out that bureaucracy is not urgent (I hope).
And I have to sort out myself and accept that I've lost her, but I dont know if I can cope with that.
I'm very sorry to hear about your loss, Tom. I hope you find the strength to deal with it, but I know what you mean...I don't know if I could.
January 28, 2019 at 2:13 pm
TomThomson - Saturday, January 26, 2019 6:57 PMrodjkidd - Thursday, January 24, 2019 8:28 AMIs it too early to mention SQL Bits?
Who from the Thread are attending?
...
Cheers,Rodders...
I would have attended, but looking after my Ann took priority again this year, so I needed to be not far away from her where she has for years had to live in the winter because Britain is, according to her doctors, too cold (buying a place in Lanzarote for her to live in during winter has given her an extra 13.5 years of not being totally bed-ridden compared to the doctors' predictions 15 years ago if she was going to spend her winters in the UK).
But now things have gone wrong. If I'd known what would happen, perhaps I could have come to SQL Bits - she died in the main hospital in Arrecife on Sunday 13 January this year, and so she doesn't need me to look after her day by day any more.
So I've had her body brought home to be buried where she wanted. Then, as she would never make a will, I have to sort out her estate in Britain and seperately sort out her estate in Spain (radically different laws) so that our childen don't have to cope with that bureaucracy ( and I shall write the neccessary English and Spanish wills to ensure they aren't stuck with that when I die). But sorting out that bureaucracy is not urgent (I hope).
And I have to sort out myself and accept that I've lost her, but I dont know if I can cope with that.
So sorry to hear about your loss Tom. Strength and healing my friend!!
_______________________________________________________________
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/
January 28, 2019 at 3:37 pm
TomThomson - Saturday, January 26, 2019 6:57 PMAnd I have to sort out myself and accept that I've lost her, but I dont know if I can cope with that.
My condolences, Tom. Sorry for your loss and hope you have lots of wonderful memories.
January 31, 2019 at 2:03 am
TomThomson - Saturday, January 26, 2019 6:57 PMI would have attended, but looking after my Ann took priority again this year, so I needed to be not far away from her where she has for years had to live in the winter because Britain is, according to her doctors, too cold (buying a place in Lanzarote for her to live in during winter has given her an extra 13.5 years of not being totally bed-ridden compared to the doctors' predictions 15 years ago if she was going to spend her winters in the UK).
But now things have gone wrong. If I'd known what would happen, perhaps I could have come to SQL Bits - she died in the main hospital in Arrecife on Sunday 13 January this year, and so she doesn't need me to look after her day by day any more.
So I've had her body brought home to be buried where she wanted. Then, as she would never make a will, I have to sort out her estate in Britain and seperately sort out her estate in Spain (radically different laws) so that our childen don't have to cope with that bureaucracy ( and I shall write the neccessary English and Spanish wills to ensure they aren't stuck with that when I die). But sorting out that bureaucracy is not urgent (I hope).
And I have to sort out myself and accept that I've lost her, but I dont know if I can cope with that.
Really sorry to hear Tom. Sorting yourself out, and family, is by far top priority and I hope that you do have the support and friendships you need. I'm sure you already know (just by the posts here) that you have the support and wishes of us here at SSC.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 31, 2019 at 5:50 am
January 31, 2019 at 12:11 pm
jasona.work - Thursday, January 31, 2019 5:50 AM
Thanks for posting this, Jason. I always appreciate reading about such things.
January 31, 2019 at 12:36 pm
Ed Wagner - Thursday, January 31, 2019 12:11 PMjasona.work - Thursday, January 31, 2019 5:50 AMThanks for posting this, Jason. I always appreciate reading about such things.
As ammo to tell the higher-ups "don't do this!"
:hehe:
January 31, 2019 at 12:49 pm
jasona.work - Thursday, January 31, 2019 12:36 PMAs ammo to tell the higher-ups "don't do this!"
:hehe:
Exactly. You hit the nail on the head. 😉
January 31, 2019 at 1:30 pm
Ed Wagner - Thursday, January 31, 2019 12:49 PMExactly. You hit the nail on the head. 😉
Seriously? They lost five minutes on a few databases. I would be hard pressed to say the same about the servers I used to manage. I'm sure many of us would be. I know a lots of people are down on "the cloud" and yet put their data into hosted providers. What the heck is that but someone else's data center. Same thing.
Going into this stuff eyes wide open? Sure. Actively resisting just because? Nope.
"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
January 31, 2019 at 1:46 pm
Grant Fritchey - Thursday, January 31, 2019 1:30 PMSeriously? They lost five minutes on a few databases. I would be hard pressed to say the same about the servers I used to manage. I'm sure many of us would be. I know a lots of people are down on "the cloud" and yet put their data into hosted providers. What the heck is that but someone else's data center. Same thing.
Going into this stuff eyes wide open? Sure. Actively resisting just because? Nope.
To be fair, how big of an impact this would have, obviously would depend on your system.
The systems I manage? 5 minutes lost? Did anyone notice, probably only because they got a warning from their front end...
Heck, a couple of the applications that use my servers for databases would keep chugging along doing their thing during the outage and writing the data when it's back up.
Now, if you're talking some busy online retailer or the like, 5 minutes could be a couple hundred grand in lost revenue and becomes a big thing, but not, I would think, a RGE for the DBA (after all, the DBA wasn't the one that dropped the DBs)
And, really, for me, this wouldn't be a "nope, not going cloud, nope, nope nope" thing, it was a one-off (so far.)
January 31, 2019 at 2:08 pm
Viewing 15 posts - 63,061 through 63,075 (of 66,547 total)
You must be logged in to reply to this topic. Login to reply