August 4, 2016 at 5:45 am
Really sorry for a techie question on here but I'm not sure that this is worth a thread of its own.
When calling multiple stored procs from another, they executed consecutively or concurrently?
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
August 4, 2016 at 5:48 am
BWFC (8/4/2016)
Really sorry for a techie question on here but I'm not sure that this is worth a thread of its own.When calling multiple stored procs from another, they executed consecutively or concurrently?
In series.
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
August 4, 2016 at 5:58 am
Phil Parkin (8/4/2016)
BWFC (8/4/2016)
Really sorry for a techie question on here but I'm not sure that this is worth a thread of its own.When calling multiple stored procs from another, they executed consecutively or concurrently?
In series.
Cheers Phil, that's what I thought.
I'd spent days trying to work out why something was horribly slow when all the individual parts were merely not fast. The penny suddenly dropped last night that it was as simple as that.
It was the equivalent of spending hours with the bonnet up only to realise that the car wasn't moving because it didn't have wheels :crazy:
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
August 4, 2016 at 6:24 am
SSIS can run procs in parallel, no problem.
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
August 4, 2016 at 6:38 am
I've just done a bit of testing with that and what was running in six hours, will run in an hour and a half, with no code changes.
It's not up to me though, a many-headed political monster must now be awoken and required to make decisions. At least two of the heads are on holiday until Monday; at which time I'll be in Croatia.
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
August 4, 2016 at 6:48 am
Lynn Pettis (8/3/2016)
Jack Corbett (8/3/2016)
Lynn Pettis (8/3/2016)
Is the code I wrote here really that sophisticated, or is it that I have been doing this so long that for me it is a basic SQL query?I would consider it advanced for most people using SQL Server because you use a CTE, a windowing function, and a case statement (especially since it is within the windowing function). You've combined 3 things that are not beginner or basic level SQL.
Now it is basic for most Threadizens I would guess.
Thanks for the feedback. It just seemed so easy for me as I turned around the code in about 5 minutes.
Very nice solution Lynn, short, concise and straight to the point.
😎
August 4, 2016 at 6:56 am
Phil Parkin (8/4/2016)
SSIS can run procs in parallel, no problem.
Or threading through PowerShell.
"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
August 4, 2016 at 7:14 am
Grant Fritchey (8/4/2016)
Phil Parkin (8/4/2016)
SSIS can run procs in parallel, no problem.Or threading through PowerShell.
That's a bit scary. The many-headed political monster would need an awful lot of persuading to go down that route. I think the answer will be SSIS because we already use it and so does my oppo at the customer.
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
August 4, 2016 at 7:32 am
Grant Fritchey (8/4/2016)
Phil Parkin (8/4/2016)
SSIS can run procs in parallel, no problem.Or threading through PowerShell.
Or async and parallel via Service Broker, if you're feeling very brave.
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
August 4, 2016 at 8:20 am
Eirikur Eiriksson (8/4/2016)
Lynn Pettis (8/3/2016)
Jack Corbett (8/3/2016)
Lynn Pettis (8/3/2016)
Is the code I wrote here really that sophisticated, or is it that I have been doing this so long that for me it is a basic SQL query?I would consider it advanced for most people using SQL Server because you use a CTE, a windowing function, and a case statement (especially since it is within the windowing function). You've combined 3 things that are not beginner or basic level SQL.
Now it is basic for most Threadizens I would guess.
Thanks for the feedback. It just seemed so easy for me as I turned around the code in about 5 minutes.
Very nice solution Lynn, short, concise and straight to the point.
😎
That is a nice solution. I'll have to keep it in mind. Not that I get many chances to use row_number(). Most of the queries I have to write need lots of other things, but none of them have ever needed row_number().
I don't know if that's a function of how screwed up our unplanned database growth was or just because I'm not seeing the opportunities the way I should.
August 4, 2016 at 10:16 am
Grant Fritchey (8/4/2016)
Phil Parkin (8/4/2016)
SSIS can run procs in parallel, no problem.Or threading through PowerShell.
or CLR
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
August 5, 2016 at 4:33 am
I would like to get into the mind-set of speakers out there. Now, as it stands I have zero-interest in presenting/speaking due to a lack of knowledge.
My question is ( for you speakers out there ) when you select a topic to talk about is it something that you know absolutely 100% everything about? Or do you know "enough" to present some material and present it well ? I am just curious...
August 5, 2016 at 5:10 am
BLOB_EATER (8/5/2016)
I would like to get into the mind-set of speakers out there. Now, as it stands I have zero-interest in presenting/speaking due to a lack of knowledge.My question is ( for you speakers out there ) when you select a topic to talk about is it something that you know absolutely 100% everything about? Or do you know "enough" to present some material and present it well ? I am just curious...
When I present, I always select topics that I *like* to talk about. There can be various reasons to like to talk about a topic.
Often because it's a topic that I like. (For instance understanding all the details of execution plans, or understanding how indexes are used in seeks and scans, or understanding the internals of a cool new feature).
Sometimes, because it's a topic that I think is important and that I want people to be more aware of. (For instance understanding how to design a properly normalized database, or how to avoid writing crappy code that doesn't perform).
And sometimes it's because proposing a session forces me to learn more about a topic I already know a lot about. I usually (there have been exceptions) do not propose sessions on subjects I do not know "quite well" already; but I also always find that I learn way more about the topic when preparing the session.
In many cases, the reasons overlap. I typically enjoy talking about a topic if I consider the topic important, and vice versa,
For you the reasons will probably be different. But there is one important factor that I am sure holds true for all speakers: passion. If you are passionate about a topic, then you can do a great presentation even if you do not know everything about the topic. And if you do know everything but do not hav any passion for the topic, then you will almost certainly not do a good job of presenting. Only the best professional actors can fake passion that is not really there; we arer not actors so for us it is important to not have to fake anything. If the passion is real, the audience will notice.
August 5, 2016 at 5:38 am
A thought I had the other day, reading another of Steve's postings on the SQL Saturday thing. Keep in mind, I've been to one, so if this does happen at others, feel free to point and laugh...
What about, when it comes to sessions, having a panel-type session? Bring in several local people to be on the panel, regardless of skill level, and turn them loose to both discuss interesting problems and how they've solved them and take questions from the attendees? Rather similar to what goes on at various other types of conventions (admittedly, I don't think you'd be able to ask a DBA what the best part of working with John Barrowman / Steve Buscemi / Mark Hamil / Margo Robbie was, but...)
By having both seasoned DBAs and newer DBAs, you'd also get a decent discussion with explanations of either why the problem was solved that way, or what a possible better method might be.
Just a random thought...
August 5, 2016 at 5:44 am
So, something completely different!
Movie review of the new Bourne movie (kept short)
Pros: Decent enough typical action movie.
Cons: Oh god the mangling and mis-use of techie! When during a very early scene in the movie someone commented (in subtitles) "we'll corrupt their database with SQL" I had a bad feeling. Which was confirmed about 15 seconds later in the same scene as to just how well they'd done their homework on the tech side of things...
My inner cynic very quickly became my outer cynic at the point when a social-media type company (think Facebook'ish) was claiming they'd have a system where "all your information would remain private" (As a co-worker has told me, if a company is giving something to you for free, you're the product.)
Would I go see it again? Not even if it was on TV for free.
Do I regret the money spent to see it? Nah, it was a night out with the wife, and movie popcorn!
Why does movie theater popcorn seem to taste so much better than when you're at home and make popcorn (excluding actually putting oil in a pan and tossing in the popcorn kernels, I'm talking bagged microwave popcorn, which means I probably just answered my own question, didn't I?)
Viewing 15 posts - 55,201 through 55,215 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply