October 8, 2015 at 2:21 pm
Jack Corbett (10/8/2015)
WayneS (10/7/2015)
GilaMonster (10/6/2015)
#gloat Company's paying for the trip to the US. If I was speaking at Pass Summit, they'd be paying for hotel too. They paid for my trip to the Cape Town and Durban SQLSaturdays, and all days at a conference are considered normal work days.#endgloat
So you'll be at the Summit after all? Nice!
+1 and I believe I owe you a beverage of your choice (that's Gail, not Wayne).
And, if I recall, a long story too...
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
October 8, 2015 at 3:39 pm
GilaMonster (10/8/2015)
Jack Corbett (10/8/2015)
WayneS (10/7/2015)
GilaMonster (10/6/2015)
#gloat Company's paying for the trip to the US. If I was speaking at Pass Summit, they'd be paying for hotel too. They paid for my trip to the Cape Town and Durban SQLSaturdays, and all days at a conference are considered normal work days.#endgloat
So you'll be at the Summit after all? Nice!
+1 and I believe I owe you a beverage of your choice (that's Gail, not Wayne).
And, if I recall, a long story too...
Here's that long stoooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooory.
That about sums it up.
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
October 9, 2015 at 8:02 am
I've just about completed an article for publication on SSC, describing the behaviour of explicit transactions and would appreciate it if a couple of people could cast their eyes over it before Steve just feeds it through a shredder.
It is not a small piece, covering
What is a transaction?
What is an explicit transaction?
Basic BEGIN/COMMIT transaction
IDENTITY columns
@@TRANCOUNT
Stored Procedures and @@TRANCOUNT
Nested transactions
Transaction Names
Savepoints
although it is primarily code listings and screen-shots.
I have yet to write the conclusion. I'm thinking of something along the lines of "Check you really know how much work is involved before you offer to write an article".
October 9, 2015 at 12:47 pm
BrainDonor (10/9/2015)
I've just about completed an article for publication on SSC, describing the behaviour of explicit transactions and would appreciate it if a couple of people could cast their eyes over it before Steve just feeds it through a shredder.
Feel free to send it my way.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
October 10, 2015 at 5:28 am
BrainDonor (10/9/2015)
I've just about completed an article for publication on SSC, describing the behaviour of explicit transactions and would appreciate it if a couple of people could cast their eyes over it before Steve just feeds it through a shredder.
I'll be happy to give you some feedback..
Louis.
October 11, 2015 at 8:41 pm
I see the sports spam has returned. Sigh.
October 12, 2015 at 7:39 am
Eirikur Eiriksson (10/8/2015)
dwain.c (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Oh, and maple beer - yuck.
This made me spill my ESB all over the Pub lunch
π
Where have you found ESB on draught?
The Ale&Pie on High Holborn, next to my office
π
Live 5 minutes from Chiswick so there is no shortage in the locals either.
The Melton Mowbray? Haven't been in there for a while. The nearest gig was a telecoms company in Red Lion Square, maybe 12 years ago. We used to have Friday afternoon meetings in the Dolphin π
Edit: High Holborn is a mile from where I currently work.
Good catch Chris, yes that's the one.
So working only 10 minutes away from each other, where and when are we going to meet?
π
There are two pubs almost opposite each other on Tottenham Court Road about 150 yards up from TCR tube station. One of them's called the Jack Horner. The one on the west side does amazing pies, the one on the east side has exceptional ESB. You choose π
The Rising Sun and Jack Horner, not "too" unfamiliar π
Lets make it Jack Horner, now the question is when?
π
That's them! The Rising Sun has the pies π
Late next week - lunchtime or a couple of pints after work?
Thursday next week, Pie lunch in the Rising Sun, my treat
π
Followed by a pint in the Jack Horner, my treat π
That's a "meal deal" then
π
Please do at least one wrist curl for me as my spirit will be with you!
Done, cheers Dwain!
π
Great meeting up with you Eirikur. I've met a half dozen people from Iceland and they have all been charming and completely bonkers. You're similar - but where the others are RBAR, you're set-based!
Luis Cazares - happy birthday geezer. No idea how but it came up in some feed or other on my phone. Hope you had a great day π
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
October 12, 2015 at 7:56 am
ChrisM@Work (10/12/2015)
Luis Cazares - happy birthday geezer. No idea how but it came up in some feed or other on my phone. Hope you had a great day π
Thank you, Chris. I guess you got that info from my Linkedin profile.
October 12, 2015 at 12:27 pm
ChrisM@Work (10/12/2015)
Great meeting up with you Eirikur. I've met a half dozen people from Iceland and they have all been charming and completely bonkers. You're similar - but where the others are RBAR, you're set-based!
Now you met half the nation, I must introduce you the the rest of us:-D
What was that joke about Dwain again....
Jokes aside, enjoyed our meeting up, must encourage any other local or passing by SSCr's to join us for the next time!
π
October 12, 2015 at 4:54 pm
Ed Wagner (10/11/2015)
I see the sports spam has returned. Sigh.
News clip spam, sports spam, ad spam.
My inbox is littered with SSC forum posts that are just spam (e.g. the Data corruption forum - I just subscribe to the entire forum). It's been steadily getting worse over the past couple of weeks.
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
October 12, 2015 at 6:17 pm
Eirikur Eiriksson (10/12/2015)
ChrisM@Work (10/12/2015)
Great meeting up with you Eirikur. I've met a half dozen people from Iceland and they have all been charming and completely bonkers. You're similar - but where the others are RBAR, you're set-based!Now you met half the nation, I must introduce you the the rest of us:-D
What was that joke about Dwain again....
Jokes aside, enjoyed our meeting up, must encourage any other local or passing by SSCr's to join us for the next time!
π
Not the old knock-knock joke I hope!
Knock-knock. Who's there? Dwain. Dwain who?
Dwain the bathtub I'm dwowning!
Glad to hear you guys hooked up and had a good time. Sorry I couldn't be there.
My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.
Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St
October 13, 2015 at 4:07 am
HELP!!!!!!!!!!!!!!!!!
I am trapped by a cat who thinks hands were made for scratching, not for working. Every time I reach for the keyboard, I get chomped!
(this message brought to you by the one-handed dba.)
October 13, 2015 at 4:09 am
Put the keyboard down, pet the cat. Priorities!
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
October 13, 2015 at 4:16 am
GilaMonster (10/13/2015)
Put the keyboard down, pet the cat. Priorities!
Now she's hissing at me because I made the mistake of trying to move my other hand to the keyboard. And now she's off the lap and chewing cables to show how unhappy she is.
Sigh. I can't do anything right today.
Good news is that I got my Samsung Evo 1TB SSD the other day. Bad news is that I can't seem to get my Windows 7 Business 32 bit cloned to it for some reason. The drive just doesn't like me. Samsung magician doesn't want to recognize it from an external housing, which means I can't check for a firmware update to see if that will help.
POUT.
October 13, 2015 at 4:54 am
Luis Cazares (10/12/2015)
ChrisM@Work (10/12/2015)
Luis Cazares - happy birthday geezer. No idea how but it came up in some feed or other on my phone. Hope you had a great day πThank you, Chris. I guess you got that info from my Linkedin profile.
Happy Birthday, Luis. BTW, I don't think you qualify as a geezer just yet. π
Viewing 15 posts - 50,971 through 50,985 (of 66,738 total)
You must be logged in to reply to this topic. Login to reply