July 27, 2015 at 2:41 am
Grant, wow looks like you covered quite a lot while you were on holiday. Glad you and the family enjoyed it.
You have given me a list of places to visit/ things I need to do.
Welcome back.
Tom and BrainDonor - it was great to meet you both on Saturday in Manchester. I thought it was a good day overall. A nice addition to the SQL Sat line up. I did like the shirts for the speakers and helpers. Although I need to have words with Chris as to where was mine.
I managed somehow to cover all 30 sessions on the day, and to attend 3. I did want to attend one of the last hours session, but it was a level 400 and by the time I had made my way round the other sessions, I was too far behind. So went back to the exhibitor hall and chilled! Think I got all the winners in the prize draws as well. The Manchester quiz on the Friday night was a good idea. Lucky I ended up on a team with two local experts. Redgate's team was called something like "Not Last", and of course came last 😀
Gave us at Southampton some things to think about 🙂
Apparently I a co-speaker liaison! I wonder why hehe
I woke up Sunday to an email from the Oslo SQL Sat about that one. So fed back how I had got on in Manchester. Luckily there will be two of us covering the photos.
Something like 700 pictures to go through over the next week or so. Started on the train, but the power socket didn't work. So only made it through about 40.
Cheers,
Rodders...
July 27, 2015 at 3:17 am
TomThomson (7/26/2015)
Grant Fritchey (7/26/2015)
Managed to get a fully-loaded station wagon (four people plus bags) all the way up to 120MPH (195KPH) on the Autobahn.Don't get caught at that one in France unless (a) one of the other people in the car can drive and (b) you've got enough cash to pay the fine. The French don't have unlimited speed roads, and 195 kph is in the range where the traffic cop will call your licence details are car plates in to HQ and the licence details will be recorded on their police national database as temporarily (not sure how long at 195 - either 1 month or 3 months) not valid in France - and the cop will not allow you to drive away if you don't have someone else to do it.
edit: I must get around to Charlemagne's bones some day.
No. We stayed at the speed limit everywhere else. I may be stupid but I'm not crazy, or the other way around.
"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
July 27, 2015 at 4:40 am
TomThomson (7/26/2015)
Grant Fritchey (7/26/2015)
Managed to get a fully-loaded station wagon (four people plus bags) all the way up to 120MPH (195KPH) on the Autobahn.Don't get caught at that one in France unless (a) one of the other people in the car can drive and (b) you've got enough cash to pay the fine.
According to what I heard on Top Gear a while back, the French police can charge you whatever they want for a fine. And they usually ask for all the money in your wallet. So apparently you don't want to speed with too much money or you'll lose it all.
July 27, 2015 at 5:35 am
Brandie Tarvin (7/27/2015)
TomThomson (7/26/2015)
Grant Fritchey (7/26/2015)
Managed to get a fully-loaded station wagon (four people plus bags) all the way up to 120MPH (195KPH) on the Autobahn.Don't get caught at that one in France unless (a) one of the other people in the car can drive and (b) you've got enough cash to pay the fine.
According to what I heard on Top Gear a while back, the French police can charge you whatever they want for a fine. And they usually ask for all the money in your wallet. So apparently you don't want to speed with too much money or you'll lose it all.
And you believe what you hear on TG about the French? I'm sure that there are more reliable sources.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
July 27, 2015 at 5:44 am
Phil Parkin (7/27/2015)
Brandie Tarvin (7/27/2015)
TomThomson (7/26/2015)
Grant Fritchey (7/26/2015)
Managed to get a fully-loaded station wagon (four people plus bags) all the way up to 120MPH (195KPH) on the Autobahn.Don't get caught at that one in France unless (a) one of the other people in the car can drive and (b) you've got enough cash to pay the fine.
According to what I heard on Top Gear a while back, the French police can charge you whatever they want for a fine. And they usually ask for all the money in your wallet. So apparently you don't want to speed with too much money or you'll lose it all.
And you believe what you hear on TG about the French? I'm sure that there are more reliable sources.
I read it in the Daily Mail too. It must be true.
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
July 27, 2015 at 5:46 am
So, Saturday I had to do something I really, really didn't want to do, to try to get a situation under control...
(pauses to don fire-fighters bunker gear, then a silver-fire suit over that)
I had to flip a full-recovery model DB in production to Simple, so I could shrink and rationalize the transaction log...
Between a poor growth option (not %, but small steps,) problems backing up the log with a third-party backup application, this log had ~1600 VLFs. Tried backing up the log first (to disk,) but that only let me get it down to ~1/2 it's size (started at ~120GB which for our environment is HUGE,) snagged a second backup with no change, so I went the evil route...
So far, our normally scheduled full backup on Sunday ran no problems, the Diff this morning went OK, and I'm waiting on the backup admin to get in and turn the TLog backups back on...
So, flame away...
And I just realized that until we get a TLog backup, it's in "pseudo simple" mode, ain't it...
July 27, 2015 at 5:52 am
jasona.work (7/27/2015)
And I just realized that until we get a TLog backup, it's in "pseudo simple" mode, ain't it...
No. Until a full or diff runs.
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
July 27, 2015 at 8:51 am
jasona.work (7/27/2015)
And I just realized that until we get a TLog backup, it's in "pseudo simple" mode, ain't it...
Pseudo-simple is a new database in the full recovery model that hasn't had a full backup taken yet. Until that backup occurs, the transaction log behaves as it the database were in the simple recovery model. Once that full backup happens, then the tlog starts saving everything, and growing until a tlog backup occurs.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
July 27, 2015 at 9:04 am
Phil Parkin (7/27/2015)
Brandie Tarvin (7/27/2015)
TomThomson (7/26/2015)
Grant Fritchey (7/26/2015)
Managed to get a fully-loaded station wagon (four people plus bags) all the way up to 120MPH (195KPH) on the Autobahn.Don't get caught at that one in France unless (a) one of the other people in the car can drive and (b) you've got enough cash to pay the fine.
According to what I heard on Top Gear a while back, the French police can charge you whatever they want for a fine. And they usually ask for all the money in your wallet. So apparently you don't want to speed with too much money or you'll lose it all.
And you believe what you hear on TG about the French? I'm sure that there are more reliable sources.
It was a specific rant of Jeremy Clarkson's that got my attention. Definitely not a scripted moment where he was complaining about being cleaned out by the French traffic cops. Usually I take TG with the appropriate grain of salt. But this comment seemed passionately, realistically angry.
Of course, I've never been to France. So I only know what I hear about it in the media.
July 27, 2015 at 9:06 am
Pseudo-simple
Wow. Even on The Thread I am having the learning of the stuff. I've never heard of this until today.
Thanks for bring up the topic, Jason. And hold still, will you? I need to cook some eggs and your suit is the only flame-proof surface available.
July 27, 2015 at 9:39 am
GilaMonster (7/27/2015)
jasona.work (7/27/2015)
And I just realized that until we get a TLog backup, it's in "pseudo simple" mode, ain't it...No. Until a full or diff runs.
Thanks Gail. I knew there was a situation that would cause that, obviously I had it backwards'ish.
Glad though that I pre-sized the TLog big enough to handle the tasks. Problem being, the log backups via the third-party application are *STILL* being a P.I.T.A.
July 27, 2015 at 9:45 am
Brandie Tarvin (7/27/2015)
Pseudo-simple
Wow. Even on The Thread I am having the learning of the stuff. I've never heard of this until today.
Thanks for bring up the topic, Jason. And hold still, will you? I need to cook some eggs and your suit is the only flame-proof surface available.
But it's getting so warm in here!
If you toss on some bacon though, I might be convinced to stand still...
July 27, 2015 at 10:03 am
Brandie Tarvin (7/27/2015)
Pseudo-simple
Wow. Even on The Thread I am having the learning of the stuff. I've never heard of this until today.
Thanks for bring up the topic, Jason. And hold still, will you? I need to cook some eggs and your suit is the only flame-proof surface available.
We love pseudo-simple.
Better yet is that we love when the full is finally taken and then nobody ever bothers to take a tlog backup.
Ever see the model tlog grow to 10+GB? That is another fun one. All because of the tlog backup not being done on that database.:-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
July 27, 2015 at 11:13 am
SQLRNNR (7/27/2015)
Brandie Tarvin (7/27/2015)
Pseudo-simple
Wow. Even on The Thread I am having the learning of the stuff. I've never heard of this until today.
Thanks for bring up the topic, Jason. And hold still, will you? I need to cook some eggs and your suit is the only flame-proof surface available.
We love pseudo-simple.
Better yet is that we love when the full is finally taken and then nobody ever bothers to take a tlog backup.
Ever see the model tlog grow to 10+GB? That is another fun one. All because of the tlog backup not being done on that database.:-D
Why in heaven's name would anyone set their model db to FULL or BULK_LOGGED? With the default set as SIMPLE, one should never have to back up the tlog on the system dbs.
July 27, 2015 at 11:18 am
Brandie Tarvin (7/27/2015)
SQLRNNR (7/27/2015)
Brandie Tarvin (7/27/2015)
Pseudo-simple
Wow. Even on The Thread I am having the learning of the stuff. I've never heard of this until today.
Thanks for bring up the topic, Jason. And hold still, will you? I need to cook some eggs and your suit is the only flame-proof surface available.
We love pseudo-simple.
Better yet is that we love when the full is finally taken and then nobody ever bothers to take a tlog backup.
Ever see the model tlog grow to 10+GB? That is another fun one. All because of the tlog backup not being done on that database.:-D
Why in heaven's name would anyone set their model db to FULL or BULK_LOGGED? With the default set as SIMPLE, one should never have to back up the tlog on the system dbs.
It's just an excuse to say they have work to do.
Viewing 15 posts - 49,666 through 49,680 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply