September 17, 2014 at 12:56 pm
Jeff Moden (9/17/2014)
Luis Cazares (9/17/2014)
Do I see some personal/professional growth in these words? I really hope so.This Post is closed. I will research the issue.
Thanks.
Out of context, it looks more like a frustrated poster. Do you have a link for this?
Almost, Jeff. That would be a frustrating poster. http://www.sqlservercentral.com/Forums/Topic1614527-1550-1.aspx
September 17, 2014 at 1:02 pm
Roy Ernest (9/17/2014)
I got someone asking if Cursor will work fast on memory based objects.It felt like the OP would upgrade to SQL 2014 so that he/she can make the cursor run faster.
LOL. That's a new one. 😀
_______________________________________________________________
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/
September 17, 2014 at 1:14 pm
Roy Ernest (9/17/2014)
I got someone asking if Cursor will work fast on memory based objects.It felt like the OP would upgrade to SQL 2014 so that he/she can make the cursor run faster.
It could. It could also be just as bad. Boils down to what objects are involved and how complex the cursor might be.
In the end, a set based would most likely be better for them. Sell them on the idea that 2014 has a much improved cardinality estimator that can make a lot of queries run faster by itself.:-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
September 17, 2014 at 1:16 pm
I advised the OP to go for Set based. I hope he does not think that SQL 2014 will magically get everything to run faster.
-Roy
September 17, 2014 at 1:20 pm
Ahhh but SQL 2014 does come with a turbo button.:w00t:
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
September 17, 2014 at 1:21 pm
Sean Lange (9/17/2014)
Ed Wagner (9/17/2014)
Sean Lange (9/17/2014)
Greg Edwards-268690 (9/17/2014)
Fine line with falling off the bone and a very slight tug off the bone but it comes off clean.I can see where the 'one bite' can lead to sensory overload.
When you see them take a second bite, is the ones I'd like to try.
KC neighbor lives (and sometimes dies) by spare ribs.
I tend to like St. Louis cut on them a lot more - gets rid of the 'extras' so you can just eat.
We did a friendly contest last year.
Everyone said baby backs, he brought spare ribs.
Then got inventive with some kind of raspberry sauce.
He kind of died a bit that day - even his wife voted for someone else.
And didn't even cook in this year's event.
For those not having a smoker, but a grill, I find steaming baby backs in an oven (about 275 for about 3 hours), then finishing on the grill a good alternative.
Baking dish, rack to hold them above the water (or apple juice), with some liquid smoke and some tabasco, works well.
Cover dish with foil, and be sure to check the liquid hasn't boiled off once in awhile.
Works great in our cold winters, where my smaller smoker doesn't work very well.
Wow raspberry sauce does not sound great to me. But as I said earlier I don't like to put sauce on ribs. I want to taste the ribs. Also I consider sauce as a condiment, not an ingredient. Way too often I see bbq slathered in sauce which kills the awesome flavor of the bark. I have had many people come over ribs and say "I will try these without sauce but I usually like lots of sauce" to then hear them say "you are right, these don't need any sauce".
The two things I do not like about spares. They are really fatty and the big chunks of cartilage are just nasty.
The raspberry sauce doesn't sound good to me either. Then again, I don't really like the sweet sauces either. I'm with Sean on the rub...that's all you need. If you wanted to make sauced ribs, then I'd only do it as a glaze during the last 10 or 20 minutes of smoking. Any fruit-based sauce will have a much higher sugar content and anything longer than 20 minutes would cause all that sugar to caramelize too much. Caramelization is a good thing, but not at that level. I generally save any sauce as a dipping-type sauce on the table for those people who really need it. If smoked properly, I find that sauce isn't needed at all.
I don't do spare ribs at all. There's too much waste and not enough meat. The cartilage at the end is a complete waste. You're better off to go with a pork shoulder.
The next time I'm over at my friend's house, I'll get a picture of his smoker. It's quite an elaborate setup and produces fantastic BBQ. I can't do the smoked macaroni and cheese like he can because mine's powered by propane and gets too hot. Of course, he uses lots of heavy cream and several different cheeses and the fat does an amazing job of soaking up all that smokey flavor. Like most pitmasters (amateur and professional) he has his own rub mixture.
I can get the heat on mine insanely low (around 150-175F). Does that get close? Not sure how well the smoke would be off the chips that low however.
Almost. Because his can run at lower temperatures than ours, he runs it at about 120 for macaroni and cheese. It's just enough to melt the base ingredients together slowly and infuse everything with smoke slowly. Then he mixes in the pre-cooked macaroni and runs it up higher to smoke for about 45 minutes to meld everything together. For him, it really is an art form.
When I get the picture and post it, you'll understand how he has it so well-controlled. There's dampers for controlling everything. Like I said, it's an art.
September 17, 2014 at 2:04 pm
SQLRNNR (9/17/2014)
Roy Ernest (9/17/2014)
I got someone asking if Cursor will work fast on memory based objects.It felt like the OP would upgrade to SQL 2014 so that he/she can make the cursor run faster.
It could. It could also be just as bad. Boils down to what objects are involved and how complex the cursor might be.
In the end, a set based would most likely be better for them. Sell them on the idea that 2014 has a much improved cardinality estimator that can make a lot of queries run faster by itself.:-D
I wrote a cursor this week. I needed to run sp_estimate_data_compression_savings against every table in the database. I probably could have opened the proc & figured out what tables it was querying and used that to write a set based query and I might in the future, but this works well enough for now.
--------------------------------------
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
September 17, 2014 at 2:05 pm
I know people who frequent this list will mention when they're looking for a new position. Does anyone happen to be looking for something in the Boston area now? The company I'm working for is in Waltham and we're hiring.
--------------------------------------
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
September 17, 2014 at 2:14 pm
Jeff Moden (9/17/2014)
Luis Cazares (9/17/2014)
Do I see some personal/professional growth in these words? I really hope so.This Post is closed. I will research the issue.
Thanks.
Out of context, it looks more like a frustrated poster. Do you have a link for this?
Aw, Silver Spoon. Yes, frustrated as he wasn't getting the answer he wanted to hear.
September 17, 2014 at 2:18 pm
Stefan Krzywicki (9/17/2014)
I know people who frequent this list will mention when they're looking for a new position. Does anyone happen to be looking for something in the Boston area now? The company I'm working for is in Waltham and we're hiring.
Do you offer visa sponsorship and/or relocation help?
September 17, 2014 at 2:22 pm
Luis Cazares (9/17/2014)
Stefan Krzywicki (9/17/2014)
I know people who frequent this list will mention when they're looking for a new position. Does anyone happen to be looking for something in the Boston area now? The company I'm working for is in Waltham and we're hiring.Do you offer visa sponsorship and/or relocation help?
I don't think we do, but I'll check. Those are good questions, thank you.
--------------------------------------
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
September 17, 2014 at 3:12 pm
ROFLMAO!!!! I just got a dev ticket to look into a website that was written and deployed about 3 years before I got here. The ONLY page on the entire site that does anything more than deliver static content is a page with a form that allows the user to upload a file. I was told this is really important because the last submission received was in 2010. Obviously mission critical functionality here. Add to that it is written in classic asp. I opened the thing for the first time ever today and it is wide open the sql injection, javascript injection and probably more. There is only 1 way to fix this, take it out to the pasture and shoot it. 😛
_______________________________________________________________
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/
September 17, 2014 at 3:18 pm
Sean Lange (9/17/2014)
ROFLMAO!!!! I just got a dev ticket to look into a website that was written and deployed about 3 years before I got here. The ONLY page on the entire site that does anything more than deliver static content is a page with a form that allows the user to upload a file. I was told this is really important because the last submission received was in 2010. Obviously mission critical functionality here. Add to that it is written in classic asp. I opened the thing for the first time ever today and it is wide open the sql injection, javascript injection and probably more. There is only 1 way to fix this, take it out to the pasture and shoot it. 😛
Please do shoot it!
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
September 17, 2014 at 3:26 pm
Sean Lange (9/17/2014)
ROFLMAO!!!! I just got a dev ticket to look into a website that was written and deployed about 3 years before I got here. The ONLY page on the entire site that does anything more than deliver static content is a page with a form that allows the user to upload a file. I was told this is really important because the last submission received was in 2010. Obviously mission critical functionality here. Add to that it is written in classic asp. I opened the thing for the first time ever today and it is wide open the sql injection, javascript injection and probably more. There is only 1 way to fix this, take it out to the pasture and shoot it. 😛
Is this a public facing website? Care to send me a link? 😉
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
September 17, 2014 at 3:34 pm
WayneS (9/17/2014)
Sean Lange (9/17/2014)
ROFLMAO!!!! I just got a dev ticket to look into a website that was written and deployed about 3 years before I got here. The ONLY page on the entire site that does anything more than deliver static content is a page with a form that allows the user to upload a file. I was told this is really important because the last submission received was in 2010. Obviously mission critical functionality here. Add to that it is written in classic asp. I opened the thing for the first time ever today and it is wide open the sql injection, javascript injection and probably more. There is only 1 way to fix this, take it out to the pasture and shoot it. 😛Is this a public facing website? Care to send me a link? 😉
Not really. 😛 Not wanting to turn something that I can easily blow off for at least 4 years into something I have to fix immediately. It is public facing and truly horrible. It just takes the text boxes and build a pass through query blindly. Not even an attempt made to protect anything. Add to that the ability to upload files with no checking on file type or anything at all. The URL alone is enough to gain access to the network and I am not handing out that key. YUCK!!!
_______________________________________________________________
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/
Viewing 15 posts - 45,736 through 45,750 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply