November 3, 2011 at 12:14 pm
Stefan Krzywicki (11/3/2011)
Anyone know a good source for on-line SSIS help?I'm having a problem with the speed of my main SSIS load package and would love to find out what I'm doing wrong or how to improve the speed. There don't seem to be many SSIS experts here, though we're rife with nearly every other kind of SQL Server expert. Or am I just posting in the wrong area?
SSIS is one area I use the MSDN forums for. Most of the big name SSIS guys watch those forums more than here. I give them grief about that.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
November 3, 2011 at 12:18 pm
Jack Corbett (11/3/2011)
Stefan Krzywicki (11/3/2011)
Anyone know a good source for on-line SSIS help?I'm having a problem with the speed of my main SSIS load package and would love to find out what I'm doing wrong or how to improve the speed. There don't seem to be many SSIS experts here, though we're rife with nearly every other kind of SQL Server expert. Or am I just posting in the wrong area?
SSIS is one area I use the MSDN forums for. Most of the big name SSIS guys watch those forums more than here. I give them grief about that.
Good to know. Brandie has given me some good advice/things to try. If those don't give me the kind of results I'm looking for, I'll try MSDN and Andy Leonard's site.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
November 3, 2011 at 12:42 pm
Brandie Tarvin (11/3/2011)
Quick question. Has anyone else been approached by John Millward of Callidus Technology Limited for permission to use your SQL Articles on a social networking site he's putting together?The site isn't up yet. It is, in his words:
Effectively this is going to create a social network for those people within public sector organisations who have an interest in the production of reliable and trusted information. There is a situation over here where public funds are tight and our aim is to create an online community for sharing ideas and developments around producing such information. Primarily the systems used are increasingly SQL Server based with a move away from Oracle. There are few SQL skills employed permanently within these organisations so access to reliable and accurate technical articles such as yours would provide a useful resource.
I'm having a hard time grasping why a social networking site would be putting technical articles on it. I've been invited to join the community, which would be nice if I had time. And the fact that he's asking permission actually scores him bonus points.
But I'm going back and forth on giving permission. Partly because the site isn't complete yet and I can't see how my articles would be used. But mainly because there are so many SQL experts around the world, including you lot, and I wouldn't classify myself so highly yet (so much more for me to learn).
So, if he's asked you, please let me know. That will make me feel so much better about this whole thing.
Honestly, I think of SSC as a social/professional networking site with technical articles on it.
It may not follow the format that Facebook, et al, use, and may not have formal Friend/Link/Hate/Whatever buttons, but by function, it's about networking people together, and it's "social" and "professional" (at least most of the time).
I haven't been asked, unless it ended up in my spam folder. That's the most likely result if I have been, so no way to say either direction. Probably simply haven't been asked.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 3, 2011 at 12:58 pm
Brandie Tarvin (11/3/2011)
Sean Lange (10/3/2011)
This one (http://codevc.com/19244_A_The_WebGrid_Helper_-_Making_Selections.aspx) is a classic. The images are replaced with "Thief" image because they were lifted. The link in the article to "My previous article" even points correctly to the domain where the images were stolen from. Sheesh!!Okay, how did they get that to work? I'd love to put it on some of my stuff.
it's because the article used a relative reference to link the images, and the thief actually used the image as a link rather than copying them to a local resource. I can't imagine that's really an option most of the time, but pretty damn funny, that's for sure. I assume the original author changed the link on their own posted copy to a real image, and just saved the thief image with the old name.
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
November 3, 2011 at 1:00 pm
Stefan Krzywicki (11/3/2011)
Jack Corbett (11/3/2011)
Stefan Krzywicki (11/3/2011)
Anyone know a good source for on-line SSIS help?I'm having a problem with the speed of my main SSIS load package and would love to find out what I'm doing wrong or how to improve the speed. There don't seem to be many SSIS experts here, though we're rife with nearly every other kind of SQL Server expert. Or am I just posting in the wrong area?
SSIS is one area I use the MSDN forums for. Most of the big name SSIS guys watch those forums more than here. I give them grief about that.
Good to know. Brandie has given me some good advice/things to try. If those don't give me the kind of results I'm looking for, I'll try MSDN and Andy Leonard's site.
#sqlhelp and #ssishelp on twitter too.
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
November 3, 2011 at 1:08 pm
jcrawf02 (11/3/2011)
Stefan Krzywicki (11/3/2011)
Jack Corbett (11/3/2011)
Stefan Krzywicki (11/3/2011)
Anyone know a good source for on-line SSIS help?I'm having a problem with the speed of my main SSIS load package and would love to find out what I'm doing wrong or how to improve the speed. There don't seem to be many SSIS experts here, though we're rife with nearly every other kind of SQL Server expert. Or am I just posting in the wrong area?
SSIS is one area I use the MSDN forums for. Most of the big name SSIS guys watch those forums more than here. I give them grief about that.
Good to know. Brandie has given me some good advice/things to try. If those don't give me the kind of results I'm looking for, I'll try MSDN and Andy Leonard's site.
#sqlhelp and #ssishelp on twitter too.
That would require me to get on Twitter. 🙂
I've been told many times I should do that, but I keep putting it off. My favorite musician just got on Twitter, so that might finally push me to get on there as well.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
November 3, 2011 at 1:33 pm
Stefan Krzywicki (11/3/2011)
jcrawf02 (11/3/2011)
Stefan Krzywicki (11/3/2011)
Jack Corbett (11/3/2011)
Stefan Krzywicki (11/3/2011)
Anyone know a good source for on-line SSIS help?I'm having a problem with the speed of my main SSIS load package and would love to find out what I'm doing wrong or how to improve the speed. There don't seem to be many SSIS experts here, though we're rife with nearly every other kind of SQL Server expert. Or am I just posting in the wrong area?
SSIS is one area I use the MSDN forums for. Most of the big name SSIS guys watch those forums more than here. I give them grief about that.
Good to know. Brandie has given me some good advice/things to try. If those don't give me the kind of results I'm looking for, I'll try MSDN and Andy Leonard's site.
#sqlhelp and #ssishelp on twitter too.
That would require me to get on Twitter. 🙂
I've been told many times I should do that, but I keep putting it off. My favorite musician just got on Twitter, so that might finally push me to get on there as well.
What? New Kids are on Twitter? :w00t::hehe:
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
November 3, 2011 at 1:35 pm
jcrawf02 (11/3/2011)
Stefan Krzywicki (11/3/2011)
jcrawf02 (11/3/2011)
Stefan Krzywicki (11/3/2011)
Jack Corbett (11/3/2011)
Stefan Krzywicki (11/3/2011)
Anyone know a good source for on-line SSIS help?I'm having a problem with the speed of my main SSIS load package and would love to find out what I'm doing wrong or how to improve the speed. There don't seem to be many SSIS experts here, though we're rife with nearly every other kind of SQL Server expert. Or am I just posting in the wrong area?
SSIS is one area I use the MSDN forums for. Most of the big name SSIS guys watch those forums more than here. I give them grief about that.
Good to know. Brandie has given me some good advice/things to try. If those don't give me the kind of results I'm looking for, I'll try MSDN and Andy Leonard's site.
#sqlhelp and #ssishelp on twitter too.
That would require me to get on Twitter. 🙂
I've been told many times I should do that, but I keep putting it off. My favorite musician just got on Twitter, so that might finally push me to get on there as well.
What? New Kids are on Twitter? :w00t::hehe:
I said "musician"! Not whatever they are. 😛
Robyn Hitchcock is the musician. His lyrics are weird enough that his twittering might be amusing as well.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
November 3, 2011 at 2:33 pm
I just found a stored procedure from my predecessor at my current job, and it just kind of made my jaw drop in the elegant simplicity of it's complete stupidity.
It looked basically like this:
create proc dbo.MyProc
as
set nocount on;
declare @TableVariable (
columns, including PK definition)
insert into @TableVariable
select distinct columns
from tables
where business rules
select distinct * from @TableVariable
The actual query involves several computed columns and joins between four different tables. It works as designed.
I discovered this query because it started to throw a primary key violation on what everyone here thought was just a Select statement. Note that it doesn't actually DO anything with the table variable except select from it. No data modifications. Not even a Where clause on the select.
How does someone come up with a design like that? Why? What weird logic process leads to doing all that just to select some data.
Sorry, had to vent, and thought you guys might get some entertainment out of this.
PS: Even our business analyst thought this one was a bit odd in terms of working a Select that way. He doesn't even write code.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 3, 2011 at 2:42 pm
GSquared (11/3/2011)
I just found a stored procedure from my predecessor at my current job, and it just kind of made my jaw drop in the elegant simplicity of it's complete stupidity.It looked basically like this:
create proc dbo.MyProcas
set nocount on;
declare @TableVariable (
columns, including PK definition)
insert into @TableVariable
select distinct columns
from tables
where business rules
select distinct * from @TableVariable
The actual query involves several computed columns and joins between four different tables. It works as designed.
I discovered this query because it started to throw a primary key violation on what everyone here thought was just a Select statement. Note that it doesn't actually DO anything with the table variable except select from it. No data modifications. Not even a Where clause on the select.
How does someone come up with a design like that? Why? What weird logic process leads to doing all that just to select some data.
Sorry, had to vent, and thought you guys might get some entertainment out of this.
PS: Even our business analyst thought this one was a bit odd in terms of working a Select that way. He doesn't even write code.
That is kind of like asking for a glass of water and watching the person getting it for you take two glasses out of the cupboard. Fill the first glass and the pour the contents into the second glass. You just have to ask yourself WTF??? Thanks for sharing, glad to know I am not the only person to come after a complete knucklehead.
_______________________________________________________________
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/
November 3, 2011 at 3:10 pm
GSquared (11/3/2011)
I just found a stored procedure from my predecessor at my current job, and it just kind of made my jaw drop in the elegant simplicity of it's complete stupidity.It looked basically like this:
create proc dbo.MyProcas
set nocount on;
declare @TableVariable (
columns, including PK definition)
insert into @TableVariable
select distinct columns
from tables
where business rules
select distinct * from @TableVariable
The actual query involves several computed columns and joins between four different tables. It works as designed.
I discovered this query because it started to throw a primary key violation on what everyone here thought was just a Select statement. Note that it doesn't actually DO anything with the table variable except select from it. No data modifications. Not even a Where clause on the select.
How does someone come up with a design like that? Why? What weird logic process leads to doing all that just to select some data.
Sorry, had to vent, and thought you guys might get some entertainment out of this.
PS: Even our business analyst thought this one was a bit odd in terms of working a Select that way. He doesn't even write code.
I've so far cleaned 5 of these out of a client's code.
SELECT <lots of columns> INTO #Temp FROM <complex mess of joins>
SELECT * FROM #Temp
DROP TABLE #Temp
And I'm not obfuscating the temp table's name. It really is called #temp in every case. And they wonder why TempDB is 4 times the size of the user database...
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
November 3, 2011 at 3:22 pm
GSquared (11/3/2011)
I just found a stored procedure from my predecessor at my current job, and it just kind of made my jaw drop in the elegant simplicity of it's complete stupidity.It looked basically like this:
create proc dbo.MyProcas
set nocount on;
declare @TableVariable (
columns, including PK definition)
insert into @TableVariable
select distinct columns
from tables
where business rules
select distinct * from @TableVariable
The actual query involves several computed columns and joins between four different tables. It works as designed.
I discovered this query because it started to throw a primary key violation on what everyone here thought was just a Select statement. Note that it doesn't actually DO anything with the table variable except select from it. No data modifications. Not even a Where clause on the select.
How does someone come up with a design like that? Why? What weird logic process leads to doing all that just to select some data.
Sorry, had to vent, and thought you guys might get some entertainment out of this.
PS: Even our business analyst thought this one was a bit odd in terms of working a Select that way. He doesn't even write code.
I can only think of one reason - and the only reason I can actually think of it is because I just had to write something similar. (Similar, I said. Not exactly like.) Before you all start throwing tomatoes and other rotten fruit at me...
I have a situation where one of the applications I don't manage makes calls to SQL to pull data. I can stage the data for that app in a matter of ms. However, it can take that program 10-15 minutes to actually process it - the wait stats on the process can be amazingly annoying. Oh - and that program asks for new data literally every 5 minutes.
What was originally happening was that because that app can't consume the data anywhere near as quickly as I can send it, I had locks sitting on tables that other people were trying to use, but couldn't get to until the app was finished. (I got our dev folks to radically change their design, but ultimately I'm passing data to a noSQL environment that can't do set-based reads. Long story, many details, options, and other attempts to fix the problem left out of the mix here.)
The end fix was very similar to the code above. I'm basically having that program call a stored proc with a couple of parameters - then loading the data that will be returned into a table variable. Quick select against my normal db tables, locks released quickly, happy users. Then, when I select from that table variable, that connection can sit and do it's row by row chunking through the data I sent it to its heart's content without sending my side of the universe into block and deadlock hell.
So - I had a very practical reason to write something along those lines (and if someone wants to show me a better way to handle that situation, I'm happy hear it - just because I found something that both works and makes my server happy doesn't mean I'm convinced that it's either the only way or the best way to solve a particular challenge.)
I'm curious as to what the proc you found is being used for...
-Ki
November 3, 2011 at 3:48 pm
GSquared (11/3/2011)
I just found a stored procedure from my predecessor at my current job, and it just kind of made my jaw drop in the elegant simplicity of it's complete stupidity.It looked basically like this:
create proc dbo.MyProcas
set nocount on;
declare @TableVariable (
columns, including PK definition)
insert into @TableVariable
select distinct columns
from tables
where business rules
select distinct * from @TableVariable
The actual query involves several computed columns and joins between four different tables. It works as designed.
I discovered this query because it started to throw a primary key violation on what everyone here thought was just a Select statement. Note that it doesn't actually DO anything with the table variable except select from it. No data modifications. Not even a Where clause on the select.
How does someone come up with a design like that? Why? What weird logic process leads to doing all that just to select some data.
Sorry, had to vent, and thought you guys might get some entertainment out of this.
PS: Even our business analyst thought this one was a bit odd in terms of working a Select that way. He doesn't even write code.
That is pure awesomeness
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
November 3, 2011 at 4:19 pm
SQLRNNR (11/3/2011)
GSquared (11/3/2011)
I just found a stored procedure from my predecessor at my current job, and it just kind of made my jaw drop in the elegant simplicity of it's complete stupidity.It looked basically like this:
create proc dbo.MyProcas
set nocount on;
declare @TableVariable (
columns, including PK definition)
insert into @TableVariable
select distinct columns
from tables
where business rules
select distinct * from @TableVariable
The actual query involves several computed columns and joins between four different tables. It works as designed.
I discovered this query because it started to throw a primary key violation on what everyone here thought was just a Select statement. Note that it doesn't actually DO anything with the table variable except select from it. No data modifications. Not even a Where clause on the select.
How does someone come up with a design like that? Why? What weird logic process leads to doing all that just to select some data.
Sorry, had to vent, and thought you guys might get some entertainment out of this.
PS: Even our business analyst thought this one was a bit odd in terms of working a Select that way. He doesn't even write code.
That is pure awesomeness
I personally am quite impressed at the double distinct. When in doubt, overkill!
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 3, 2011 at 4:22 pm
Anyone else been having serious problems with posting today? Edits, quotes, even just add reply is being feisty. Won't seem to trigger the post creation page, then it takes two or three tries of 'post this' to get it to go through, and half the time it won't take.
Getting annoying.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 15 posts - 31,366 through 31,380 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply